Connect to Remote Server [modified]

[realJSOP]

I'm on a WORKGROUP LAN at home, and I want to connect to an instance of SQL Server 2005 Express on one of the other boxes on the network. I have already enabled remote connections on that instance of SQL Server and restarted the service. When I try to connect, it tells me this: TITLE: Connect to Server ------------------------------ Cannot connect to HTPC. ------------------------------ ADDITIONAL INFORMATION: 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) (Microsoft SQL Server, Error: 2)

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

modified on Saturday, March 27, 2010 11:52 AM

[i j russell]

Have you also enabled Named Pipes through the Configuration Manager?

[realJSOP]

Yeah. Could it be a user account problem? When I try to connect (using Windows Auth), it uses my local box's user account.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[i j russell]

Have you got Mixed Authentication set in the Sql Server Express instance? If so, can you connect using non-windows authentication? I noticed that the message said that it can't find instance HTPC; Is that the name of the instance or is it HTPC\SQLEXPRESS?

[realJSOP]

i.j.russell wrote:

Have you got Mixed Authentication set in the Sql Server Express instance? If so, can you connect using non-windows authentication?

No, but do I want to use non-windows authentication?

i.j.russell wrote:

I noticed that the message said that it can't find instance HTPC; Is that the name of the instance or is it HTPC\SQLEXPRESS?

HTPC is the machine name. The server is HTPC\SQLEXPRESS.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

[i j russell]

The reason for asking about mixed mode authentication is that if you can connect using a connectionstring like this; Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword; but not like this; Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; then you do have a permissions issue. However, most connection problems are due to incorrectly naming the server or database. The more things we can discount, the easier it will be to fix.

[realJSOP]

This is almost a non-issue, as I have halfway decided to use SqlLite instead. Thanks anyway. :)

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001