Unanswered: Unable to connect to Server after SP4 installation (SQL 2000)
Yesterday, I installed SP4 for SQL Server 2000 and rebooted server. When I'm trying to connect remotely, getting message as server doesn't exist. But I'm able to connect to SQL Server from my laptop and also can ping.
Could anyone please help me? This is my first time experience with installation. Please help
I avoided SP4 altogether due to a drastic slowdown in many processes, especially with large tables (what took 1 minute took 2 hrs after SP4 upgrade) due to I/O waits (which appear as self blocking) via sp_who2.
Were you able to connect "remotely" before?
By "Remotely", do you mean from beyond a firewall? Or just from a different server on the same subnet?
Have you tried to specify the network protocol to be used from the client machine?
Are you timing out, or are you getting "Server does not exist" errors?
Our operations team who handle server related problems, did restarted couple of times but in vain. Now, they are coming back to me and asking what I have done to the server. I told them that I just installed SP4 and did nothing else.
I'm afraid if someone concludes that due to SP4, RDP got affected then my management will certainly ask me "You are DBA, don't you know that SP4 creates this problem?".
I'm not getting what all options that I have at this time.