SQL error -Index was outside the bounds of the array. (Microsoft.SqlServer.Express.Smo) in SQL Server

Hi friends, when i was trying to create/restore database to SQL Server 2014 ,i got an error “Index was outside the bounds of the array”. So i decided to find a solution for the error. I connected SQL Server 2014 with SQL Server Management Studio Express (SSMSE). As per Microsoft documentation,SSMSE is used for  SQL […]

Instance Failure.(system.data) Error in SQL Server 2014

Hi, One day when i started to connect SQL Server 2014 instance using SQL Server Management Studio ,i got an error message “Instance Failure.(system.data) “.So i planned to fix the error by checking the system. So first I checked how many SQL Server instances are running in my system .I found two SQL Server instances […]

SQL error: 40 – Could not open a connection to SQL Server fixed

” A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 – Could not open a connection to SQL Server) […]

SQL error ” Specified cast is not valid (SqlManagerUI) ” in SQL Server 2014 Database Restore

Hi friends,One day, one of my friend gave me a database backup for restoring. He was facing issue in restoring that database backup.he gets error ” Specified cast is not valid (SqlManagerUI) ” .So i tried to restore it in my SQL Server 2008 instance as shown below Step 1 Step 2 Step 3 Step […]

SQL Database Mail not sending error ” The mail could not be sent to the recipients because of the mail server failure.Cannot send mails to mail server”

Hi friends, One day morning I was configuring SQL Database Mail in SQL Server 2014 installed on my laptop.I tried to send SQL test mail but when i login into my gmail account and checked inbox ,i couldn’t find any mail.So i checked Database Mail log to find error message. ” The mail could not […]