May 21, 2009 at 11:59 am
Hey all,
I'm sort of new to SQL Server 2005 and have been struggling with what should be a few basic concepts. I need to run an SSIS package from a server agent job so I can schedule it to run nightly.
First I saved the packages to the File System (ProtectionLevel: EncryptSensitiveWithUserKey), created a proxy with the same account I created the package with, then created the job running it as the proxy. - No luck. It fails at the first (and only) step "Executed as domain\userid. The package execution failed"
Now I'm trying to save the package to the Server but get an error when attempting to do so (file->save copy of package as->)
Package Location: SSIS Package Store
Server: local
Path: MSDB
Protection Level: Rely on Server Storage....
Results in the following error:
" The SQL Server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL server on the computer......Client unable to establish connection - encryption is not supported on SQL server.
My account (domain\userid) is setup as a login on the sql server and is a member of sysadmin. Any ideas on how to get this working would be greatly appreciated. Let me know if yo need any further details...I tried to be fairly concise.
Thanks!
May 26, 2009 at 12:40 pm
I'm still in need of help if anyone has ideas - thanks!
May 26, 2009 at 12:43 pm
Are you attempting to accomplish this from your desktop system or are you logged on directly to your server?
May 26, 2009 at 2:44 pm
Lynn - I am logged on directly to the server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply