I'm getting this error:
Cannot connect to DATABASE
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Framework Microsoft SqlClient Data Provider)
Server Name: DATABASE
Error Number: 233
Severity: 20
State: 0
etc....
I installed the oracle 19c client to configure a dblink and then added the Oracle OLE DB provider for the dblink.
I tried to configure it, and trying to create one, SQL Server Management Studio crashed, I had to close it with task manager.
After that, trying to log in again, I received this error.
It seems there are active sessions, but it does not load the object tree on the left, there is the waiting wheel that spins.
I see multiple sessions of 'sa' (my administrator user) with high waits.
What could it be?
Thanks