Microsoft KB Archive/818047

= You receive the &quot;Microsoft SQL Server login&quot; error message when you connect to Microsoft Project Server =

Article ID: 818047

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Project 2002 Standard Edition
 * Microsoft Project Server 2002
 * Microsoft Office Project Professional 2003
 * Microsoft Office Project Server 2003

-



SYMPTOMS
When you try to connect to either Microsoft Project Server 2002 or to Microsoft Office Project Server 2003 from Microsoft Project 2002 or from Microsoft Office Project 2003, you may receive the following error message:

Microsoft SQL Server Login

Connection failed: SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile).

Connection failed:

SQLState: ‘08001’

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.



CAUSE
This problem may occur if the SQL Server is using a protocol other than TCP/IP.



RESOLUTION
To resolve this problem, follow these steps.

Part 1: On the Computer That Contains the SQL Server
 Click Start, and then click Run. In the Open box, type Cliconfg.exe, and then click OK. In the SQL Server Client Network Utility dialog box, do the following on the General tab:  Depending on the version of MDAC you have installed, do one of the following:  Click Default Network Library from the drop down list. Use the Up/Down arrows to move the enabled protocols in the order you that you want. However, TCP/IP is the Default Network Library and must be moved to the top of the list.</ul> </li> Click to clear the Force protocol encryption check box.</li></ol> </li> Click OK to close the SQL Server Client Network Utility dialog box.</li> Restart the SQL Services.</li></ol>

Part 2: Configure the Client Computer to Use TCP/IP
Note If the problem still occurs after you follow the steps that are listed in Part 1, run the Cliconfg utility on the client computer. To do this, follow these steps:
 * 1) Log on to the Microsoft Project Professional 2002 client computer or the Microsoft Office Project Professional 2003 client computer.
 * 2) Click Start, and then click Run.
 * 3) In the Open box, type Cliconfg.exe, and then click OK.
 * 4) On the General tab, click TCP/IP, and then click OK.

Additional query words: PRJ2002

Keywords: kberrmsg kbprb KB818047

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.