Having problems connecting to SQL Server 2008 remotely

342195 pts.
Tags:
Server Connection Failed
SQL Server 2008
Visual Studio 2010
I am trying to connect to my database in Visual Studio 2010 using the named instance by

    123.123.123.123/instanceName

But, I get the following error message:

        error provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server

I have the following aspects enabled:
    open Port 80, 1433, 1434 on router
    allow Port 80, 1433, 1434 through Firewall (UDP, TCP)
    allow Program Sqlsvr.exe, SqlBrowser.exe through Firewall
    server server (instanceName), SQL Server Browser, Named Pipes, TCP/IP
    enabled Remote Connection in SQL Server Management

I’ve followed the steps here: http://technet.microsoft.com/en-us/library/cc646023.aspx, but to no avail.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following