The error details are given as: A connection was successfully established with the server, but then an error occurred during the login process.
Error was saying 'No process is on the other end of the pipe'.It helps to resolve the SQL login failed error 9/16/ Then, copy the path of and create an exception of that file on Firewall. It is another way to prevent the occurrence of this error by simply searching on the drive where SQL Server is installed.