September 23, 2009 at 5:39 am
I have a number of SQL 2000 databases in use and can connect with no problem. This is the first SQL 2005 Express that I need to use. The database is loaded, and I can access using SQL Mgmt from the local server no problem. But when I attempt to connect from anywhere else, using SQL Mgmt Express, Query Analyzer, ODBC, or any other method, I get connection refused. Its not a login issue, AFAIK, I have mixed mode authentication set and tried using both Windows and SQL logins, but everything fails.
Using default instance SQLEXPRESS. (Is that required to connect?)
My guess is I have a setting somewhere I need to enable ? Suggestions ?
*****************************************************
MESSAGE:
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)
An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
September 23, 2009 at 7:48 am
SQL Express by default doesn't allow remote connections. Enable that in the server config or with sp_configure.
September 23, 2009 at 12:45 pm
Thanks. I finally found the setting I needed under Surface Scan settings. Duh. Seems like a dumb place to hide it.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply