Sql server connection(Login) using server authentication.

Question

I am not able to connect to the sql server 2008 r2 using server authentication. The Password for user sa is also correct.

 ..........It gives the follwoing error.

 

Cannot connect to ABHIJIT-PC.

===================================

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) (.Net SqlClient Data Provider)

 

Answer 1

Check that if sql server service is running on your pc.

Answer 2

Hi Abhijit,


During Installation of SQL Server you need specify in the Setup that you want Mixed Mode. Mixed Mode allows you to login in to SQL Server using both Windows and Server Authentication. You try uninstalling the ABHIJIT-PC instance and install and new while making sure that you select MIXED MODE during your installation steps