Viewing 15 posts - 1 through 15 (of 205 total)
Sorry, it is always SSMS being used for the connection attempts. But I thought of what it was, and found that someone disabled TCPIP protocol for SQL Server there. It's...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
July 26, 2023 at 5:39 pm
I dug around some more on the internet and finally got the code to do exactly what I want. This code will display the list of group members in columns...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 15, 2023 at 6:40 pm
While I appreciate the effort, the code does not work well for me. I added my checking and loading of the input file at the top of the code. The...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 15, 2023 at 2:56 pm
OK, I made some mods to the code and now it's doing almost everything I want.
I originally put the $Domain code in the Catch section because it did something unexpected...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
February 15, 2023 at 1:51 pm
I finally got this fixed, although I still have no definitive reason for it. I had a Windows admin get involved and they found that the account with the incorrect...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
November 17, 2022 at 3:39 pm
I checked the logon server for each node in this cluster, and they are using different DCs. I am trying to engage the Windows team to help me work through...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
November 1, 2022 at 5:21 pm
Yes, I removed the user from all DBs first. Then deleted the login and recreated the login. At this point the DB user doesn't matter because the login does not...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 31, 2022 at 1:48 pm
Well, we found something that worked, but I am still unsure why. The DB had two log files. We did a backup the the logs then removed the second log...
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
October 6, 2022 at 5:17 pm
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
Viewing 15 posts - 1 through 15 (of 205 total)