Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bmoline
Starting Member
5 Posts |
 Posted - 2007-10-05 : 11:05:29
|
| After I have changed the SA password and attempt to login I get the following 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)If I change the password back I can login without any problems. I need to change the SA password.Thanks for any suggestions. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 23:23:11
|
| How did you change sa password? How can you change it back if you can't connect to sql server? |
 |
|
|
bmoline
Starting Member
5 Posts |
Posted - 2007-10-06 : 09:17:39
|
| By going into Security, SA and changing password.I have a Windows Authentication account. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-06 : 12:20:38
|
| Did you enable mixed authentication on the server? |
|
|
|
bmoline
Starting Member
5 Posts |
Posted - 2007-10-08 : 12:51:53
|
| I have enabled Mixed Mode Authentication. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-08 : 21:46:46
|
| Ensure you entered correct sa password, otherwise will get this error. |
|
|
|
bmoline
Starting Member
5 Posts |
Posted - 2007-10-09 : 10:30:44
|
| I'm trying to change the password so it will be different after I have changed it. Thanks for trying to help. |
|
|
|
|
|
|
Changing SA password