MS SQL Server Error: No Process is on the other end of the pipe
-
Full error...
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.)(Microsoft SQL Server, Error: 233)
This error tends to happen when you are trying to authenticate with a SQL Server account on a system that is only configured for Windows Authentication. MS SQL Server allows SQL accounts to be created regardless of this setting in the configuration and gives no errors (for logical reasons we could go into) so it is easy to do without realizing it. So if you see this error, check to make sure that SQL Server authentication is enabled or use a Windows account instead.
-
@scottalanmiller said in MS SQL Server Error: No Process is on the other end of the pipe:
Full error...
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.)(Microsoft SQL Server, Error: 233)
This error tends to happen when you are trying to authenticate with a SQL Server account on a system that is only configured for Windows Authentication. MS SQL Server allows SQL accounts to be created regardless of this setting in the configuration and gives no errors (for logical reasons we could go into) so it is easy to do without realizing it. So if you see this error, check to make sure that SQL Server authentication is enabled or use a Windows account instead.
We deal with some really clunky front ends that run with SA/SQL Authentication so hybrid mode is a setting that gets done during the initial instance setup process.
The other thing to keep in mind is that if there is more than one admin account being used to manage that instance, or those instances, to make sure to add those accounts during the instance creation process otherwise pain ensues.
-
Thank you for the heads up @scottalanmiller
