August 24, 2009 at 11:33 am
I now get the following event log error when trying to run a package from my IIS app ( on the same server as SSIS ):
Login failed for user 'myuser'. [CLIENT:
Now, I have this app running under my username and password so rights shouldn't be an issue. The package runs just fine when I run it from SSIS and the package from IIS in development it runs just fine. But when I try to run on the staging server from IIS I get this error. Any help is appreciated.
August 24, 2009 at 11:40 am
Check the security settings if your package AND of your IIS.
If the package is configured to use SQLAuthentication (SQLusername and password), it should run fine if your IIS has the auth to run the package (seems to be the case)
If you package is configured to use Windows authentication, it will use the IIS service account or the account configured in IIS.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 24, 2009 at 1:03 pm
Now, I have this app running under my username and password so rights shouldn't be an issue. The package runs just fine when I run it from SSIS and the package from IIS in development it runs just fine. But when I try to run on the staging server from IIS I get this error. Any help is appreciated.
That is not correct because in Asp.net it runs in the context of the Asp.net runtime that is the reason your permissions are not recognized. If you want to use your permissions you need to deny Anonymous Access in IIS and in your Web.Config enable impersonation. The other option is to add the the network service account used by Asp.net on the server level and in the database used to run your SSIS package.
Kind regards,
Gift Peddie
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply