Link to home
Start Free TrialLog in
Avatar of rabpwh1000
rabpwh1000

asked on

SQL Server - problem connecting to database engine from management studio

Windows server 2008 R2 SP1
MS SQL Management Studio - ver 10.0.6241.0
Trying to connect to a SQL Express database.

I am trying to connect to a database engine through the management studio.

The connection screen allows the selection of the server I am looking for, but the Authentication is set to Windows Authentication and user name and password fields are greyed out. When I try and connect with these credentials the authentication fails and returns a Cannot connect to server message.  Detailed Message states: A network related or instance specific error has occurred while establishing a connection. The server was not found or was not accessible. Also get a Named Pipes Provider Error 40 Could not open a connection to SQL server .NET SqlClient Data Provider.

The management studio is on the local machine and I have verified the instance name.

Is there a way of resetting the credentials? or  anything else I should do to gain a connection?


Thanks in advance
Avatar of arnold
arnold
Flag of United States of America image

To use integrated auth, the windows based account has to be part of the security settings on the server, you can change from Windows auth to SQL at which point you will be provided with the opportunity to enter an SQL login credentials.

Are you connecting locally or remote?
Check the server network configuration using configuration SQL server settings. To enable TCP access, check Windows firewall if enable to allow access....

Wht version of SQL and what version of management studio I being used?
Open Sql Server Configuration
--> Protocols for <INSTANCE>
--> TCP/IP --> IP Addresses(Tab).
Go to the last entry IP All and mention TCP Port 1433.
restart SQL Server (<INSTANCE>) using services.msc .
 
also Enable TCP/IP in SQL Server Configuration
ASKER CERTIFIED SOLUTION
Avatar of Daniel_PL
Daniel_PL
Flag of Poland image

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 rabpwh1000
rabpwh1000

ASKER

Thanks Daniel - You were correct the service was not running. I had mistaken the service I had been looking at for another instance.  Thanks everybody else for their comments