Saturday, July 14, 2012

Fixing Instance Failure when connecting to SQL Server 2005/2008 Express

As the title says Instance Failure when connecting to SQL Server 2005/2008 Express as shown in the below image


















When connecting to SQL Server by mistake we may get this ERROR. The error connection string is as shown below.



EX :-


 In the Above image you can see the Difference between the two connections.
So by placing a backward slash as shown in the above image we get the ERROR Instance Failure.

To fix the error we can remove one backward slash as shown in the above image.