F
Forester1
Hi! I am upgrading a system from Win2k, IIS5, ApplicationXtender 5.25, and
ASP.Net 1.1.4 to W2k3, IIS6, AX5.4Sp1, and ASP.Net 2.0.5 by building a new
server. The server this is on connects to a remote SQL2000 server. Everything
works great except a piece of third party code that parses an xml request
from some proprietary software and uses it to query the AX database on the
SQL Server for an image. When it tries to log into the DB it gets the
following error on the web page:
[COMException (0x80410257): Unknown error 0x80004005
Unknown error 0x80004005]
Interop.AexDB.DBConnectionClass.Login(Object UserName, Object Password,
Object Provider, Object DSN, Object DbUserName, Object DbPassword) +0
AXDB.AXNetConnect.GetAXDocuments(String FieldValue) in
C:\dev\aspnet35\workspace\IndusAXProject\AXInterfaceLibrary\AXDB.cs:30
EDMSforIndus._Default.Page_Load(Object sender, EventArgs e) in
C:\dev\aspnet35\workspace\IndusAXProject\EDMSforIndus\Default.aspx.cs:22
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o,
Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
In addition, the following shows up as an application Event Warning (IP
address removed):
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 8/4/2008
Time: 2:23:57 PM
User: N/A
Computer: HALOIDTEST
Description:
Event code: 3005 Event message: An unhandled exception has occurred. Event
time: 8/4/2008 2:23:57 PM Event time (UTC): 8/4/2008 8:23:57 PM Event ID:
b7e12afd7279497686ac473ff172a6b6 Event sequence: 3 Event occurrence: 1
Event detail code: 0 Application information: Application domain:
/LM/W3SVC/1/Root/Indus-1-128623550369347515 Trust level: Full
Application Virtual Path: /Indus Application Path:
c:\inetpub\wwwroot\Indus\ Machine name: HALOIDTEST Process
information: Process ID: 2928 Process name: w3wp.exe Account
name: NT AUTHORITY\SYSTEM Exception information: Exception type:
COMException Exception message: Unknown error 0x80004005
Unknown error 0x80004005 Request information: Request URL:
http://haloidtest/indus/default.aspx Request path: /indus/default.aspx
User host address: xxx.xxx.xxx.xxx User: Is authenticated:
False Authentication Type: Thread account name: NT
AUTHORITY\SYSTEM Thread information: Thread ID: 1 Thread account
name: NT AUTHORITY\SYSTEM Is impersonating: False Stack trace:
at Interop.AexDB.DBConnectionClass.Login(Object UserName, Object Password,
Object Provider, Object DSN, Object DbUserName, Object DbPassword)
at AXDB.AXNetConnect.GetAXDocuments(String FieldValue) in
C:\dev\aspnet35\workspace\IndusAXProject\AXInterfaceLibrary\AXDB.cs:line 30
at EDMSforIndus._Default.Page_Load(Object sender, EventArgs e) in
C:\dev\aspnet35\workspace\IndusAXProject\EDMSforIndus\Default.aspx.cs:line 22
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object
o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
I have tried to permission this every way from Sunday, including web
permissions, directory permissions, registry permissions, etc etc for every
conceivable service from aspnet to iusr to system to network service to no
avail. The third party programmer is trying to blame it on our baseline
security group policies, but the server has been removed from the baseline,
and should be restored to normal. It works on his test system, so he is at a
loss to figure it out. It works on our old system just fine, but he has
reprogrammed some of the code for the new server. He gets the UserName and
UserPassword from web.config. The connection in the application is set to
connect via OLE DB. Below are the lines that seem to be failing (AXDB.cs:30):
DBConnection oAEXDB = new DBConnectionClass();
//oAEXDB.RegistryKey =
@"\HKEY_CURRENT_USER\SOFTWARE\XtenderSolutions\ApplicationXtender\Database";
oAEXDB.Login(ConfigurationSettings.AppSettings["AXUser"],
ConfigurationSettings.AppSettings["AXPass"], Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
Here are the settings from web.config (password removed):
<appSettings>
<add key="appname" value="AP_INVOICES"/>
<add key="fieldcolumn" value="8"/>
<add key="fieldvalue" value="*"/>
<add key="AXUser" value="sysop"/>
<add key="AXPass" value="xxxxxxxx"/>
</appSettings>
ApplicationXtender itself works fine on this server, as does the sysop
login. The code from the old server copied over to this server gets the same
error, making me believe it is a difference of IIS6 and /or APS.Net 2.0.5.
Would "Is authenticated: False" or "Is impersonating: False" have anything to
do with it, and if so, how would i fix that? Does anybody have a clue? Thanks
in advance!
ASP.Net 1.1.4 to W2k3, IIS6, AX5.4Sp1, and ASP.Net 2.0.5 by building a new
server. The server this is on connects to a remote SQL2000 server. Everything
works great except a piece of third party code that parses an xml request
from some proprietary software and uses it to query the AX database on the
SQL Server for an image. When it tries to log into the DB it gets the
following error on the web page:
[COMException (0x80410257): Unknown error 0x80004005
Unknown error 0x80004005]
Interop.AexDB.DBConnectionClass.Login(Object UserName, Object Password,
Object Provider, Object DSN, Object DbUserName, Object DbPassword) +0
AXDB.AXNetConnect.GetAXDocuments(String FieldValue) in
C:\dev\aspnet35\workspace\IndusAXProject\AXInterfaceLibrary\AXDB.cs:30
EDMSforIndus._Default.Page_Load(Object sender, EventArgs e) in
C:\dev\aspnet35\workspace\IndusAXProject\EDMSforIndus\Default.aspx.cs:22
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o,
Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
In addition, the following shows up as an application Event Warning (IP
address removed):
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 8/4/2008
Time: 2:23:57 PM
User: N/A
Computer: HALOIDTEST
Description:
Event code: 3005 Event message: An unhandled exception has occurred. Event
time: 8/4/2008 2:23:57 PM Event time (UTC): 8/4/2008 8:23:57 PM Event ID:
b7e12afd7279497686ac473ff172a6b6 Event sequence: 3 Event occurrence: 1
Event detail code: 0 Application information: Application domain:
/LM/W3SVC/1/Root/Indus-1-128623550369347515 Trust level: Full
Application Virtual Path: /Indus Application Path:
c:\inetpub\wwwroot\Indus\ Machine name: HALOIDTEST Process
information: Process ID: 2928 Process name: w3wp.exe Account
name: NT AUTHORITY\SYSTEM Exception information: Exception type:
COMException Exception message: Unknown error 0x80004005
Unknown error 0x80004005 Request information: Request URL:
http://haloidtest/indus/default.aspx Request path: /indus/default.aspx
User host address: xxx.xxx.xxx.xxx User: Is authenticated:
False Authentication Type: Thread account name: NT
AUTHORITY\SYSTEM Thread information: Thread ID: 1 Thread account
name: NT AUTHORITY\SYSTEM Is impersonating: False Stack trace:
at Interop.AexDB.DBConnectionClass.Login(Object UserName, Object Password,
Object Provider, Object DSN, Object DbUserName, Object DbPassword)
at AXDB.AXNetConnect.GetAXDocuments(String FieldValue) in
C:\dev\aspnet35\workspace\IndusAXProject\AXInterfaceLibrary\AXDB.cs:line 30
at EDMSforIndus._Default.Page_Load(Object sender, EventArgs e) in
C:\dev\aspnet35\workspace\IndusAXProject\EDMSforIndus\Default.aspx.cs:line 22
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object
o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
I have tried to permission this every way from Sunday, including web
permissions, directory permissions, registry permissions, etc etc for every
conceivable service from aspnet to iusr to system to network service to no
avail. The third party programmer is trying to blame it on our baseline
security group policies, but the server has been removed from the baseline,
and should be restored to normal. It works on his test system, so he is at a
loss to figure it out. It works on our old system just fine, but he has
reprogrammed some of the code for the new server. He gets the UserName and
UserPassword from web.config. The connection in the application is set to
connect via OLE DB. Below are the lines that seem to be failing (AXDB.cs:30):
DBConnection oAEXDB = new DBConnectionClass();
//oAEXDB.RegistryKey =
@"\HKEY_CURRENT_USER\SOFTWARE\XtenderSolutions\ApplicationXtender\Database";
oAEXDB.Login(ConfigurationSettings.AppSettings["AXUser"],
ConfigurationSettings.AppSettings["AXPass"], Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
Here are the settings from web.config (password removed):
<appSettings>
<add key="appname" value="AP_INVOICES"/>
<add key="fieldcolumn" value="8"/>
<add key="fieldvalue" value="*"/>
<add key="AXUser" value="sysop"/>
<add key="AXPass" value="xxxxxxxx"/>
</appSettings>
ApplicationXtender itself works fine on this server, as does the sysop
login. The code from the old server copied over to this server gets the same
error, making me believe it is a difference of IIS6 and /or APS.Net 2.0.5.
Would "Is authenticated: False" or "Is impersonating: False" have anything to
do with it, and if so, how would i fix that? Does anybody have a clue? Thanks
in advance!