Remote connections to sql08
Does anyone have a link where I can read how to access my SQL Server '08 installation on a remote server?
Update
I want to access SQL Server 2008 from management studio on a remote server.
Remote access is disabled by default!
+1
Blankman
source
to share
3 answers
the badbadboy link would be a good start
- Enable remote connection in SSMS
- Check TCP / IP, Named Pipe is enabled in Configuration Manager
- Check your firewall
And double check that you are connecting to correct server \ instance name and PORT
+2
jerryhung
source
to share
Could you expand your question? How do you want to access it? With SQL Management Studio? Does the computer name indicate? Can you access it locally? Is there anything specific about this being SQL 2008?
0
badbadboy
source
to share
I'm not a SQL guru, but I would suggest this link if you haven't tried it yet ...
http://www.google.no/search?q=enable+remote+access+in+sql+server+2008
0
badbadboy
source
to share