Clever Geek Handbook

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


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


source


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


source


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


source






More articles:


All Articles