Defining a Project Professional connection

[Doug C]

Were do you specify in the Project Professional Connection the ODBC DSN to
use. Currently have two separate Project Server 2003 installations that I am
trying to connect to from one client. One of the PS Sites is for development
and one is a production site. When I have no trouble connecting to either
site through the web interface. However, I am not able to connect to the
sites with Project Professional 2003. I get the following error.

“Cannot connect.

Project is unable to establish a connection with the selected Project
Server. This could be caused by a loss of network connectivity or problems
with the Project Server or database.â€

In Project Professional Connection I can only set the URL for the site.
Where is the DSN set for the site?

Doug C

 

[Rod Gill]

There is no DSN. Project Server itself looks after sending data to be stored
in the correct SQL Server database. In Project Professional set up two
project server accounts, one for each instance of Project Server. Set the
manual select option in the Accounts dialog then you can choose which one is
used every time you start Project Professional.

If you do have two separate Project Server 2003 installations then there
must be two URL's

 

[Doug C]

I understand how the URLs are defined for a connection and I have two define.
Lets say that there are two systems that have SQL, Project Server 2003, and
IIS running on a single system. System1 is the URL
https://System1.com/ProjectServer and SQL Server is running on port 1433.
Sytem2 is the URL https://System2.com/ProjectServer and SQL Server is running
on port 5234. In project Professional I make the connections for System1
with the URL but I do not see where I specify the SQL Server information.
And I can create the second connection to Ssytem2 with the other URL. I was
wondering how is the connection for SQL Server defined in Project
Professional?

 

[Ed Morrison]

Project Professional does not maintain the SQL connection information.
Instead, it connects to Project Server using PDS via the given URL. The PDS
uses the connection information stored on the server.

I'm not sure why you created two distinct ports on your SQL installation.
You can host two instances of Project Server using one instance of SQL and
two databases.

Try downloading the Edit Site tool from Microsoft. It helps you to set up
Project Server instance on the same server(s).
--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com

 

[Doug C]

Thank you for answering my question.

I was just giving an example. I wanted to make the example emphasize the
difference in SQL Server. So I used different systems so I could use
different ports and made sure not to use a default SQL Server port.

 

[Gary L. Chefetz \(MVP\)]

Doug:

The DSN information is stored in the HKLM hive in the registry. Once you
work your way down the tree to your instance, you'll find it under
datasets/EnterpriseDatabase

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-