Wednesday, March 28, 2012

How can I remote my sql server?

How do I get access to my server.
It keeps saying this.
I set yes to tcp
What port is it suposto be on?

Code Snippet

TITLE: Connect to Server

Cannot connect to gv.ns1.name.


ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476


BUTTONS:

OK

Verify that you have followed all the steps in these articles.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

|||Where is an FAQ I wrote on troubleshooting connection problems to SQL Server http://www.tek-tips.com/faqs.cfm?fid=5481|||I can't connect even to localhost.
So it has nothing to do with firewall.
Something in setting but i have no clue about this....|||Verify that the SQL Server is actually running. Check in the Services applet.|||I can connect though the computer.
Not though remote though.|||

So, if you can connect through the local computer, and not the remote computer, and you are certain that the configurations for remote connections are set correctly,

... and you say that you

can't connect even to localhost

what computer are you attempting to connect to remotely. (Clue: The remote computer is NOT known as 'localhost'.)

Please post your entire connection string.

|||Did you edit your lmhosts or hosts file? Doing remote connections, you need to resolve the IP address into a name.|||

Can you verify that you followed the instructions in this posting. Quick check list:

Make sure that TCP/IP is enabled for the instance (Use SQL Server Configuration Manager) If using a named instance, make sure that the SQL Server Browser server is running (Use SQL Server Configuration Manager) If using a named instance and you're running a firewall, make sure sqlservr.exe and sqlbrowser are added to the exception list.

No comments:

Post a Comment