You are currently offline, waiting for your internet to reconnect

You receive the "Microsoft SQL Server login" error message when you connect to Microsoft Project Server

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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

  1. Click Start, and then click Run.
  2. In the Open box, type Cliconfg.exe, and then click OK.
  3. In the SQL Server Client Network Utility dialog box, do the following on the General tab:
    1. 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.
    2. Click to clear the Force protocol encryption check box.
  4. Click OK to close the SQL Server Client Network Utility dialog box.
  5. Restart the SQL Services.

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.
PRJ2002
Properties

Article ID: 818047 - Last Review: 09/18/2011 04:05:00 - Revision: 5.0

  • Microsoft Project 2002 Standard Edition
  • Microsoft Project Server 2002
  • Microsoft Office Project Professional 2003
  • Microsoft Office Project Server 2003
  • kberrmsg kbprb KB818047
Feedback