SQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0x7e, status code 0x60

This is a very common error faced by so many people and I get lots of questions regarding this error. This error occurs due to many reasons and I have already posted few solutions on this error, see if you can find your solution here

SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server
SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server or

Recently when I was trying to create new user and connect to SQL SERVER 2008, I faced this same error and could solve it after some search which I was unaware about and thought to share it so that it would help out many people.

This is the error that occurred when I was trying to connect to SQL Server 2008. I tried to start the services of SQL Server from SQL Server Services in SQL Server Configuration Manager, but again an error occurred that the request failed.

This is the error which was found in event log viewer. And from this information provided I disabled the VIA Protocol and tried again.

To disable the VIA follow the steps:

1. Go to SQL Server Configuration Manager.
2. Click on SQL Server Network Configuration node.
3. Click on Protocols for MSSQLSERVER
4. Disable the VIA Protocol.
5. And start the SQL SERVER (MSSQLSERVER) services again.
6. As the services are started connect to SQL SERVER.

Conclusion:
VIA is an abbreviation for Virtual Interface Adapter protocol. If you enable the VIA protocol on a computer that does not support the VIA protocol, the SQL Server service will not start.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

6 thoughts on “SQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0x7e, status code 0x60

  1. Thanks a ton Dear! I just faced this problem in a different way by wrong setting to copy protection of my site. However after reading your article, I remove settings and then it worked fine!

    Like

  2. Thanks For this help But this same error is occurred with my Sql server and I tried this but there is no affection in starting the server

    I could’t start my SQL server service So if any other aspect for this error then please Reply.

    Thanks.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s