SQL Server Performance Forum – Threads Archive

OSQL connection

When using osql utility failed to connect a remote SQL instance, The following msgs are returned and captured by a temp table, this temp table contains 7 records. [SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
Server [53].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections.
Where is the source of this msg, local windows host, local sql engine? why the the returned string is cut into small pieces? ——————
Bug explorer/finder/seeker/locator
——————

---

Check whether the client alias has been defined properly or not. http://www.cryer.co.uk/brian/sqlserver/hresult_0x2 npp_error_establishing_connection.htm fyi too. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

]]>