Post reply

Login failed for user 'abc\mssqlsrv'. Reason: Failed to open the explicitly specified database

  • January 6, 2016 at 2:49 pm

    #1850045

    I had a similar issue, but when I tried copying a package to a different server. I changed the connection manager to point to the new server but received "login failed for user xx. Reason: Failed to open the explicitly specified database xx. Error: 18456 severity 14 state 38. I worked on this issue for a while and didn't make sense because I could connect fine through SSMS. I dropped the SSIS OLEDB connection and created a new one which resolved my issue.

  • May 17, 2016 at 5:46 am

    #1879446

    I know I'm answering an old topic but since I had the same issue it might help somebody else.

    In my case I found that one job had a step configured on a default database which I detach and the job was running once a week.

    The job itself didn't need the default database to run and because of that it wasn't failing.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply