If you receive the following error message:
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)



You should specify your instance name behind (local), for example (local)\Pilot (if you installed SQL2005 by the Pilot instruction manual.)

INCLUDEPICTURE "http://support.griffid.com/faq/images/other/setup.JPG" \* MERGEFORMATINET 



If you have installed SQL2005 without using the manual, the default instance name generated by the installer is: SQLEXPRESS

In this case you should specify: (local)\SQLEXPRESS



If you don't know what instance name was used, you can install the SQL management studio. After opening Management Studio, you will see a connection window. Here your computer name and instance name are shown.