I came into work this morning to discover some problems with an application that uses our SQL Server database. After checking the event viewer, the error messages suggested that the when the application was trying to connect to the database, the login for
the 'sa' user failed (the 'sa' user and password seems to be stored in a web config file that is used by the application to connect to the SQL Server database. So I then tried and failed to connect to SQL Server through SQL Server Management Studio as the
'sa' login. The error message says that:
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)
If I login to SQL Server Management Studio with another login and look at the properties for the 'sa' login, when I go to the user mapping bit I get an error message saying that one or more databases are unavailable (the model database) and it can't be added
to the list. After clicking 'ok' to close the error message, the user mapping for the 'sa' login says that the 'sa' login isn't mapped to any databases. So I'm guessing this is why I can't connect to SQL Server with the 'sa' login.
In SQL Server Management Studio if I then go to Databases>
View Complete Post