SQL Server 2005 Express: Cannot connect to Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

SQL Server 2005 Express: Cannot connect to Server

Author

Topic

newphpcoder
Starting Member

23 Posts

Posted - 2010-09-28 : 04:29:43

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 where i can solve this problem..

Any help is highly appreciated..

Thank you in advance.

mikgri
Starting Member

39 Posts

Posted - 2010-09-28 : 13:41:05

check this article http://support.microsoft.com/kb/914277

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources