Unable to Connect to SQL Server 2005 Using TCP/IP

  • Good Day People,

    I have had the following experiene in the past week:

    An application is suddenly unable to connect to the QL sever instance using the SERVER NAME or IP ADDRESS of the HOST. I change the instance field on the application to (local) and the apliation connects. This behaviour is same for SSMS. Can connct with (local) but cant connect with the SERVERNAME. The confusiing thing is that this happens just fr a ehile and later on i can connect using the SERVERNAME.

    My aliases are same as before, the application is on the same host as the database instance. My version is below:

    Microsoft SQL Server 2005 - 9.00.3080.00 (Intel X86)

    Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • you must download service pack 4 patch from below link :

    http://www.microsoft.com/en-us/download/details.aspx?id=7218

    install in your pc.

    after installed restart your pc and then try.

    hope this will work for you 🙂

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

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