Viewing 15 posts - 1 through 15 (of 196 total)
I finally found an error message from the pipeline.
ErrorCode=InvalidTemplate, ErrorMessage=Unable to parse expression 'SchemaName'
It doesn't tell me enough to find the problem. I tried removing the last item, a Procedure...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 25, 2022 at 1:05 pm
No, not much of it was written. Just parameter values had to be entered. This is the code behind the GUI. Kind of like an SSIS GUI that generates JSON...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 24, 2022 at 12:37 pm
I do see the groups MSSQLSERVER and MSSQLSERVERAGENT having full control rights to various folders, the agent group having less. I only saw the agent on MSSQL12.MSSQLSERVER\MSSQL\Log with full control...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 19, 2022 at 6:04 pm
I tried the account on SQL Agent on a different server, one of the three we set up at this time, and it works fine on the other server.
How would...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 19, 2022 at 11:11 am
Agreed. Now if it would just give me an error with a clue in it....
I have even tried running ProcMon (sysinternals), and filtering on SQLAgent.exe and the login account, but...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 17, 2022 at 2:34 pm
So, how do you scale this solution?
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 17, 2022 at 2:00 pm
Jeffrey, I don't believe I have ever done that, so I don't know how.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 17, 2022 at 11:18 am
Nope, that was one of the first things I tried. I just changed it and changed it back again, just for giggles, and still didn't help.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 16, 2022 at 7:45 pm
Nope, that didn't help. And the error remains an ambiuous "Access is Denied".
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 16, 2022 at 7:23 pm
Finally stumbled across the solution. You have to connect the objects for with a workflow, something that the documentation on the MS page did not mention. Now to work through...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 10, 2022 at 5:48 pm
I can successfully connect to the Azure DB using a query window in SSMS with the same account I am trying to use for the linked server, and this is...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
November 10, 2021 at 2:38 pm
Thanks for the reply. Yes, it does appear to be an authentication problem, but since I have successfully connected using the necessary credentials, I have ruled out that as a...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
November 5, 2021 at 1:56 pm
Thanks for the info. I will look into that.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
January 6, 2020 at 2:23 pm
"Use DBName" is an excellent practice and will serve you well.
This, for instance, will fail at the Use statement if the DB doesn't exist and nothing else will execute.
Use MYDB
Create...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
August 7, 2019 at 2:46 pm
I will try this when I get back from vacation.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
May 13, 2017 at 8:18 am
Viewing 15 posts - 1 through 15 (of 196 total)