Installation Issue - Unable to connection to SQL

[SMS@UT]

Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003 SP1 applied
- Medium Site installation scenario (web frontend and PS appl on one box -
SQL 2K on another box) Cannot login to Project Server via PWA - Every login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on both servers
- I followed MS Install Guide religiously - I can run the EditSite tool and
it passes on all tests - The IIS logs do not have any indicator as to what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and the
Sharepoint Instance - Any attempt to use Windows authentication generates a
5002 error and any attempt to use the PS Administrator accounts generates the
5002 error with the corresponding event logs as listed above. The SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL instance to
its corresponding IP 000.000.000.000\USITS and I still get the same results.

Help is gratefully appreciated!

 

[William Raymond [MVP]]

Hello,

Thank you for the helpful e-mail. The first thing that came to mind was to
check and make sure both computers have the same version of MDAC on them.

You can find out if both versions match by using the MDAC checker:
http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en

At a minimum, make sure MDAC 2.8 is installed. Download from here:
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en


That said, there is a good chance this is not actually the problem, but
definately one of the first things to check. Do you know if Project Server
just won't access the database (i.e. can you run Project Server and login,
or do you get a database access warning)? If you can access project server,
is there anything else that is not working properly that might help us
pinpoint why this user is connecting and not working?

Thanks and sorry if this wasn't quite as helpful as you might have hoped(!)

-Bill


--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003 SP1
applied
- Medium Site installation scenario (web frontend and PS appl on one box -
SQL 2K on another box) Cannot login to Project Server via PWA - Every
login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on both
servers
- I followed MS Install Guide religiously - I can run the EditSite tool
and
it passes on all tests - The IIS logs do not have any indicator as to what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and the
Sharepoint Instance - Any attempt to use Windows authentication generates
a
5002 error and any attempt to use the PS Administrator accounts generates
the
5002 error with the corresponding event logs as listed above. The SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL instance
to
its corresponding IP 000.000.000.000\USITS and I still get the same
results.

Help is gratefully appreciated!

 

[SMS@UT]

William,

I checked the MDAC versions and here are the results:

Box running Project Server & WSS has this version (Note the OS on the box is
W2K3 SP1) -2.82.1830.0. The box running SQL 2K SP3a has this version
2.80.1022.0 (the OS is W2K3 NO SP).

I ran Ethereal just to see exactly what was passing between the two machines
and they are definitely communicating - The SQL box passes back an ACCESS
DENIED on failed logins both from PWA and Project Pro access attempts.

This is a fresh install and intended for production - I cant even get into
PS to finish up the configuration (ARGH).

Ive noted one other similar thread from another user reporting like results
after applying SP2 so something has gone south in what I suspect is the
service pack.

Ive tried recreating the MSProject logins and roles as recommended by MS
which has not resolved the issue.

Im at my wits end! Hope you can provide me with some light at the end of
the tunnel. BTW I tried locating a MDAC 2.8 SP1 but cannot find the
distribution flavor for W2K3 and suspect its bundled in the SP.

Thanks

Angie

Hello,

Thank you for the helpful e-mail. The first thing that came to mind was to
check and make sure both computers have the same version of MDAC on them.

You can find out if both versions match by using the MDAC checker:
http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en

At a minimum, make sure MDAC 2.8 is installed. Download from here:
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en


That said, there is a good chance this is not actually the problem, but
definately one of the first things to check. Do you know if Project Server
just won't access the database (i.e. can you run Project Server and login,
or do you get a database access warning)? If you can access project server,
is there anything else that is not working properly that might help us
pinpoint why this user is connecting and not working?

Thanks and sorry if this wasn't quite as helpful as you might have hoped(!)

-Bill


--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003 SP1
applied
- Medium Site installation scenario (web frontend and PS appl on one box -
SQL 2K on another box) Cannot login to Project Server via PWA - Every
login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on both
servers
- I followed MS Install Guide religiously - I can run the EditSite tool
and
it passes on all tests - The IIS logs do not have any indicator as to what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and the
Sharepoint Instance - Any attempt to use Windows authentication generates
a
5002 error and any attempt to use the PS Administrator accounts generates
the
5002 error with the corresponding event logs as listed above. The SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL instance
to
its corresponding IP 000.000.000.000\USITS and I still get the same
results.

Help is gratefully appreciated!

 

[William Raymond [MVP]]

Hi Angie,

Okay,. this is what I was wondering about... it sounds like this is not just
an Event Viewer problem, but also an issue with even logging into Project
Server.

First, let's get both servers configured to run MDAC 2.8 SP1. I tracked
down the package for you on the MS website:
http://www.microsoft.com/downloads/...95-efc2-4f8e-a9e0-3a1afbd5922e&DisplayLang=en

Sorry about making you respond again, but it would be really helpful if you
could explain to me where you are getting that error message. For example,
if you go to PWA, to you get the login screen and there is red text on the
web page with the error, or is it somewhere else.

I will assume it is the red text on the web page for now.

If installing MDAC's does not work, try this:

1) Run SQL Enterprise Manager and expand the security->logins tree. Make
sure the MSProjectServerUser and MSProjectUser accounts are both set to have
their Project Server database configured as their 'default' database
anything else (like MASTER, or PUBS) may prevent the login from occurring
properly.
1b) While still managing the MSProjectServerUser and MSProjectUser accounts,
go to the 'Database Access' tab and select the Project Server database.
Then, make sure MSProjectServerUser is associated with the
MSProjectServerRole and the MSProjectUser is associated with the
MSProjectRole.

2) While editing the users, you could try changing their passwords, being
very careful to take note of them, then use the EditSite tool to inform
Project Server of the password change. This is a measure you can try just
to make sure there is a password problem.

3) Just to be sure, you are using SQL Server accounts for the
MSProjectServerUser and MSProjectUser accounts, correct? If you changed
anything to make them AD accounts, the application will not work.

4) This is a complete toss in the dark, but just in case there is a problem
with your DNS, go to the Project Server and edit the
C:\Windows\System32\Drivers\etc\hosts file with notepad. Add the IP address
of the SQL Server, then the friendly name, just as the other listings
appear. Also, add the IP address of your Project Server and the friendly
name of that server (i.e. 129.34.2.1 projectserverbox). Do not use
tabs, just spaces, and leave a blank line at the end of the file. Once
saved, the changes are immediate, so if anything changes, that is a good
thing.

If none of this is helping, either describe in detail the steps you take to
try and login and what happens. You could also paste a screen capture
(using the PrtScrn key on your computer) and pasting it into your response
so we can see the error (do not worry about screen caps fo the Event Viewer,
but where you are seeing the problem in PWA).

-Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

William,

I checked the MDAC versions and here are the results:

Box running Project Server & WSS has this version (Note the OS on the box
is
W2K3 SP1) -2.82.1830.0. The box running SQL 2K SP3a has this version
2.80.1022.0 (the OS is W2K3 NO SP).

I ran Ethereal just to see exactly what was passing between the two
machines
and they are definitely communicating - The SQL box passes back an ACCESS
DENIED on failed logins both from PWA and Project Pro access attempts.

This is a fresh install and intended for production - I cant even get into
PS to finish up the configuration (ARGH).

Ive noted one other similar thread from another user reporting like
results
after applying SP2 so something has gone south in what I suspect is the
service pack.

Ive tried recreating the MSProject logins and roles as recommended by MS
which has not resolved the issue.

Im at my wits end! Hope you can provide me with some light at the end of
the tunnel. BTW I tried locating a MDAC 2.8 SP1 but cannot find the
distribution flavor for W2K3 and suspect its bundled in the SP.

Thanks

Angie

Hello,

Thank you for the helpful e-mail. The first thing that came to mind was
to
check and make sure both computers have the same version of MDAC on them.

You can find out if both versions match by using the MDAC checker:
http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en

At a minimum, make sure MDAC 2.8 is installed. Download from here:
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en


That said, there is a good chance this is not actually the problem, but
definately one of the first things to check. Do you know if Project
Server
just won't access the database (i.e. can you run Project Server and
login,
or do you get a database access warning)? If you can access project
server,
is there anything else that is not working properly that might help us
pinpoint why this user is connecting and not working?

Thanks and sorry if this wasn't quite as helpful as you might have
hoped(!)

-Bill


--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003 SP1
applied
- Medium Site installation scenario (web frontend and PS appl on one
box -
SQL 2K on another box) Cannot login to Project Server via PWA - Every
login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access
denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on both
servers
- I followed MS Install Guide religiously - I can run the EditSite tool
and
it passes on all tests - The IIS logs do not have any indicator as to
what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and
the
Sharepoint Instance - Any attempt to use Windows authentication
generates
a
5002 error and any attempt to use the PS Administrator accounts
generates
the
5002 error with the corresponding event logs as listed above. The SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL
instance
to
its corresponding IP 000.000.000.000\USITS and I still get the same
results.

Help is gratefully appreciated!

 

[William Raymond [MVP]]

One other thing, download and install SP2a, do not use SP2 as this was
re-called due to problems. -Bill

 

[SMS@UT]

William,

Thank you for both the quick and detailed response - I located the MDAC 2.8
SP1 and tried installing in on the SQL Box (W2K3 NO SP) but it complained
that it was not installable on the OS - I suspect the reason I have the other
version on the PS frontend is because its W2K3 SP1 - Lets not get into why
the SQL backend OS does not have SP1 applied - If it needs to be I will do so.

The 5001 error occurs on both PWA and Project Pro login attempts and shows
as red text in both cases - on the web page and on the login popup window of
Proj Pro. The PWA login process is twofold - First I get the Windows popup to
authenticate (because I havent had a chance to add any user accounts I have
no creds for the passthrough authentication) - This fails with 5002 error
(expected) - Then I enter the Administrator credentials at the PWA Web page
login page - Thats when I get after a slight delay the 5001 error. The
results are similar via the Project Pro client.

I have verified the MSProjectServerUser and ProjectUSer accounts and server
roles - They are SQL accounts only - The funny thing is when I run the
EditSite Tool everything passes with flying colors.

The only thing I havent tried is the etc\host as you suggest - But I have a
very strong feeling thats not it as I have looked at the packet traffic via
Ethereal and I can see the PS session with chatter to and from the PS and SQL
boxes with a most definite access denied response from the SQL box.

I am presently working with SP1 versions of everything - I agree SP2a is the
way to go but should I even try that now with nothing working yet - The
reason I am working with SP1 is because I have a working set of the same
pieces in my development environment and SP2a is an unknown as of yet for me.

Your help is greatly appreciated and I sincerely hope it helps others as well.

Cheers

Angie

Hi Angie,

Okay,. this is what I was wondering about... it sounds like this is not just
an Event Viewer problem, but also an issue with even logging into Project
Server.

First, let's get both servers configured to run MDAC 2.8 SP1. I tracked
down the package for you on the MS website:
http://www.microsoft.com/downloads/...95-efc2-4f8e-a9e0-3a1afbd5922e&DisplayLang=en

Sorry about making you respond again, but it would be really helpful if you
could explain to me where you are getting that error message. For example,
if you go to PWA, to you get the login screen and there is red text on the
web page with the error, or is it somewhere else.

I will assume it is the red text on the web page for now.

If installing MDAC's does not work, try this:

1) Run SQL Enterprise Manager and expand the security->logins tree. Make
sure the MSProjectServerUser and MSProjectUser accounts are both set to have
their Project Server database configured as their 'default' database
anything else (like MASTER, or PUBS) may prevent the login from occurring
properly.
1b) While still managing the MSProjectServerUser and MSProjectUser accounts,
go to the 'Database Access' tab and select the Project Server database.
Then, make sure MSProjectServerUser is associated with the
MSProjectServerRole and the MSProjectUser is associated with the
MSProjectRole.

2) While editing the users, you could try changing their passwords, being
very careful to take note of them, then use the EditSite tool to inform
Project Server of the password change. This is a measure you can try just
to make sure there is a password problem.

3) Just to be sure, you are using SQL Server accounts for the
MSProjectServerUser and MSProjectUser accounts, correct? If you changed
anything to make them AD accounts, the application will not work.

4) This is a complete toss in the dark, but just in case there is a problem
with your DNS, go to the Project Server and edit the
C:\Windows\System32\Drivers\etc\hosts file with notepad. Add the IP address
of the SQL Server, then the friendly name, just as the other listings
appear. Also, add the IP address of your Project Server and the friendly
name of that server (i.e. 129.34.2.1 projectserverbox). Do not use
tabs, just spaces, and leave a blank line at the end of the file. Once
saved, the changes are immediate, so if anything changes, that is a good
thing.

If none of this is helping, either describe in detail the steps you take to
try and login and what happens. You could also paste a screen capture
(using the PrtScrn key on your computer) and pasting it into your response
so we can see the error (do not worry about screen caps fo the Event Viewer,
but where you are seeing the problem in PWA).

-Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

William,

I checked the MDAC versions and here are the results:

Box running Project Server & WSS has this version (Note the OS on the box
is
W2K3 SP1) -2.82.1830.0. The box running SQL 2K SP3a has this version
2.80.1022.0 (the OS is W2K3 NO SP).

I ran Ethereal just to see exactly what was passing between the two
machines
and they are definitely communicating - The SQL box passes back an ACCESS
DENIED on failed logins both from PWA and Project Pro access attempts.

This is a fresh install and intended for production - I cant even get into
PS to finish up the configuration (ARGH).

Ive noted one other similar thread from another user reporting like
results
after applying SP2 so something has gone south in what I suspect is the
service pack.

Ive tried recreating the MSProject logins and roles as recommended by MS
which has not resolved the issue.

Im at my wits end! Hope you can provide me with some light at the end of
the tunnel. BTW I tried locating a MDAC 2.8 SP1 but cannot find the
distribution flavor for W2K3 and suspect its bundled in the SP.

Thanks

Angie

Hello,

Thank you for the helpful e-mail. The first thing that came to mind was
to
check and make sure both computers have the same version of MDAC on them.

You can find out if both versions match by using the MDAC checker:
http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en

At a minimum, make sure MDAC 2.8 is installed. Download from here:
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en


That said, there is a good chance this is not actually the problem, but
definately one of the first things to check. Do you know if Project
Server
just won't access the database (i.e. can you run Project Server and
login,
or do you get a database access warning)? If you can access project
server,
is there anything else that is not working properly that might help us
pinpoint why this user is connecting and not working?

Thanks and sorry if this wasn't quite as helpful as you might have
hoped(!)

-Bill


--
William Raymond
BLOG: http://www.mympa.org/blog.aspx


Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003 SP1
applied
- Medium Site installation scenario (web frontend and PS appl on one
box -
SQL 2K on another box) Cannot login to Project Server via PWA - Every
login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access
denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on both
servers
- I followed MS Install Guide religiously - I can run the EditSite tool
and
it passes on all tests - The IIS logs do not have any indicator as to
what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and
the
Sharepoint Instance - Any attempt to use Windows authentication
generates
a
5002 error and any attempt to use the PS Administrator accounts
generates
the
5002 error with the corresponding event logs as listed above. The SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL
instance
to
its corresponding IP 000.000.000.000\USITS and I still get the same
results.

Help is gratefully appreciated!

 

[SMS@UT]

Bill,

Can you take a look at my previous post of 1/6/6 - I provided details on the
login conditions encountered - I also tried the /etc/host file and still the
same results - Applying SP1 to the SQL Backend is our current plan of action
(MDAC 2.8 SP1 is packaged with SP1 and MS will not be distributing a stand
alone package for the W2K3 OS release) - I delayed because the SQL backend is
also our SMS Primary Site Server and frankly I only like having one broken
app headache at a time...We are an Educational site so real world rules dont
always apply but my excuse this week is "Hey at least we are the National
Champs in Football!!!!!!" And I hope your not a USC fan!

Cheers
Angie

One other thing, download and install SP2a, do not use SP2 as this was
re-called due to problems. -Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003 SP1
applied
- Medium Site installation scenario (web frontend and PS appl on one box -
SQL 2K on another box) Cannot login to Project Server via PWA - Every
login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on both
servers
- I followed MS Install Guide religiously - I can run the EditSite tool
and
it passes on all tests - The IIS logs do not have any indicator as to what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and the
Sharepoint Instance - Any attempt to use Windows authentication generates
a
5002 error and any attempt to use the PS Administrator accounts generates
the
5002 error with the corresponding event logs as listed above. The SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL instance
to
its corresponding IP 000.000.000.000\USITS and I still get the same
results.

Help is gratefully appreciated!

 

[William Raymond [MVP]]

Hi Angie,

Your post must not have shown up in Outlook yet before I made that post. I
think I know what the problem is.

First of all, you should not be getting a pop-up challenge response. Are
you using SSL and/or did you make PWA a trusted site in IE? (Internet
Explorer->Tools->Internet Options->Security->Trusted Sites... then 'reset'
to 'low'... then exit IE and re-start after configuration).

You are right that your personal Active Directory account cannot get you
into the site yet. This has to be done by logging in with the Administrator
account (as you suggested). However, I think you might actually be
encountering a situation where you are entering the wrong password (or maybe
slightly mis-typed password) from when performing the setup.

To see if my hunch is correct that the Administrator password is not
matching, run SQL Enterprise Manager and connect to the Project Server
database. Find the table called "MSP_WEB_RESOURCES". Find the field called
"WRES_PASSWORD" and clear out any data in there. This will make the
Administrator password blank (null).

Now, starting from a fresh IE window, login to PWA with a username of
"Administrator" and do not enter a password. See if this works.

If you are still having problems, copy/paste all the red text so I can see
the error number along with the text.

Congratulations but alas, I am not a USC fan. I won't hold that against you
though

-Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Bill,

Can you take a look at my previous post of 1/6/6 - I provided details on
the
login conditions encountered - I also tried the /etc/host file and still
the
same results - Applying SP1 to the SQL Backend is our current plan of
action
(MDAC 2.8 SP1 is packaged with SP1 and MS will not be distributing a stand
alone package for the W2K3 OS release) - I delayed because the SQL backend
is
also our SMS Primary Site Server and frankly I only like having one broken
app headache at a time...We are an Educational site so real world rules
dont
always apply but my excuse this week is "Hey at least we are the National
Champs in Football!!!!!!" And I hope your not a USC fan!

Cheers
Angie

One other thing, download and install SP2a, do not use SP2 as this was
re-called due to problems. -Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003 SP1
applied
- Medium Site installation scenario (web frontend and PS appl on one
box -
SQL 2K on another box) Cannot login to Project Server via PWA - Every
login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access
denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on both
servers
- I followed MS Install Guide religiously - I can run the EditSite tool
and
it passes on all tests - The IIS logs do not have any indicator as to
what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and
the
Sharepoint Instance - Any attempt to use Windows authentication
generates
a
5002 error and any attempt to use the PS Administrator accounts
generates
the
5002 error with the corresponding event logs as listed above. The SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL
instance
to
its corresponding IP 000.000.000.000\USITS and I still get the same
results.

Help is gratefully appreciated!

 

[SMS@UT]

Bill,

Alas - Still no love - Heres the text:
Project was unable to log you on at this time because the Project Server
database cannot be accessed. Please try again later or check with your
Project Server administrator. (5001)

I am inclined to go with your first guess regarding the MDAC versions given
the Access Denied - Im ramping up for the SP1 install - Given that from all
my research MDAC plays a somewhat critical role in both server and client Im
disappointed in MS not having foresight to code at least a version check in
their installer - But Ill save that rant for a working PS install - And you
very correct the challenge is anticipated as I do not have the server URL in
the trusted sites and I am using SSL.

Any other advice is appreciated.

Thanks for all your help.

Angie

Hi Angie,

Your post must not have shown up in Outlook yet before I made that post. I
think I know what the problem is.

First of all, you should not be getting a pop-up challenge response. Are
you using SSL and/or did you make PWA a trusted site in IE? (Internet
Explorer->Tools->Internet Options->Security->Trusted Sites... then 'reset'
to 'low'... then exit IE and re-start after configuration).

You are right that your personal Active Directory account cannot get you
into the site yet. This has to be done by logging in with the Administrator
account (as you suggested). However, I think you might actually be
encountering a situation where you are entering the wrong password (or maybe
slightly mis-typed password) from when performing the setup.

To see if my hunch is correct that the Administrator password is not
matching, run SQL Enterprise Manager and connect to the Project Server
database. Find the table called "MSP_WEB_RESOURCES". Find the field called
"WRES_PASSWORD" and clear out any data in there. This will make the
Administrator password blank (null).

Now, starting from a fresh IE window, login to PWA with a username of
"Administrator" and do not enter a password. See if this works.

If you are still having problems, copy/paste all the red text so I can see
the error number along with the text.

Congratulations but alas, I am not a USC fan. I won't hold that against you
though

-Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Bill,

Can you take a look at my previous post of 1/6/6 - I provided details on
the
login conditions encountered - I also tried the /etc/host file and still
the
same results - Applying SP1 to the SQL Backend is our current plan of
action
(MDAC 2.8 SP1 is packaged with SP1 and MS will not be distributing a stand
alone package for the W2K3 OS release) - I delayed because the SQL backend
is
also our SMS Primary Site Server and frankly I only like having one broken
app headache at a time...We are an Educational site so real world rules
dont
always apply but my excuse this week is "Hey at least we are the National
Champs in Football!!!!!!" And I hope your not a USC fan!

Cheers
Angie

One other thing, download and install SP2a, do not use SP2 as this was
re-called due to problems. -Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx


Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003 SP1
applied
- Medium Site installation scenario (web frontend and PS appl on one
box -
SQL 2K on another box) Cannot login to Project Server via PWA - Every
login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access
denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on both
servers
- I followed MS Install Guide religiously - I can run the EditSite tool
and
it passes on all tests - The IIS logs do not have any indicator as to
what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and
the
Sharepoint Instance - Any attempt to use Windows authentication
generates
a
5002 error and any attempt to use the PS Administrator accounts
generates
the
5002 error with the corresponding event logs as listed above. The SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL
instance
to
its corresponding IP 000.000.000.000\USITS and I still get the same
results.

Help is gratefully appreciated!

 

[William Raymond [MVP]]

Hi Angie,

Without pysically looking at the machines, I have to say you are probably
stuck until we at least get the MDAC issue out of the way.

It would probably work if USC weren't your team

All kidding aside, I would highly recommend you open a ticket with Microsoft
to try and help you resolve this issue.

http://support.microsoft.com


-Bill
--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Bill,

Alas - Still no love - Heres the text:
Project was unable to log you on at this time because the Project Server
database cannot be accessed. Please try again later or check with your
Project Server administrator. (5001)

I am inclined to go with your first guess regarding the MDAC versions
given
the Access Denied - Im ramping up for the SP1 install - Given that from
all
my research MDAC plays a somewhat critical role in both server and client
Im
disappointed in MS not having foresight to code at least a version check
in
their installer - But Ill save that rant for a working PS install - And
you
very correct the challenge is anticipated as I do not have the server URL
in
the trusted sites and I am using SSL.

Any other advice is appreciated.

Thanks for all your help.

Angie

Hi Angie,

Your post must not have shown up in Outlook yet before I made that post.
I
think I know what the problem is.

First of all, you should not be getting a pop-up challenge response. Are
you using SSL and/or did you make PWA a trusted site in IE? (Internet
Explorer->Tools->Internet Options->Security->Trusted Sites... then
'reset'
to 'low'... then exit IE and re-start after configuration).

You are right that your personal Active Directory account cannot get you
into the site yet. This has to be done by logging in with the
Administrator
account (as you suggested). However, I think you might actually be
encountering a situation where you are entering the wrong password (or
maybe
slightly mis-typed password) from when performing the setup.

To see if my hunch is correct that the Administrator password is not
matching, run SQL Enterprise Manager and connect to the Project Server
database. Find the table called "MSP_WEB_RESOURCES". Find the field
called
"WRES_PASSWORD" and clear out any data in there. This will make the
Administrator password blank (null).

Now, starting from a fresh IE window, login to PWA with a username of
"Administrator" and do not enter a password. See if this works.

If you are still having problems, copy/paste all the red text so I can
see
the error number along with the text.

Congratulations but alas, I am not a USC fan. I won't hold that against
you
though

-Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx

Bill,

Can you take a look at my previous post of 1/6/6 - I provided details
on
the
login conditions encountered - I also tried the /etc/host file and
still
the
same results - Applying SP1 to the SQL Backend is our current plan of
action
(MDAC 2.8 SP1 is packaged with SP1 and MS will not be distributing a
stand
alone package for the W2K3 OS release) - I delayed because the SQL
backend
is
also our SMS Primary Site Server and frankly I only like having one
broken
app headache at a time...We are an Educational site so real world rules
dont
always apply but my excuse this week is "Hey at least we are the
National
Champs in Football!!!!!!" And I hope your not a USC fan!

Cheers
Angie

:

One other thing, download and install SP2a, do not use SP2 as this was
re-called due to problems. -Bill

--
William Raymond
BLOG: http://www.mympa.org/blog.aspx


Fresh installation on W2K3 Server - WSS SP1 - Project Server 2003
SP1
applied
- Medium Site installation scenario (web frontend and PS appl on one
box -
SQL 2K on another box) Cannot login to Project Server via PWA -
Every
login
attempt generates the following 3 application events:

1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01
"Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 418
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01
"Component:
PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 150
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

"
1/5/2006 10:55:27 AM Microsoft Project Server Tracing Eventlog
Provider Error None 2 NT AUTHORITY\LOCAL SERVICE ITS-APP01 "File:
C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code
was
also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access
denied.]]></Description>


"
I think the last event listed (first to occur) is the most telling -
indicating a authentication issue - Ive verified all accounts on
both
servers
- I followed MS Install Guide religiously - I can run the EditSite
tool
and
it passes on all tests - The IIS logs do not have any indicator as
to
what
login is being attempted to pass - The SQL logs indicate successful
connections by the accounts setup to service both Project Server and
the
Sharepoint Instance - Any attempt to use Windows authentication
generates
a
5002 error and any attempt to use the PS Administrator accounts
generates
the
5002 error with the corresponding event logs as listed above. The
SQL
Instance name is ITS-FILES\USITS - I also tried changing the SQL
instance
to
its corresponding IP 000.000.000.000\USITS and I still get the same
results.

Help is gratefully appreciated!