Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer
yes we have 3 subnets – Angel 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 – Angel 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 – Angel 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?

share|improve this answer
I can connect using the hostname example : "MSSQL-SERV01" but I cant not do it with it private ip – Angel 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 posting your answer, you agree to the privacy policy and terms of service.

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