August 13, 2009 at 3:56 am
Hi,
First I explain the environment that I have in my system. I work for client in US and I have VPN in my system through which I am able to access their server. The client has given me SQL server authentication in their server. I created the package on their database and now I have to create job for it.
For the job to run I have to create proxy user. For that I am able to create some temporary login but I am not able to create any credential for it. I told this issue to client so he gave me a proxy user with his credential which was working properly in his system but I am still not able to execute the job with the same proxy that is given by the client.
I don’t have windows authentication in that server. I am also not administrator in that system.
Any help or suggestion of what might be the reason.
Thanks
August 13, 2009 at 9:05 am
If you work for a client running SQL Server in the US then you need to buy the under $50.00 Developer edition so you can configure everything you need on your client's server in your local developer edition so you just repeat the tasks when you VPN into the server. You are trying to run a package as a job the owner of the package also needs to be admin in SSIS. There is a step by step configuration and guide from Microsoft I will look and post those links for you.
http://www.mssqltips.com/tip.asp?tip=1180
http://support.microsoft.com/kb/918760
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply