Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nlella
Starting Member
2 Posts |
 Posted - 2005-08-03 : 13:17:59
|
| Hello,I have a DTS package on Server A which is executed from a web-application om server B. The DTS package executes fine if the DTS has only SQL Statements. If I try to crate a file or read in from a file on ServerA in the DTS the package fails.When I looked in the event viewer on Server A, this is what it shows.Error: 0, Severity: 20, State: 0Stored function 'xp_MSADEnabled' in the library 'xpstar.dll' generated an access violation. SQL Server is terminating process 54.I have tried both using windows authentication and also SQl authentication. I have even tried using the 'SA' account. Still I end up with the same error.Any help will be appreciated.Thanks |
|
|
nlella
Starting Member
2 Posts |
Posted - 2005-08-03 : 13:45:44
|
| I have changed the MSSQLServerADhelper to run as a Administrator rather than a local account. Now i don't see that(above) error in the event viewer but the DTS package still fails!Also, The DTS package runs ok if I test it on the Server B both from the enterprise manager and also from a web application that resides on server B. The package only fails if I run it from a web application in remote server(Server A).Any help??? |
 |
|
|
|
|
|
DTS Failure with xp_MSADEnabled access violation