ODBC Connection does not accept 'local'

  • Whilst creating an ODBC connection using SQL Server Native Client it was noted that \\Servername\SQLInstance was accepted whilst (local) was not accepted.

    OS: Win2k3R2

    Any idea why?

  • No idea, but please post in the appropriate forum. (this has been moved).

  • Try localhost.

  • I get errors related to the Named Pipes Provider using both (local) -which is listed in the ODBC wizard - and (localhost).

    Error01.jpg using (local)

    Error02.jpg using (localhost)

    Within SQL Server Configuration Manager > SQL Native Client Configuration > Client Protocols, Named Pipes is Enabled with Priority 3.

    Unsuccessful.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply