1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

SQL Server 2005 Express: Cannot connect to Server Name

Discussion in 'SQL Server' started by newphpcoder, Sep 28, 2010.

  1. newphpcoder

    newphpcoder New Member

    Joined:
    Sep 24, 2010
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Web Programmer
    Location:
    Philippines
    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.
     
  2. mail.yuva

    mail.yuva New Member

    Joined:
    Jan 10, 2011
    Messages:
    44
    Likes Received:
    9
    Trophy Points:
    0
    Occupation:
    Software Developer
    Location:
    Coimbatore
    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.aspx?scid=kb;EN-US;914277
     
  3. mountainman

    mountainman Banned

    Joined:
    Feb 6, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    0
    Yes i agree with Yuva... that's a good explanation.
     

Share This Page