December 13, 2010 at 4:42 pm
Hi All,
I have what is hopefully an easy question. I've been google searching for quite some time with no luck.
I'm trying to deploy an SSIS package and schedule it as a job. When I am going through the wizard to deploy it, I am getting and error message and I wanted to see if you knew why this was occurring. It is happening after I've clicked the deployment manifest and brought up the wizard. I've double checked that the protection level is "DontSaveSensitive." When I am on the Package Installation Wizard, Specify Target SQL Server screen and select the button with the ellipses to browse for the package, I get the following error:
"An OLE DB Error 0x00040E4D (Login failed for user 'DOMAIN\adminlogin'.) occurred while enumerating packages. A SQL statement was issued and failed."
Please see my attached screen shots for more information.
What does this mean and how might I fix it?
Any suggestions will be appreciated.
Thanks,
BRL
December 13, 2010 at 5:19 pm
Can you try a workaround for me? Login to the SSIS server via SSMS, go to Stored packages, and rt-click 'import package'. See if you can import it from the saved dtsx file. You'll want to login to the SSIS with the same login that you're imitating above.
I hoping to see if that account doesn't have rights, or if there's something goofy with the wizard. My guess is it's a rights issue.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 14, 2010 at 9:52 am
Thanks so much for your response, Craig. In case you couldn't tell I am new to working with SSIS. 🙂
Here is what happens when I follow your instructions above and try to expand the MSDB node beneath stored packages:
I get this error message:
Failed to retrieve data for this request....see the attached screen shot for the complete error message.
I searched around a bit on google but the only thing of use that I found was someone making a vague reference to needing to change the settings for this account in Active Directory?
I'll read through the suggested topic in the books online to see if that helps.
But in the mean time, any thoughts or insights would be greatly appreciated.
BRL
December 14, 2010 at 11:26 am
Update:
I've read through the suggested section in the books online and tried what was suggested there (update the configuration file to the named instance of the database engine and then restart the service), but still no luck.
I am still getting the error outlined above.
I am getting the error in another location as well, when I try to just create a new job without deploying the package, and I am creating the step, and I've filled out info per the screen shot (picture1), and I click on the elipses, I get a similar error message (attached - picture2).
I feel so close and yet so far away....
December 14, 2010 at 11:30 am
This is sounding like SSIS wasn't installed, at all.
Can you check the services on that machine, make sure you see a running SQL SERVER INTEGRATION SERVICES on that system? Easiest way: rt-click my computer, go to manage, switch the computer you're connecting to to the server in question, then open the nodes below, find services, then browse the services available.
Make sure the service is there, and make sure it's running.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 14, 2010 at 12:36 pm
Yes, indeed I see that service running on the server. I've attached a screen shot.
December 14, 2010 at 1:36 pm
bleach (12/14/2010)
Yes, indeed I see that service running on the server. I've attached a screen shot.
Then it's got to be login related, or a serious glitch on the system. Are you the SA for these boxes? Does this happen for all logins, or just this one? Can another sysadmin login and not get the issue?
Also, as silly as it sounds... try a reboot on the server. This is Microsoft, after all.
If it's not login/permissions related and a reboot to clear any possible memory leaks that won't release hasn't cured the issue... I'm at a loss.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply