SQL Server 2005 Express: Cannot connect to Server Name

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • newphpcoder

    #1

    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:Serv ername\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.(Pr ovider: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.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Here, read this...

    Good Luck!!!


    ~~ CK

    Comment

    Working...