When I'm trying to create several users in SQL Management Studio, I first create them under the server name, followed by the database. However, when I'm trying to log on, I keep getting this error message:
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)
What can I do to stop getting these error messages.