Article ID: 818047 - View products that this article applies to.
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()).
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.
This problem may occur if the SQL Server is using a protocol other than TCP/IP.
To resolve this problem, follow these steps.
Part 1: On the Computer That Contains the SQL Server
Part 2: Configure the Client Computer to Use TCP/IPNote 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:
Article ID: 818047 - Last Review: September 18, 2011 - Revision: 5.0