Viewing 15 posts - 1 through 15 (of 55 total)
This is the guide I used
https://www.sqlshack.com/moving-the-ssisdb-catalog-on-a-new-sql-server-instance/
If you have a better one I will happily review it.
April 24, 2024 at 11:42 am
As part of the guide it ran me though exactly that checking first the password was all good on the source and destination all good.
it is definatly a head scratcher.
April 24, 2024 at 10:30 am
So i have ran though the guide to migrate the SSISDB correctly. and unfortunatly i am still recieving the same error.
To set the scene as i noticed the error occured...
April 24, 2024 at 9:51 am
So we have no issue logging into the the instance at all, the setup is pretty much as it was before i migrated. The issue only arises when I try...
April 23, 2024 at 4:59 pm
I will see where i get on and feedback to let you know how i got on.
April 23, 2024 at 4:56 pm
I did not, All i did was to lift and shift the Database and restore it to the new instance. That said i am not 100 with SSIS and as...
April 23, 2024 at 3:28 pm
I can 100% say i did not follow the procedure that said i did review the procedure after, I am in the proces sof seeing if the team has the...
April 23, 2024 at 3:13 pm
I maybe wrong however I dont believe certs were configured on the last deployment unless 2022 requires them. i will speak to the infra team and see what they say.
April 23, 2024 at 3:09 pm
Thanks for your feedback guys, i am glad i stimulated some conversation.
The actual data i am querying is abundant and the data I gave a a very simple example of...
February 16, 2023 at 2:40 pm
natural will be fine no rounding up required. or rounding down.
February 15, 2023 at 4:51 pm
February 15, 2023 at 4:49 pm
Thanks for the assistance everyone.
I tried SQLCMD as well as attempting ot find a solution in other articles articles to get me around in the end i had to uninstall...
February 13, 2023 at 1:56 pm
So the instance starts, however because i am using the -f flag i get the error Server is in single user mode. Only one administrator can connect at a time...
February 10, 2023 at 1:05 am
Thanks for your reply.
Unfortunately I have tried -m flag however when i use this flag it attempts to create the tempdb files on the volume that has insufficient space and...
February 10, 2023 at 12:32 am
Viewing 15 posts - 1 through 15 (of 55 total)