Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 818047 - Last Review: September 18, 2011 - Revision: 5.0
You receive the "Microsoft SQL Server login" error message when you connect to Microsoft Project Server
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.
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
- 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.
- Click to clear the Force protocol
encryption check box.
- Click OK to close the SQL Server
Client Network Utility dialog box.
- 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:
- Log on to the Microsoft Project Professional 2002 client
computer or the Microsoft Office Project Professional 2003 client
computer.
- Click Start, and then click
Run.
- In the Open box, type
Cliconfg.exe, and then click
OK.
- On the General tab, click
TCP/IP, and then click OK.
APPLIES TO
- Microsoft Project 2002 Standard Edition
- Microsoft Project Server 2002
- Microsoft Office Project Professional 2003
- Microsoft Office Project Server 2003
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
Anonymous User
|
Reported as Irrelevant
|
| Written:
7/29/2005 12:07 AM |
|
|