Unable to Connect to SQL Server 2005 Using TCP/IP

• Kenneth Igiri

  SSCertifiable

  Points: 5004

  More actions

  March 6, 2012 at 11:45 am

  #104133

  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

• ravi.der

  Ten Centuries

  Points: 1016

  More actions

  May 1, 2012 at 2:47 am

  #1481641

  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