Tuesday, 9 September 2014

instance failure' error while connection string is correct

If you got the error "instance failure", that might be the error with your SQL Server instance..

Make sure your SQL Server instance(i.e MS SQLSERVER) is running, where you can check in Services list. to get into services list: open run dialog box and type: "services.msc" (without quotes) and hit Enter.

That takes you to services management console, where you can check whether your instance in running or not..
If the problem still persists, then try using: Data Source=.\SQLEXPRESS.

For Example