Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Cannot connect to SQL Server
0 views
Skip to first unread message
Charlie J
Feb 10, 2010, 11:12:01 AM2/10/10
to
I have a machine running Server 2003 R2 with SQL Server running. I have a
workstation on the same network running Vista Ultimate. Up until about three
weeks ago (middle of January) I was able to connect to the server with no
issues. Then one day I cannot connect to SQL Server or to access the server
via RDC. I can ping the computer and can map drives in both directions. I
can RDC to other machines that I can connected to via VPN and via the
Internet so it is not the work station. Something changed on the server and
I cannot figure out what it is. I have the server firewall turned off as
well as all RAS services. I have updated the server with all of the latest
updates. Can anyone give me some hints as to where to look next.
workstation on the same network running Vista Ultimate. Up until about three
weeks ago (middle of January) I was able to connect to the server with no
issues. Then one day I cannot connect to SQL Server or to access the server
via RDC. I can ping the computer and can map drives in both directions. I
can RDC to other machines that I can connected to via VPN and via the
Internet so it is not the work station. Something changed on the server and
I cannot figure out what it is. I have the server firewall turned off as
well as all RAS services. I have updated the server with all of the latest
updates. Can anyone give me some hints as to where to look next.
--
Thanks, Charlie
Charlie J
Feb 10, 2010, 1:17:03 PM2/10/10
to
I ran across a help topic that said to try using the IP address instead of
the computer name if I was having an issue with RDC. I tried the IP address
and now I can connect both via RDC and SQL Management Studio to the server.
I am not sure what happened on the server that would have started to block
the computer name from working. I am up now so this is not a pressing issue.
If anyone has an idea of what might have happened I would appreciate hearing
it.
the computer name if I was having an issue with RDC. I tried the IP address
and now I can connect both via RDC and SQL Management Studio to the server.
I am not sure what happened on the server that would have started to block
the computer name from working. I am up now so this is not a pressing issue.
If anyone has an idea of what might have happened I would appreciate hearing
it.
--
Thanks, Charlie
William Vaughn (MVP)
Feb 15, 2010, 12:23:50 PM2/15/10
to
If you can connect with the IP port then the problem might be with the DNS.
That is, the name you're using for the Server/instance is not being resolved
to the right IP port. This is handled by the DNS service and the SQL Browser
service.
That is, the name you're using for the Server/instance is not being resolved
to the right IP port. This is handled by the DNS service and the SQL Browser
service.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________
"Charlie J" <Char...@discussions.microsoft.com> wrote in message
news:50A42600-873B-41E6...@microsoft.com...
0 new messages