Weird problem of connecting to SQL Server
-
I have access through remote desktop to a server, and I just installed SQL Server 2005 on that server. Then I found I could not use Management Studio to connect to SQL Server. The weird part is that I can connect to it if I run Management Studio from my own workstation, but cannot connect if I run Management Studio from the server.
My SQL Server is using Windows Authentication, and I am using the same domain account on both my own workstation and the server.
Could you tell me what to do?
Thanks
-
How are you connecting to sql from SSMS on that server...
are you using ".", "localhost", "machinename", or "server.domain.com"...
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
Be sure you are trying to connect to the same server from both places as well. I've had people accidentally connect to the wrong instance, not being aware of it.
-
I tried both (localhost) and server-name. I also use server-name to connect to it from my workstation.
-
I can see how localhost would fail, but servername outta get it. Check that the machine name is what's also registered in SQL as local.
So select * from sysservers.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply