Database & SQL

Moderators: None (Apply to moderate this forum)
Number of threads: 1174
Number of posts: 2221

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
SQL Server 2005 Express: Cannot connect to Server Name Posted by newphpcoder on 28 Sept 2010 at 2:32 AM
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.



Report
Re: SQL Server 2005 Express: Cannot connect to Server Name Posted by OliviaSSLGuru on 15 Dec 2010 at 5:06 AM
Instead of MSFWyou need to give the name of the server with the extension.



 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.