ahh thanks, i was confused as when i think of create schema... i think its a command to Create a schema, such as create schema "Name of Schema".

but if it...

got it working, the problem was the url for:

<SystemResourcePackage xmlns="https://schemas.microsoft.com/sqlserver/reporting/2016/01/systemresourcepackagemetadata"

change to:

<SystemResourcePackage xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/systemresourcepackagemetadata"

I was using https and needed to be http.

Hey Everyone, thank you for all your input, so here is my question and situation of thinking of a solution.

I want to copy data from a certain filegroup, dynamically by...

Also Sue, do you know if backing up or even creating an encryption key is necessary at all? or can you still have a good recovery just by restoring the...

great thank you

Hello Jeff and DinoRS, thank you for your input, sorry the secondary or the other filegroup is not read only, though knowing this now thanks for the info, just wondering...

Hello Everyone

just an update, I tried to do the following from this Article URL, however so far nothing works 🙁

https://www.systoolsgroup.com/how-to/fix-error-3154-in-sql-server/

Sorry I know this is a very old old old post, but hopefully @tibco29 can respond, where did they hear that information, that the Web Service URL is never to...

Thank you Phil for answering my question, though condescending response, but I am also a straight shooter.

I am trying to understand, as with setting up anything.

I just need to know...

No, just trying to understand what its asking me to do since this is for security reasons.  but it might come up in a exam 😛

Hey Phil,

sorry maybe it is, but its regarding the screen shot below, setting permissions etc. just need to know which and what grants purpose etc.

thanks again for your assistance Phil, so what I am getting at is (I am slow sorry), is it does work with Integration catalog SSISDB, BUT you have to push/pull...

Hello Jeffrey and Phil,

thank you for taking the time to answer me post.

The reason I wanted to connect SSMS to SSIS was to make sure it was up and running...

Hello @anthony-2.green, thanks for replying back, I am talking about the Service account, I did use the local service and the NT service, however when I use either, after installation,...

Hey Anthony,

thank you for the reply, and thank you for the information about snapshot replication, we are looking at HA AG however for the sake of time and storage (we...