RE: Problem connecting to SQL server

From: Fany Vargas (fanyv_at_microsoft.com)
Date: 11/19/04

  • Next message: Rand Boyd [MSFT]: "RE: Connection Error 18452 - Login failed for user '(null)'" 
    Date: Fri, 19 Nov 2004 08:40:03 GMT

    what key did it create under
    \Software\Microsoft\MSSQLServer\Client\ConnectTo ?
    If when you created a DSN you selected the "client configuration" button,
    then an alias will be created. That is what you see written under the
    "connectto" key.

    So when creating this DSN it seems you specified specifically what network
    library to use, for example if your SQL Server is ONLY listening on named
    pipes and not TCP , then you can create a named pipes alias on the client
    to force a named pipes connection.

    To see what aliases are present on your machine you can go to :
    start->run->cliconfg.exe (select the alias tab). I would recommend you test
    a TCP and named pipes alias.

    Reference (available at http://support.microsoft.com)
    How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422

  • Next message: Rand Boyd [MSFT]: "RE: Connection Error 18452 - Login failed for user '(null)'"
    Loading