gtrapp
asked on
Cannot connect to [Local Server\SQLExpress
I have installed SQL Express 2005 Toolkit version. When I connect to my local server, I get the following 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
In the SQL Server Config Manager, I have TCP/IP and Named Pipes enabled as the Client Protocols. There is nothing listed under the SQL Server 2005 Services and SQL Server 2005 Network Configurations.
Any advice would be much appreciated,
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
In the SQL Server Config Manager, I have TCP/IP and Named Pipes enabled as the Client Protocols. There is nothing listed under the SQL Server 2005 Services and SQL Server 2005 Network Configurations.
Any advice would be much appreciated,
What are you using to try to connect?
ASKER
SQL Management Studio Express.
If you type "./" for your server name does that work? Also, check the Surface Area Configuration tool to make sure everything is enabled.
ASKER
When I use ./, I get the 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 connectoin to SQL Server) Error 2.
When I use the surface area configuration for features or the surface area configuratoin for Services and connections, I get the follow error:
No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer (SQLSAC).
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 connectoin to SQL Server) Error 2.
When I use the surface area configuration for features or the surface area configuratoin for Services and connections, I get the follow error:
No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer (SQLSAC).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, that fixed the problem.
Good deal.