“Specified SQL server not found” or “Error Locating Server/Instance Specified” On windows vista when connecting to sql server in remote server

“Specified SQL server not found” or “Error Locating Server/Instance Specified” On windows vista when connecting to sql server in remote server

If you are trying to connect a client computer running windows vista or windows server 2008 to a named instance of sql server. In this scenario the connection may fail. If you are using windows data access component 6.0 to connect to named instance of sql server, you will receive the following error message.

[DBNETLIB]Specified SQL server not found.
[DBNETLIB]ConnectionOpen (Connect()).

And if you are using sql native instance to connect with named instance of sql server you will receive the following error message.

[SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
[SQL Native Client]Login timeout expired.
Read more of this post