I really hope the OP got the problem resolved or called in an expert. If I were the client, I'd be steaming by now if my stuff was still down....

Just to add my two cents in, I have seen a similar error many years ago with an older version of SQL and it was a certificate issue. The certificate...

Does the problem persist when using SQL Native Client instead of the OLEDB?

I've noticed the OLEDB for SQL Server in the wizard does funny things and stopped using it quite...

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

This is an availability group or a clustered instance?

True 'dat!

And the user just informed me that two of the four lines I found are "old" services. Which makes me wonder if this isn't the source of her testing pain.

EXCELLENT. That gave me exactly what I needed. Vended solution services somehow set up inside of SQL Server.

Now I just need to figure out how to fix the problem, which...

Big shop or small shop?

I was just reflecting this morning that the employer I currently work for has both. One small unit that has its own collection of  DBAs, about...

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

That did not come up in Google. I just looked at it, and the principal ID for all lines is dbo, not the SQL login in question.

Is "name" in that...

And now the non-obsolete version that appears to work as well (possibly better?).

$IPAddys = Import-Csv C:\TEMP\FailedSQLLoginSearch_AllSvrs.csv | Select-Object -Property ServerName, LoginName, HostName -Unique 
$results=@()
Foreach ($ips in $IPAddys)
{
...

WHOO HOO! Figured it out. Needed to throw a hash table in there...

Thank you, Frederico. Without your code I never would have reached this. Now I'm just fiddling with user-friendly...

Frederico, the expressions line you gave me isn't working for me. The information writing to the screen is " is unreachable." as if $n.NAME is null or empty and the...

• This reply was modified 1 year, 5 months ago by Brandie Tarvin.

At the moment, configuring extended events is not something I can do. We need to jump through hoops to make changes to production servers and this is a high priority...

• This reply was modified 1 year, 5 months ago by Brandie Tarvin.

Yes, I was messing around and forgot to change xlxs to csv.

Oddly, I'm not getting a file created with your posted suggestion. I'm going to noodle around a little more...

Sigh. I wish I could take comfort in "Your emergency is not my emergency." Sadly, my job makes other people's emergencies my emergency.

Any powershell gurus around? I'm still in my...