Failed to open the explicitly specified database

• mrsiro

  Old Hand

  Points: 376

  More actions

  April 16, 2022 at 2:44 am

  #4017009

  Hello guys, have a nice day.

  I have sqlserver 2017 enterprise, i view log in ssms. I see error:

  Login failed for user 'WORKGROUP\SERVER$'. Reason: Failed to open the explicitly specified database 'SSISDB'. [CLIENT: <local machine>]

  I check in my database, SSISDB have no exist.

  This error writter many line in log. Can you guys help me solved this error.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  April 17, 2022 at 3:10 am

  #4017438

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  April 18, 2022 at 2:48 pm

  #4018040

  Do you see SSISDB if you expand "Integration Services Catalogs" ?

  https://www.sqlshack.com/introduction-to-the-ssis-catalog-database-ssisdb/

  • This reply was modified 2 years, 8 months ago by  homebrew01.

• Ed B

  Hall of Fame

  Points: 3669

  More actions

  April 18, 2022 at 3:11 pm

  #4018044

  homebrew01 wrote:

  Do you see SSISDB if you expand "Integration Services Catalogs" ?

  https://www.sqlshack.com/introduction-to-the-ssis-catalog-database-ssisdb/

  Do you need to create a catalog before the db exists?

  I don't know if the OP needs the catalog, or if they just need to change their connection so it has a default database of master.