Link to home
Start Free TrialLog in
Avatar of gtrapp
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,
Avatar of micahburnett
micahburnett

What are you using to try to connect?
Avatar of gtrapp

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.
Avatar of gtrapp

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).
ASKER CERTIFIED SOLUTION
Avatar of micahburnett
micahburnett

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gtrapp

ASKER

Thanks, that fixed the problem.
Good deal.