Connecting Project Server 2003 to a second SQL instance database

[Shane]

Hi -

If i have 2 SQL instances being managed on one server (SQL 2000 and SQL
2005) how do I connect a 2003 PWA using edit site to the second instance

I enter server IP/instance into edit site but PWA wont work.

The server roles and users have been setup and the DSN is correct

Any assistance is welcome.

Thks
Shane

 

[Ben Howard]

Hi Shane, does it give any errors. For separate instances you must have the
SQL browser server running on the SQL server for the PS to resolve the
instance name.

 

[Shane]

Hi Ben,

There were no errors but this had us stumped.

We have since moved to a dedicated SQL 2005 instance but still have
problems. To me everything looks OK in Edit Site but the test fails on the
database check.

The DB server is accessible from both the Web Server and Session Manager
server. (Tested with Telnet over port 1433).

The roles and users have also been created to allow this to work.

If I test the DSN both logins fails.

I just don't get it.
The

Can you suggest anything before my marbles are well and truly gone?

Thanks in advance
Shane