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 |
|
ZachM
Starting Member
28 Posts |
 Posted - 2007-10-31 : 08:37:34
|
Hi All, I deploy my ssis package on sql 2005 Integration Services and I am also able to run the package from Integration Services\Stored Packages. However, when I create a job and try to execute the job, I get the following error:Description: "Login failed for user 'PQBSNET\RFWSQLSTG2$'.". End Error Error: 2007-10-29 15:49:43.74 Code: 0xC020801C.I am told by the dba that they have created an admin account for me on the server and I should be able to execute the job without any problem. I am lost as to why I am not able to run the job. Any help would be greatly appricated.ThanksZach  |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-10-31 : 10:29:46
|
| How have you setup the connection in the package? Windows Authentication or SQL Authentication?When running the Job you may be using different User ID then the connection in the package. |
 |
|
|
ZachM
Starting Member
28 Posts |
Posted - 2007-10-31 : 12:27:45
|
| I am using window authentication |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-31 : 23:14:37
|
| Do you try to logon to remote server in the package? Is pqbsnet a domain? Who is job owner? |
|
|
|
ZachM
Starting Member
28 Posts |
Posted - 2007-11-01 : 08:15:30
|
| Yes pqbsnet is a domain. I own the job. I am able to run the job within the server, however when I have to deploy the data between two servers(stage and production) then it fails. Do I need a domain account to schedule the job? I was told I need to create a config file in order to deploy the data between two servers. Is that right? |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-11-01 : 10:06:30
|
| Since you are using window authentication in the package, who is logged on the production/deployed server?You might want to check if the user logged on production/deployed server has rights to the database server to access the tables, views etc. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 23:00:18
|
| Did you add 'PQBSNET\RFWSQLSTG2$' as sql login on remote servers? |
|
|
|
ZachM
Starting Member
28 Posts |
Posted - 2007-11-05 : 16:14:16
|
| thanks all, I created a domain account on sql 2k5 and it worked. |
|
|
|
|
|
|
sql server agent