Post reply

Unable to connect to SQL Server 2005 Express.

  • September 17, 2010 at 12:29 am

    #140668

    Hi All,

    I am unable to connect to SQL Server 2005 Express. When i try to connect i specify the server name as IPAddress\SQLExpress, the error message thrown is error 26.However when i try to connect using ServerName\SQLExpress it gets connected without any issues.

    Can somebody please help me out on this or is this an issue with the Express edition of SQL Server 2005?

    With Thanks,

    Satnam

  • September 17, 2010 at 12:35 am

    #1222757

    Enable TCP/IP protocol using SQL Server Configuration Manager.

  • September 17, 2010 at 12:42 am

    #1222759

    Thanks for that Suresh. TCP/IP is already enabled on the server.

  • September 17, 2010 at 3:06 am

    #1222830

    Is TCP/IP enabled under SQL Server Network Configuration for the SQLEXPRESS instance?

    Note that after enabling the protocol, the service needs to be restarted.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply