Thursday, February 16, 2012

Cannot Connect to SQL 2000 on Win2k3 Server

I am having great difficulty connecting to my sql box, I
vpn'd in from work and connected via remote desktop,
setup the SQL connection locally, and connected fine,
which I am wondering if it was cause I was VPN'd in, but
I disconnected from remote desktop and was still able to
hit my sql server in enterprise manager. Then when I got
home tonight, logged on my XP machine and I cannot get my
sql registration to connect.
SQL Server does not exist or access denied ConnectionOpen
(Connect()
I have no idea what this means...I am just learning SQL
so this is all new to me...please help...I am on a home
network behind a linksys router, both my XP box and the
Win2k3 box are behind the router which has a dynamic ip
for the XP box, and a static one for the 2k3 box.On Windows 2003, if there are any instances of SQL Server installed that
are not on SP3 or higher, TCP will be disabled (there will be messages in
the event logs indicating this). In that case remote connections would fail
because by default clients try to connect with TCP. Upgrade all instances
on the box to SP3 then retry connecting. You can also try to connect from
the remote machines using named pipes (add np: before the machine\instance
in your connection string).
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment