September 30, 2008 at 1:15 pm
Hi, Our 3 scheduled SQL jobs failed last night, basically these jobs run DTS packages. I am getting the below error:
Error: -2147467259 (80004005); Provider Error: 4064 (FE0)
Error string: Cannot open user default database. Login failed.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Thanks!
September 30, 2008 at 2:49 pm
make sure the execution account is setup properly. open the login and ensure that the login has access to it's default database.
August 8, 2010 at 2:24 pm
Hi
i was taking backup on my production server and restored it.After a while my scheduled jobs around 40 failed...
please give me a perfect solutions for troubleshooting this issue ....
thanks
aashu
August 31, 2010 at 3:48 pm
Did the backup you restored come from a different server? If so, you probably have orphaned users. Try going through your users and running sp_change_users_login 'update_one','username','loginname'
August 31, 2010 at 3:54 pm
mohd.sql (8/8/2010)
Hii was taking backup on my production server and restored it.After a while my scheduled jobs around 40 failed...
please give me a perfect solutions for troubleshooting this issue ....
thanks
aashu
Why are you adding your question to a 2 year old thread with a different problem?
Next time, please ask your question in a new thread.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply