Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   SQL Server 2005 Express: Cannot connect to Server Name (http://www.go4expert.com/forums/sql-server-2005-express-connect-server-t23436/)

newphpcoder 28Sep2010 15:13

SQL Server 2005 Express: Cannot connect to Server Name
 
Good day!
I am newly in SQL Server 2005 and now I encountered error when i try to login. This is some of the information:

Microsoft SQL Server 2005 Express Edition

Server Type: Database Engine
Servername:Servername\MSFW
Authentication:SQL Server Authentication
Login: sa
Password:xxxx

and when i press the connect button the error appear:

Error:
Cannot connect to Servername\MSFW

Additional Informations:
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may becaused 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) (Microsoft SQL Server).

I have no idea how i can solve this problem..

Any help is highly appreciated..

Thank you in advance.

mail.yuva 25Feb2011 16:56

Re: SQL Server 2005 Express: Cannot connect to Server Name
 
Fix/Workaround/Solution:
Step 1) Make sure SQL SERVER is up and the instance you try to connect is running.
Step 2) Your system Firewall should not block SQL Server port.
Step 3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.
Step 4) Now follow this KB Article of MSDN depending on your server :
http://support.microsoft.com/default...b;EN-US;914277

mountainman 8Feb2012 20:15

Re: SQL Server 2005 Express: Cannot connect to Server Name
 
Yes i agree with Yuva... that's a good explanation.


All times are GMT +5.5. The time now is 10:50.