Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 192.168.0.3 (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=192.168.0.3;Initial Catalog='dbblabla'..."

any way to achieve this?

We have subnets so the server "SISTEM" resolves 192.168.0.3 and 172.16.104.180

I recently patch to SPIV

Thanks!

share|improve this question

2 Answers 2

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 192.168.0.3 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 192.168.0.3 and 172.16.104.180, also in the first lines tells something that DNS request time out, time out was 2 seconds, cant find the servername for the ip 192.168.0.3 Timed out –  Angel Escobedo Jul 27 '09 at 7:22
    
is there a difference in "ping 192.168.0.3" and "ping sistem"? –  splattne Jul 27 '09 at 7:30
    
yes when I ping 192.168.0.3 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 192.168.0.3 –  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

 
discard

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.