22 May, 2009
0 Comments
0 categories
Problem
When connecting with windows authentication, the following exception was thrown:
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)
Solution
Turns out the user had a default database that no longer existed.
Changing the default database to Master solved the problem
Tags: SQL Server