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...

• This reply was modified 1 year, 4 months ago by  Stamey.

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...

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...

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...

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...

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...

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...

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...

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...

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...

• This reply was modified 2 years, 7 months ago by  Stamey.

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...

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...

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...

So, how do you scale this solution?

Thanks,

Chris

Jeffrey, I don't believe I have ever done that, so I don't know how.

Thanks,

Chris