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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Server Registration

Author  Topic 

real_pearl
Posting Yak Master

106 Posts

Posted - 2004-06-09 : 06:24:32
At the time of installation only windows authentication was selected instead of Mixed Mode. Now I want to register server through SQL Server Authentication, How I can do this?

mr_mist
Grunnio

1870 Posts

Posted - 2004-06-09 : 06:39:22
From BOL -

quote:

To set up Mixed Mode security

Expand a server group.


Right-click a server, and then click Properties.


Click the Security tab.


Under Authentication, click SQL Server and Windows.



-------
Moo. :)
Go to Top of Page

real_pearl
Posting Yak Master

106 Posts

Posted - 2004-06-09 : 06:58:03
Thanks,

How I can change the password for SA?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-09 : 12:35:13
sp_password

Tara
Go to Top of Page
   

- Advertisement -