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 |
|
kashif27
Starting Member
7 Posts |
 Posted - 2009-06-25 : 05:21:22
|
Hi . . . . .When I installed SQL Server 2005, I chose "Windows Authentication" Mode. Now I want to change it to "SQL Server Authentication" mode. When connecting to SQL Server in the Management Studio, at the login screen I select Authentication as "SQL Server Authentication" and give the default Login: sa and Password:123, it gives me teh following error
TITLE: Connect to Server------------------------------Cannot connect to UZ.------------------------------ADDITIONAL INFORMATION: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)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476------------------------------BUTTONS:OK------------------------------
So what is that I have to do to change the Authentication Mode. Thankshttp://www.KashifUmar.com/ |
|
|
kashif27
Starting Member
7 Posts |
Posted - 2009-06-25 : 05:24:02
|
Here is another error message that I get while trying to do the same login process.
TITLE: Connect to Server------------------------------Cannot connect to UZ.------------------------------ADDITIONAL INFORMATION:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476------------------------------BUTTONS:OK------------------------------
http://www.KashifUmar.com/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
How To Change Authentication Mode