Vexing Login Issues

S

SMS@UT

Heres the situation:

Server:

Windows 2K3
MDAC 2.8 RTM
Project Server 2003 SP1
WSS SP1
SQL 2K SP3a

Client:

Windows Xp SP2
IE 6
MDAC 2.8 SP1
Project Professional SP1


The issue:

1. Server: Can access PWA via IE6 on the server using Admin credentials
(both Domain & PS) - CANNOT access PWA using Windows credentials outside of
Admins.
2. Windows XP SP2 - Project Professional - CANNOT access using either
Windows credentials or PS creds- 5001 Error Database cannot be accessed.
3. Windows XP SP2 - PWA - Can login (after failing pass-thru LGNINT.ASP)
using PS creds and Admin Windows Creds but not any other credentials (i.e.
non-Admin)

Ran EditSite and passed with flying colors including Database.

Application logs show successful login by ProJectServerUser account

IIS Logs a little more revealing extract of typical external failed access
(via PWA) follows:

2005-09-14 21:55:14 128.83.32.194 GET /ProjectServer - 80 AUSTIN\stahlap
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
301 0 0
2005-09-14 21:55:14 128.83.32.194 GET /ProjectServer/LGNINT.ASP
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 80 AUSTIN\stahlap
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

My personal favorite 500 internal server error! And try searching for
anything truly revealing on the 'this.oResMgr'....grumble

2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/LGNINT.ASP - 447
AUSTIN\us-projadm 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 2 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/ - 447 -
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 1 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/LGNINT.ASP - 447
AUSTIN\stahlap 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
302 0 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/lgnps.asp err=5001 447
AUSTIN\us-projadm 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
200 0 0

Now before Gary Chefetz chimes in (If I promise to buy your books Gary will
you give me the answer - It would be well worth it!)

Ive checked the permissions (both NTFS and IIS) - Everything checks out - I
even compared this against a working development site - The only difference
between the two is the production site is all on one box whereas the
development site has a separate SQL box).

Ive even called MS PS - And after 1.5hrs and telling the tech on the other
end how I fixed one issue (this was the mixed IIS Directory security
settings) Ive kinda despaired and doubt I have the patience or the fortitude
to fight up the chain

And before someone suggest re-install - This is try number 3 on the same box
- Same box same set of conditions everytime - Cant reinstall from bare metal
as server also provides other production services which cannot be interuppted.

Ive burned hours searching GOOGLE YAHOO and this discussion thread Ive tried
a number of suggestions and exhausted the KB articles (which I am presently
assembling into a troublehooting guide for other poor admins out there).

Ive also double checked the metabase and authentication modes - And checked
and compared the Security config settings.

The only big difference between the two is that the development box happily
listens on the default port for SQL 1433 - Whereas the Production box does
not - But that cannot be the answer because I can get limited access external
to the box.

And finally the Sharepoint side works as expected for now - Since I cant
connect via Project Professional (yes its running SP1 as well) I cant attempt
to publish and check for the corresponding Sharepoint Site.

So if anyone out there can provide the answer I will offer a reward (in
Gary's case Ill buy his books!).

Dying out here in Austin, Texas and quickly running out of beer money cus
this issue is driving me to drink!!!

Cheers
 
G

Gary L. Chefetz [MVP]

It's really difficult to say what's going on here without knowing:

1) What are the other production apps running on the server?
2) Where is the MDAC directory in relationship to Project Server?
3) Do you see errors in the application log when you attempt to logon?
4) Did you add the Project Server URL to the WSS managed paths exclusions?

I wouldn't rule out the port as part of the problem just yet. Did you try
switching the port to 1433 to see if it made a difference?
 
S

SMS@UT

Gary,

Thanks for the speedy response - Ive observed that your a very active poster
in many of the Project Server discussion groups so Im glad to hear from you -
See my in-line responses below to your queries:


Gary L. Chefetz said:
It's really difficult to say what's going on here without knowing:

1) What are the other production apps running on the server?
Click to expand...
The server is running SMS and Sharepoint Services
2) Where is the MDAC directory in relationship to Project Server?
Click to expand...
The MDAC Directory is located in C:\Program Files\Common Files\System\msadc
3) Do you see errors in the application log when you attempt to logon?
Click to expand...
IIS Log entry following unsuccessful attempt via Project Professional - No
entries in the event logs:
#Date: 2005-09-15 13:53:57
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port
cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2005-09-15 13:53:57 128.83.32.194 POST /ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:30 128.83.32.194 POST /ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:31 128.83.32.194 GET /ProjectServer/lgnpspj.asp
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 447 - 128.83.45.28
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

Application Event Log Entries following unsuccessful PWA login on Server:

Type Date Time Source Category Event User Computer
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Information 9/15/2005 9:06:05 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:29 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:28 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Infor

Detail on the MS Project Server Tracing:

File: C:\Office\dev\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x800401e4
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Description: <Description><![CDATA[VERIFYINPTR(NULL)]]></Description>

Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]> said:
4) Did you add the Project Server URL to the WSS managed paths exclusions?
Click to expand...

Yes I did
I wouldn't rule out the port as part of the problem just yet. Did you try
switching the port to 1433 to see if it made a difference?
Click to expand...

I tried switching the SQL listening port to the default 1433 and I get the
same results. So thats not the explanation.

Let me know if you require anything additional and your assistance in
resolving this issue is greatly appreciated!!!!

Angie
 
G

Gary L. Chefetz [MVP]

Angie:

Digging deeper:

Where is MDAC in relation in the IIS tree structure and where is Project
Server virtual directory in the IIS tree structure?
Have you enabled all unsigned ISAPI filters for this application server?
How is directory security set for pjdbcomm.dll?
How about msadcs.dll?

It appears that your server name has a dash in it? Is this correct? I've
seen problems related to dashes in server names. I'm not certain whether
there are any potential conflicts with SMS, but nothing turns up in the KB.




SMS@UT said:
Gary,

Thanks for the speedy response - Ive observed that your a very active
poster
in many of the Project Server discussion groups so Im glad to hear from
you -
See my in-line responses below to your queries:


Gary L. Chefetz said:
It's really difficult to say what's going on here without knowing:

1) What are the other production apps running on the server?
Click to expand...
The server is running SMS and Sharepoint Services
2) Where is the MDAC directory in relationship to Project Server?
Click to expand...
The MDAC Directory is located in C:\Program Files\Common
Files\System\msadc
3) Do you see errors in the application log when you attempt to logon?
Click to expand...
IIS Log entry following unsuccessful attempt via Project Professional - No
entries in the event logs:
#Date: 2005-09-15 13:53:57
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port
cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2005-09-15 13:53:57 128.83.32.194 POST /ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:30 128.83.32.194 POST /ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:31 128.83.32.194 GET /ProjectServer/lgnpspj.asp
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 447 - 128.83.45.28
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

Application Event Log Entries following unsuccessful PWA login on Server:

Type Date Time Source Category Event User Computer
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Information 9/15/2005 9:06:05 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:29 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:28 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Infor

Detail on the MS Project Server Tracing:

File: C:\Office\dev\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x800401e4
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Description: <Description><![CDATA[VERIFYINPTR(NULL)]]></Description>

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]> said:
4) Did you add the Project Server URL to the WSS managed paths
exclusions?
Click to expand...

Yes I did
I wouldn't rule out the port as part of the problem just yet. Did you try
switching the port to 1433 to see if it made a difference?
Click to expand...

I tried switching the SQL listening port to the default 1433 and I get the
same results. So thats not the explanation.

Let me know if you require anything additional and your assistance in
resolving this issue is greatly appreciated!!!!

Angie
Click to expand...
 
S

SMS@UT

Gary,

Sorry it took awhile to get back to you - Ahh the life of a Server Admin -
ANyway in response to your queries for additional info:

The MDAC and the Project Server both live at the root of the virtual server
as virtual directories - As stated earlier the MSADC dll live on the C:
partition and the Project Server application lives on the G: partition.

I have enabled all unsigned ISAPI filters.

The permissions of pjdbcomm.dll are as follows:

IIS - Anonymous, Integrated and Basic
NTFS - Admins, SYSTEM and Users - Full Control

The permissions on msadc.dll are as follows:

IIS: Intergrated and basic (note: the virtual dir. has no perms set)
NTFS: Admin, System - Full control
Users: Read/Execute

One minor item of note the Project Server is installed to a virtual server
instance and not the Default Website of IIS6 - In some of my digging I came
across a veiled ref. to that being a req. I believe I can move or if
recommended reinstall to the Default virtual server.

The dash in the server name is not the FQDN of the Project Server - A cname
has been established for the Project Server Site. I have read and seen KB's
that make reference to an issue with underscores.

Hope that clarifies.

And again thanks for your assistance.




Gary L. Chefetz said:
Angie:

Digging deeper:

Where is MDAC in relation in the IIS tree structure and where is Project
Server virtual directory in the IIS tree structure?
Have you enabled all unsigned ISAPI filters for this application server?
How is directory security set for pjdbcomm.dll?
How about msadcs.dll?

It appears that your server name has a dash in it? Is this correct? I've
seen problems related to dashes in server names. I'm not certain whether
there are any potential conflicts with SMS, but nothing turns up in the KB.




SMS@UT said:
Gary,

Thanks for the speedy response - Ive observed that your a very active
poster
in many of the Project Server discussion groups so Im glad to hear from
you -
See my in-line responses below to your queries:


Gary L. Chefetz said:
It's really difficult to say what's going on here without knowing:

1) What are the other production apps running on the server?
Click to expand...
The server is running SMS and Sharepoint Services
2) Where is the MDAC directory in relationship to Project Server?
Click to expand...
The MDAC Directory is located in C:\Program Files\Common
Files\System\msadc
3) Do you see errors in the application log when you attempt to logon?
Click to expand...
IIS Log entry following unsuccessful attempt via Project Professional - No
entries in the event logs:
#Date: 2005-09-15 13:53:57
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port
cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2005-09-15 13:53:57 128.83.32.194 POST /ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:30 128.83.32.194 POST /ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:31 128.83.32.194 GET /ProjectServer/lgnpspj.asp
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 447 - 128.83.45.28
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

Application Event Log Entries following unsuccessful PWA login on Server:

Type Date Time Source Category Event User Computer
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Information 9/15/2005 9:06:05 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:29 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:28 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Infor

Detail on the MS Project Server Tracing:

File: C:\Office\dev\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x800401e4
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Description: <Description><![CDATA[VERIFYINPTR(NULL)]]></Description>

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]> said:
4) Did you add the Project Server URL to the WSS managed paths
exclusions?
Click to expand...

Yes I did
I wouldn't rule out the port as part of the problem just yet. Did you try
switching the port to 1433 to see if it made a difference?
Click to expand...

I tried switching the SQL listening port to the default 1433 and I get the
same results. So thats not the explanation.

Let me know if you require anything additional and your assistance in
resolving this issue is greatly appreciated!!!!

Angie
Heres the situation:

Server:

Windows 2K3
MDAC 2.8 RTM
Project Server 2003 SP1
WSS SP1
SQL 2K SP3a

Client:

Windows Xp SP2
IE 6
MDAC 2.8 SP1
Project Professional SP1


The issue:

1. Server: Can access PWA via IE6 on the server using Admin
credentials
(both Domain & PS) - CANNOT access PWA using Windows credentials
outside
of
Admins.
2. Windows XP SP2 - Project Professional - CANNOT access using either
Windows credentials or PS creds- 5001 Error Database cannot be
accessed.
3. Windows XP SP2 - PWA - Can login (after failing pass-thru
LGNINT.ASP)
using PS creds and Admin Windows Creds but not any other credentials
(i.e.
non-Admin)

Ran EditSite and passed with flying colors including Database.

Application logs show successful login by ProJectServerUser account

IIS Logs a little more revealing extract of typical external failed
access
(via PWA) follows:

2005-09-14 21:55:14 128.83.32.194 GET /ProjectServer - 80
AUSTIN\stahlap
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
301 0 0
2005-09-14 21:55:14 128.83.32.194 GET /ProjectServer/LGNINT.ASP
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 80 AUSTIN\stahlap
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

My personal favorite 500 internal server error! And try searching for
anything truly revealing on the 'this.oResMgr'....grumble

2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/LGNINT.ASP - 447
AUSTIN\us-projadm 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 2 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/ - 447 -
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 1 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/LGNINT.ASP - 447
AUSTIN\stahlap 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
302 0 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/lgnps.asp err=5001
447
AUSTIN\us-projadm 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
200 0 0

Now before Gary Chefetz chimes in (If I promise to buy your books Gary
will
you give me the answer - It would be well worth it!)

Ive checked the permissions (both NTFS and IIS) - Everything checks
out -
I
even compared this against a working development site - The only
difference
between the two is the production site is all on one box whereas the
development site has a separate SQL box).

Ive even called MS PS - And after 1.5hrs and telling the tech on the
other
end how I fixed one issue (this was the mixed IIS Directory security
settings) Ive kinda despaired and doubt I have the patience or the
fortitude
to fight up the chain

And before someone suggest re-install - This is try number 3 on the
same
box
- Same box same set of conditions everytime - Cant reinstall from bare
metal
as server also provides other production services which cannot be
interuppted.

Ive burned hours searching GOOGLE YAHOO and this discussion thread Ive
tried
a number of suggestions and exhausted the KB articles (which I am
presently
assembling into a troublehooting guide for other poor admins out
there).

Ive also double checked the metabase and authentication modes - And
checked
and compared the Security config settings.

The only big difference between the two is that the development box
happily
listens on the default port for SQL 1433 - Whereas the Production box
does
not - But that cannot be the answer because I can get limited access
external
to the box.

And finally the Sharepoint side works as expected for now - Since I
cant
connect via Project Professional (yes its running SP1 as well) I cant
attempt
to publish and check for the corresponding Sharepoint Site.

So if anyone out there can provide the answer I will offer a reward (in
Gary's case Ill buy his books!).

Dying out here in Austin, Texas and quickly running out of beer money
cus
this issue is driving me to drink!!!

Cheers
Click to expand...
Click to expand...
Click to expand...
 
G

Gary L. Chefetz [MVP]

Project Server and MDAC need to be on the same virtual server.




SMS@UT said:
Gary,

Sorry it took awhile to get back to you - Ahh the life of a Server Admin -
ANyway in response to your queries for additional info:

The MDAC and the Project Server both live at the root of the virtual
server
as virtual directories - As stated earlier the MSADC dll live on the C:
partition and the Project Server application lives on the G: partition.

I have enabled all unsigned ISAPI filters.

The permissions of pjdbcomm.dll are as follows:

IIS - Anonymous, Integrated and Basic
NTFS - Admins, SYSTEM and Users - Full Control

The permissions on msadc.dll are as follows:

IIS: Intergrated and basic (note: the virtual dir. has no perms set)
NTFS: Admin, System - Full control
Users: Read/Execute

One minor item of note the Project Server is installed to a virtual server
instance and not the Default Website of IIS6 - In some of my digging I
came
across a veiled ref. to that being a req. I believe I can move or if
recommended reinstall to the Default virtual server.

The dash in the server name is not the FQDN of the Project Server - A
cname
has been established for the Project Server Site. I have read and seen
KB's
that make reference to an issue with underscores.

Hope that clarifies.

And again thanks for your assistance.




Gary L. Chefetz said:
Angie:

Digging deeper:

Where is MDAC in relation in the IIS tree structure and where is Project
Server virtual directory in the IIS tree structure?
Have you enabled all unsigned ISAPI filters for this application server?
How is directory security set for pjdbcomm.dll?
How about msadcs.dll?

It appears that your server name has a dash in it? Is this correct? I've
seen problems related to dashes in server names. I'm not certain whether
there are any potential conflicts with SMS, but nothing turns up in the
KB.




SMS@UT said:
Gary,

Thanks for the speedy response - Ive observed that your a very active
poster
in many of the Project Server discussion groups so Im glad to hear from
you -
See my in-line responses below to your queries:


:

It's really difficult to say what's going on here without knowing:

1) What are the other production apps running on the server?
The server is running SMS and Sharepoint Services
2) Where is the MDAC directory in relationship to Project Server?
The MDAC Directory is located in C:\Program Files\Common
Files\System\msadc
3) Do you see errors in the application log when you attempt to logon?
IIS Log entry following unsuccessful attempt via Project Professional -
No
entries in the event logs:
#Date: 2005-09-15 13:53:57
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port
cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2005-09-15 13:53:57 128.83.32.194 POST
/ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:30 128.83.32.194 POST
/ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:31 128.83.32.194 GET /ProjectServer/lgnpspj.asp
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 447 - 128.83.45.28
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

Application Event Log Entries following unsuccessful PWA login on
Server:

Type Date Time Source Category Event User Computer
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Information 9/15/2005 9:06:05 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:29 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:28 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Infor

Detail on the MS Project Server Tracing:

File: C:\Office\dev\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x800401e4
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Description: <Description><![CDATA[VERIFYINPTR(NULL)]]></Description>

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

4) Did you add the Project Server URL to the WSS managed paths
exclusions?

Yes I did

I wouldn't rule out the port as part of the problem just yet. Did you
try
switching the port to 1433 to see if it made a difference?

I tried switching the SQL listening port to the default 1433 and I get
the
same results. So thats not the explanation.

Let me know if you require anything additional and your assistance in
resolving this issue is greatly appreciated!!!!

Angie





Heres the situation:

Server:

Windows 2K3
MDAC 2.8 RTM
Project Server 2003 SP1
WSS SP1
SQL 2K SP3a

Client:

Windows Xp SP2
IE 6
MDAC 2.8 SP1
Project Professional SP1


The issue:

1. Server: Can access PWA via IE6 on the server using Admin
credentials
(both Domain & PS) - CANNOT access PWA using Windows credentials
outside
of
Admins.
2. Windows XP SP2 - Project Professional - CANNOT access using
either
Windows credentials or PS creds- 5001 Error Database cannot be
accessed.
3. Windows XP SP2 - PWA - Can login (after failing pass-thru
LGNINT.ASP)
using PS creds and Admin Windows Creds but not any other credentials
(i.e.
non-Admin)

Ran EditSite and passed with flying colors including Database.

Application logs show successful login by ProJectServerUser account

IIS Logs a little more revealing extract of typical external failed
access
(via PWA) follows:

2005-09-14 21:55:14 128.83.32.194 GET /ProjectServer - 80
AUSTIN\stahlap
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
301 0 0
2005-09-14 21:55:14 128.83.32.194 GET /ProjectServer/LGNINT.ASP
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 80
AUSTIN\stahlap
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

My personal favorite 500 internal server error! And try searching
for
anything truly revealing on the 'this.oResMgr'....grumble

2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/LGNINT.ASP -
447
AUSTIN\us-projadm 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 2 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/ - 447 -
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 1 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/LGNINT.ASP -
447
AUSTIN\stahlap 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
302 0 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/lgnps.asp
err=5001
447
AUSTIN\us-projadm 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
200 0 0

Now before Gary Chefetz chimes in (If I promise to buy your books
Gary
will
you give me the answer - It would be well worth it!)

Ive checked the permissions (both NTFS and IIS) - Everything checks
out -
I
even compared this against a working development site - The only
difference
between the two is the production site is all on one box whereas the
development site has a separate SQL box).

Ive even called MS PS - And after 1.5hrs and telling the tech on the
other
end how I fixed one issue (this was the mixed IIS Directory security
settings) Ive kinda despaired and doubt I have the patience or the
fortitude
to fight up the chain

And before someone suggest re-install - This is try number 3 on the
same
box
- Same box same set of conditions everytime - Cant reinstall from
bare
metal
as server also provides other production services which cannot be
interuppted.

Ive burned hours searching GOOGLE YAHOO and this discussion thread
Ive
tried
a number of suggestions and exhausted the KB articles (which I am
presently
assembling into a troublehooting guide for other poor admins out
there).

Ive also double checked the metabase and authentication modes - And
checked
and compared the Security config settings.

The only big difference between the two is that the development box
happily
listens on the default port for SQL 1433 - Whereas the Production
box
does
not - But that cannot be the answer because I can get limited access
external
to the box.

And finally the Sharepoint side works as expected for now - Since I
cant
connect via Project Professional (yes its running SP1 as well) I
cant
attempt
to publish and check for the corresponding Sharepoint Site.

So if anyone out there can provide the answer I will offer a reward
(in
Gary's case Ill buy his books!).

Dying out here in Austin, Texas and quickly running out of beer
money
cus
this issue is driving me to drink!!!

Cheers
Click to expand...
Click to expand...
Click to expand...
 
S

SMS@UT

Gary,

Im not sure I understand the answer a virtual directory for both Project
Server and MDAC are on the same virtual server - Are you implying that
Project Server and Sharepoint must be the same virtual server instance?

Thanks

Angie

Gary L. Chefetz said:
Project Server and MDAC need to be on the same virtual server.




SMS@UT said:
Gary,

Sorry it took awhile to get back to you - Ahh the life of a Server Admin -
ANyway in response to your queries for additional info:

The MDAC and the Project Server both live at the root of the virtual
server
as virtual directories - As stated earlier the MSADC dll live on the C:
partition and the Project Server application lives on the G: partition.

I have enabled all unsigned ISAPI filters.

The permissions of pjdbcomm.dll are as follows:

IIS - Anonymous, Integrated and Basic
NTFS - Admins, SYSTEM and Users - Full Control

The permissions on msadc.dll are as follows:

IIS: Intergrated and basic (note: the virtual dir. has no perms set)
NTFS: Admin, System - Full control
Users: Read/Execute

One minor item of note the Project Server is installed to a virtual server
instance and not the Default Website of IIS6 - In some of my digging I
came
across a veiled ref. to that being a req. I believe I can move or if
recommended reinstall to the Default virtual server.

The dash in the server name is not the FQDN of the Project Server - A
cname
has been established for the Project Server Site. I have read and seen
KB's
that make reference to an issue with underscores.

Hope that clarifies.

And again thanks for your assistance.




Gary L. Chefetz said:
Angie:

Digging deeper:

Where is MDAC in relation in the IIS tree structure and where is Project
Server virtual directory in the IIS tree structure?
Have you enabled all unsigned ISAPI filters for this application server?
How is directory security set for pjdbcomm.dll?
How about msadcs.dll?

It appears that your server name has a dash in it? Is this correct? I've
seen problems related to dashes in server names. I'm not certain whether
there are any potential conflicts with SMS, but nothing turns up in the
KB.




Gary,

Thanks for the speedy response - Ive observed that your a very active
poster
in many of the Project Server discussion groups so Im glad to hear from
you -
See my in-line responses below to your queries:


:

It's really difficult to say what's going on here without knowing:

1) What are the other production apps running on the server?
The server is running SMS and Sharepoint Services
2) Where is the MDAC directory in relationship to Project Server?
The MDAC Directory is located in C:\Program Files\Common
Files\System\msadc
3) Do you see errors in the application log when you attempt to logon?
IIS Log entry following unsuccessful attempt via Project Professional -
No
entries in the event logs:
#Date: 2005-09-15 13:53:57
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port
cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2005-09-15 13:53:57 128.83.32.194 POST
/ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:30 128.83.32.194 POST
/ProjectServer/isapi/pjdbcomm.dll -
447 - 128.83.45.28 Microsoft+Project+Workgroup+Message+Sender 200 0 0
2005-09-15 13:54:31 128.83.32.194 GET /ProjectServer/lgnpspj.asp
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 447 - 128.83.45.28
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

Application Event Log Entries following unsuccessful PWA login on
Server:

Type Date Time Source Category Event User Computer
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:07:13 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:06:28 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Information 9/15/2005 9:06:05 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:29 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Information 9/15/2005 9:05:28 AM MSSQL$USITS (4) 17055 us-sts ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Warning 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 1 LOCAL SERVICE ITS-FILES
Error 9/15/2005 9:05:02 AM Microsoft Project Server Tracing Eventlog
Provider None 2 LOCAL SERVICE ITS-FILES
Infor

Detail on the MS Project Server Tracing:

File: C:\Office\dev\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x800401e4
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Description: <Description><![CDATA[VERIFYINPTR(NULL)]]></Description>

Component: PjQuery
File:
C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1258
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

4) Did you add the Project Server URL to the WSS managed paths
exclusions?

Yes I did

I wouldn't rule out the port as part of the problem just yet. Did you
try
switching the port to 1433 to see if it made a difference?

I tried switching the SQL listening port to the default 1433 and I get
the
same results. So thats not the explanation.

Let me know if you require anything additional and your assistance in
resolving this issue is greatly appreciated!!!!

Angie





Heres the situation:

Server:

Windows 2K3
MDAC 2.8 RTM
Project Server 2003 SP1
WSS SP1
SQL 2K SP3a

Client:

Windows Xp SP2
IE 6
MDAC 2.8 SP1
Project Professional SP1


The issue:

1. Server: Can access PWA via IE6 on the server using Admin
credentials
(both Domain & PS) - CANNOT access PWA using Windows credentials
outside
of
Admins.
2. Windows XP SP2 - Project Professional - CANNOT access using
either
Windows credentials or PS creds- 5001 Error Database cannot be
accessed.
3. Windows XP SP2 - PWA - Can login (after failing pass-thru
LGNINT.ASP)
using PS creds and Admin Windows Creds but not any other credentials
(i.e.
non-Admin)

Ran EditSite and passed with flying colors including Database.

Application logs show successful login by ProJectServerUser account

IIS Logs a little more revealing extract of typical external failed
access
(via PWA) follows:

2005-09-14 21:55:14 128.83.32.194 GET /ProjectServer - 80
AUSTIN\stahlap
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
301 0 0
2005-09-14 21:55:14 128.83.32.194 GET /ProjectServer/LGNINT.ASP
|44|800a138f|'this.oResMgr'_is_null_or_not_an_object 80
AUSTIN\stahlap
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
500 0 0

My personal favorite 500 internal server error! And try searching
for
anything truly revealing on the 'this.oResMgr'....grumble

2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/LGNINT.ASP -
447
AUSTIN\us-projadm 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 2 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/ - 447 -
129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
401 1 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/LGNINT.ASP -
447
AUSTIN\stahlap 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
302 0 0
2005-09-14 22:18:36 128.83.32.194 GET /ProjectServer/lgnps.asp
err=5001
447
AUSTIN\us-projadm 129.116.111.252
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
200 0 0
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PWA PS07: Webpage error details User Agent 4
404 error on Project Workspaces 0
PWA errors after failed SP2a install 1
Project Pro/Server connectivity works over http but not https 1
"Action cannot be performed" in OWA 1
JavaScript Error 0
My Tasks Page not displaying my tasks after installing SP2 4
PDS and SOAP 2

Top