Microsoft Knowledge Base Email Alertz

KBAlertz.com: (837653) - Describes an issue where you cannot log on and connect to Microsoft Project Server when you are connected to the server over a slow link or when you are located on a remote location that is outside the LAN.

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]





ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **


Bug Tracking Software
For bug tracking software or defect tracking software or issue tracking software, visit Axosoft.


Community Site



We Send hundreds of thousands of emails using ASP.NET Email



Expert Web Design & Graphic Design
Design44.com

ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **




Mentioned In








Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks




Article ID: 837653 - Last Review: March 27, 2007 - Revision: 1.9

You receive the "Microsoft Project was unable to establish a connection with the selected Microsoft Project Server" error message when you log on to Microsoft Project Server

On This Page

SYMPTOMS

When you log on and connect to Microsoft Office Project Server 2003 by using Microsoft Office Project Professional 2003 or when you log on and connect to Microsoft Project Server 2002 by using Microsoft Project Professional 2002, you may intermittently experience both of the following symptoms:
  • You receive an error message that is similar to the following:
    Connection failed:
    SQLState: '01000'
    SQL Server Error: 53
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
    Connection failed:
    SQLState '08001'
    SQL Server Error: 17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
  • After you receive the first error message, you are prompted to type your user name and password to log on to Microsoft SQL Server. When you do this, you receive the following error message:
    Microsoft Project

    Cannot Connect

    Microsoft Project was unable to establish a connection with the selected Microsoft Project Server. This could be caused by a loss of network connectivity, invalid username or password, lack of an enterprise global template, problems with the Microsoft Project Server or database, or your Microsoft Project Server may not have enterprise features enabled.

CAUSE

This issue may occur if either of the following conditions is true:
  • You connect to Project Server 2003 or to Microsoft Project Server 2002 over a slow link or from a remote location that is outside the local area network (LAN), and an issue exists that prevents the host name of the computer that is running SQL Server from resolving correctly.
  • A Group Policy setting was applied to your computer that changed the regional settings of your computer.

RESOLUTION

To resolve this issue, use one of the following methods, depending on the version of Microsoft Project Server that you are running.

Microsoft Project Server 2002

If you are running Microsoft Project Server 2002, edit the registry of the Web server to use the IP address of the computer that is running SQL Server. On the computer that is running Microsoft Internet Information Services (IIS), edit the connectInfo registry entry in the following registry key to use the IP address of the computer that is running SQL Server:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0\MS Project\WebClient Server\ProjectServer\Datasets\Application
To do this, follow these steps:

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756  (http://kbalertz.com/Feedback.aspx?kbNumber=322756/ ) How to back up and restore the registry in Windows
  1. Click Start, and then click Run.
  2. In the Open box, type regedit, and then click OK.
  3. Locate the following key registry key:
    HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0\MS Project\WebClient Server\ProjectServer\Datasets\Application
  4. In the right pane, double-click connectInfo.
  5. In the Value data box, change the ServerName entry in the Data Source=ServerName part of the string to the IP address of the computer that is running SQL Server.

    For example, the string in the Value data box may look similar to the following, where IPAddress is the IP address of the computer that is running SQL Server:
    Provider=SQLOLEDB;User ID=MsProjectServerUser; Password=Password;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=IPAddress
  6. Click OK, and then quit Registry Editor.

Project Server 2003

If you are running Project Server 2003, use the ConnInfo.exe tool to edit the registry of the server to use the IP address of the computer that is running SQL Server. To do this, follow these steps:
  1. Locate the folder that contains the ConnInfo.exe tool, and then double-click ConnInfo.exe.

    The ConnInfo.exe tool is located in the Drive:\Program Files\Microsoft Office Project Server 2003\Bin\1033 folder of the computer that is running Project Server 2003. To download the ConnInfo.exe tool, visit the following Microsoft Web site:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=1d30b672-baa0-4030-b036-323b216d7264&displaylang=en (http://www.microsoft.com/downloads/details.aspx?FamilyID=1d30b672-baa0-4030-b036-323b216d7264&displaylang=en)
  2. In the Project Server 2003 Connection Information dialog box, click either Single database configuration or Partitioned database configuration.
  3. In the SQL Server box, type the IP address of the computer that is running SQL Server, click Save, click OK, and then click Exit.

MORE INFORMATION

For additional information about how to troubleshoot a similar error message that may occur when you log on to Microsoft Project Server 2002, click the following article number to view the article in the Microsoft Knowledge Base:
818047  (http://kbalertz.com/Feedback.aspx?kbNumber=818047/ ) You receive the "Microsoft SQL Server login" error message when you connect to Microsoft Project Server
For more information about Microsoft Project Server 2002, visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?pr=prj2002&SD=OFFN (http://support.microsoft.com/default.aspx?pr=prj2002&sd=offn)

APPLIES TO
  • Microsoft Office Project Server 2003
  • Microsoft Office Project Professional 2003
  • Microsoft Project Server 2002
  • Microsoft Project 2002 Professional Edition
Keywords: 
kberrmsg kbprb KB837653
       

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

Ryan - ryan NOSPAM-AT-NOSPAM peterson.net Report As Irrelevant  
Written: 6/28/2004 1:34 PM
Tried this, still experiencing issue. I am, however, able to connect is I start by working offline and create the connection while inside of Project. I am working over and IPSEC tunnel and think it may be slowing me down considerably.

Anonymous User Report As Irrelevant  
Written: 8/5/2005 4:07 AM
I encountered similar error as described in symptoms, with some additional information: 1. The server is incorrect, but the database instance is correct. 2. After correcting the server name and provide valid user login info, I'm able to connect. 3. I tried to use conninfo.exe to update the connection info, but same error occurs. Any further update?

(Optional) Name

(Optional) Public URL Or Email

Comments
No HTML -- Text Only Please