Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 MSDE authentication security?

Author  Topic 

Starting Member

2 Posts

Posted - 2008-04-07 : 15:35:03
New to sql in general.

Are there any security issues with a default install of MSDE? I left the username as 'sa' and password blank, should this be changed? I have it installed on a 2003 R2 server and XP sp2 client, without active directory but will soon implement ad. Should I use nt authentication or something else, if so, how would I accomplish this? Or should I just change the default sa and blank password to something else, how would I enter this on both the server and client. Will this affect other instances of msde? Do I have to make any changes to the 2003 local security policy, this has been altered from the defaults due to security.

If anymore info is needed just holler, thanks for any comments.

Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-14 : 22:33:54
Should change sa password asap, and msde sets to windows authentication only by default.
Go to Top of Page

- Advertisement -