[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 9
  • Last Modified:

SSIS package run on sql job

hi
 i try to run a SSIS package on sql server 2005, the package runs on SSIS, but when i put into server and run from the server i got  ConnGetProxyPassword error,
i create a Proxy account, it's my network ID, and i have admin rights on the server, thanks for your help.
0
tristonyip
Asked:
tristonyip
  • 2
1 Solution
 
prequel_serverCommented:
having admin rights on the server does not always mean you have admin rights in SQL Server. If your AD/network id was not added as an admin during sql server installation then you may not have full admin rights.

this kb should help: http://support.microsoft.com/kb/918760
0
 
Alpesh PatelAssistant ConsultantCommented:
Hi,

you can check my below article to run ssis package from SQL agent using proxy.

http://www.experts-exchange.com/Database/MS-SQL-Server/A_8452-Execute-SQL-Job-with-Proxy.html
0
 
tristonyipAuthor Commented:
i finally go this  work. upgrade sql service pack.
0
 
tristonyipAuthor Commented:
this works finally.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now