June 22, 2009 at 7:05 am
Hi. I have deployed a newly created SSIS package to the target SQL server. I created the package locally using Windows Authentication (each connection uses Windows Authentication). I also used Windows Authentication when specifying the target sql server. My question is ideally I would not want to use Windows Authentication. Should I create a SQL account specifically for SSIS packages and amend my package connection details?
What do you experts do 🙂
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
June 22, 2009 at 8:29 am
Hi, in answer to my own question I decided to create a new sql login and grant 'SELECT' permissions to the limited number of tables the account needed to access to.
Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
June 22, 2009 at 9:13 am
OK, I could run the package OK with the new credentials however I was unable to complete the 'Package Installation' wizard on the target server.
To resolve this added the login to the db_dtsadmin role on msdb.
The package imported OK. However I am unable to schedule a task to execute the package.
Error as follows:
Message
Executed as user: DOMAIN\SQLServiceAccount. ...sion 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 16:07:43 Error: 2009-06-22 16:07:43.67 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2009-06-22 16:07:43.68 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2009-06-22 16:07:43.85 Code: 0xC0202009 Source: Package Connection manager "SQL... The package execution fa... The step failed.
Anyone come across this before?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply