Can't find server

S

Spunky

It appears MS Project tries to open then gives this message (and a couple
others) then has MS Project screen with no menu. Is the place to correct
this problem on the SQL server, or in Project?

Error message:
Connection failed: SQLState: 08004 SQL Server Error: 4062 Server rejected
the connection; Access to selected database has been denied.
 
B

Brian K - Project MVP

Spunky said:
It appears MS Project tries to open then gives this message (and a
couple others) then has MS Project screen with no menu. Is the place
to correct this problem on the SQL server, or in Project?

Error message:
Connection failed: SQLState: 08004 SQL Server Error: 4062 Server
rejected the connection; Access to selected database has been denied.
Click to expand...

I have seen this before. In the case where I saw it the customer moved
the transaction logs to a new drive by detaching and reattaching them.
Doing this caused the default database for the MSProjectUser and
MSPRojectServerUser accounts in SQL to change (in his case to the WSS
database). Once he changed the database 'affiliations' for these
accounts to the right database everything worked fine.

It might also be caused by role problems with these same accounts. They
not only need to have the projectserver database as their defualt they
need to have the role assigned to them that matches their name
(MSProjectUser gets the MSProjectUser role, etc).

Check into this and see if this rings a bell.

--
___
Brian K

Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com
 
S

Spunky

I have been logging on a test machine (#2) for months using PWA and MS
Project 2003. Last week I published a project from my pc (#1). Something
happened after that but I didn't notice it immediately, perhaps my machine
had been rebooted. Now when I log on #1 MS Project acts as if opening but
doesn't allow me to access server, ends up with MS Project screen without a
menu and I'm then stuck. I can still log on from the test machine.
 
S

Spunky

Where do you change the database affiliation?
Also, a new error message working from pc #2. I opened a project on our old
server which I'm still doing my live projects from (or was, for now it is
confused). I tried to save as and got this message:
"This project is from a different project server which has different outline
code lookup tables. All outline code values must be cleared before
preforming the save. Do you want to continue? (Once clearned, these code
values are permanently removed)."
How can I make pc#1 look at the server it was looking at before I tried to
publish one of the projects that was just stored on a network server (not
involved with PWA)? It seems that is what has re-directed it to find the
other server which is professional and accesses PWA and I was only using for
testing.
 
Top