this happens after applying the SP3 on MSSQL Server 2000, I just can connect with SA login or DOMAIN\Administrators (built in) users, How can I reenable the Integrated Security connection?

Hey Hey... I discover that the server now just accepts connections for "SISTEM" not more for (private ip for the MMSQL Server), so Why this things happen? I was searching in the Service Pack documentation and never advice for this, so the big problem is that all the applications in connection string are like "Server=;Initial Catalog='dbblabla'..."

any way to achieve this?

We have subnets so the server "SISTEM" resolves and

I recently patch to SPIV



In your client's Programs / SQL Server start menu, look for

SQL Server Client configuration

and see if TCP/IP is an active protocol in the configuration.

Another (not probable, but theoretically possible) think you could check: does your server have multiple IP addresses associated to the network interface(s)? Maybe the name "SISTEM" resolves to a different IP addres. Try

nslookup sistem

and see if is returned as IP address.

Note: The current service pack for SQL Server 2000 is Service Pack 4, released in 2005. I strongly suggest using that service pack version, because it addreses some security issues.

  • yes we have 3 subnets – Jonathan Escobedo Jul 27 '09 at 7:19
  • prompt find and, also in the first lines tells something that DNS request time out, time out was 2 seconds, cant find the servername for the ip Timed out – Jonathan Escobedo Jul 27 '09 at 7:22
  • is there a difference in "ping" and "ping sistem"? – splattne Jul 27 '09 at 7:30
  • yes when I ping it works normally, but when I ping SISTEM it takes like 6 seconds to start ping normally – Jonathan Escobedo Jul 27 '09 at 7:58
  • if you do a "ping sistem" which ip address is shown? – splattne Jul 27 '09 at 9:17

Are you sure that you are connecting to the SQL Server via TCP? If you are it doesn't care what name you use to connect. If you try to connect, to the port and the port is listening it will respond.

What's the exact error that your users are getting?

And why are you just now installing SQL 2000 SP3?

  • I can connect using the hostname example : "MSSQL-SERV01" but I cant not do it with it private ip – Jonathan Escobedo Jul 27 '09 at 6:47
  • What's the exact error that you get when using the IP? – mrdenny Jul 28 '09 at 0:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.