Hi,
Does someone have a link where I can read on how to access my remote server's sql server '08 installation?
update
I want to access sql server 2008 from management studio on a remote server.
Remote access is disabled by default!
A:
Could you please expand your question? How do you want to access it? With SQL management studio? Doesn't specifying the computer name work? Are you able to access it locally? Is there anything specific about that it is 2008 SQL?
badbadboy
2008-11-17 20:57:36
A:
I am not a SQL guru, but I would suggest this link if you haven't tried yet...
http://www.google.no/search?q=enable+remote+access+in+sql+server+2008
badbadboy
2008-11-17 21:16:19
+2
A:
badbadboy's link would be a good start
- Enable remote connection in SSMS
- Check for TCP/IP, Named Pipe enabled in Configuration Manager
- Check the Firewall
And double check you're connecting to the correct server\instance name, and PORT
jerryhung
2008-11-20 16:41:20