April 16, 2022 at 2:44 am
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.
April 17, 2022 at 3:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 18, 2022 at 2:48 pm
Do you see SSISDB if you expand "Integration Services Catalogs" ?
https://www.sqlshack.com/introduction-to-the-ssis-catalog-database-ssisdb/
April 18, 2022 at 3:11 pm
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy