On Friday I had to change my domain password and my employer upgraded my machine to Win11 over the weekend. There also seems to have been an upgrade to our security software. Not sure which parts of this might be relevant.
I’ve been running SQL Server Management Studio (SSMS) using runas.exe (in a shortcut on my taskbar) with no problem under Win10. Since the upgrade, however, while SSMS will run under the alternate windows credentials, it has stopped passing the credentials through to the SQL Servers I’m trying to connect to. When I try to connect, I almost always get
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)
Sometimes I’m able to log in to our servers in different domains, but it’s not consistent. I don’t have the same problem trying to do the exact same thing in Azure Data Studio. Just SSMS. Odder still, if, instead, I shift click the app and choose ‘Run as different user’, I don’t experience any problems at all.
I’m not really sure where to start with this. I’ve rebooted. I don’t really have other domain-linked SQL logins I can test with. Can anyone offer any suggestions as to where the problem lies?
