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)
 Enable sa

Author  Topic 

stathis30_2000
Starting Member

23 Posts

Posted - 2007-08-28 : 14:24:37
Hi all,

Does anybody know how can I enable sa account to sql server 2000 ?
There is an 'alter' t-sql statement for sql server 2005. Does this work for 2000?

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-28 : 21:54:09
You should enable sql authentication, check mixed authentication in em -> server properties -> security tab.
Go to Top of Page
   

- Advertisement -