Remote SQL Connections disabled?
Just curious, trying to run the application locally for testing against the sql server on appharbor and receiving this error:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Discussions are closed to public comments.
If you need help with AppHarbor please
start a new discussion.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
Support Staff 1 Posted by friism on 26 Jan, 2011 05:55 PM
The server should certainly be available remotely (and is for me). Have you tried connecting to it with SQL Server Management Studio?
2 Posted by joelmartinez on 26 Jan, 2011 05:57 PM
I'll have to double check again when I'm at home ... you know, I'll bet it's because I was trying to run it while connected to free wifi at starbucks, they're probably blocking ports or something.
Will let you know if it runs fine from home
Support Staff 3 Posted by friism on 27 Jan, 2011 04:27 AM
Closing this, let me know if you still can't access your database.
friism closed this discussion on 27 Jan, 2011 04:27 AM.
tt re-opened this discussion on 27 Jan, 2011 04:28 AM
Support Staff 4 Posted by tt on 27 Jan, 2011 04:28 AM
By the way, it can also be because it for whatever reason don't try to establish a TCP connection. If you change the server part of the connection string to include ",1433" right after the hostname, it should force a TCP connection.
tt closed this discussion on 27 Jan, 2011 04:28 AM.