Welcome to Anything Forums! We are a general discussion forum that believes in freedom of expression and aim to provide a low moderation (within reasonable means) environment to discuss any topic. If you want to join, simply click HERE to be taken to our account management system where you can make an account. If you had an account at iceteks.com, anythingforums.com, uovalor.com or uogateway.com in the past it has been transfered over and you can simply do a password reset.
Computer builds, hardware and software discussion or troubleshooting, including peripherals. Essentially a general place to talk about desktop computers.
3.4.2 Security Considerations for MSDE 2000 Release A
If no application on another computer will connect to your instance of MSDE 2000, the instance does not need network support, and it is prudent to turn off these unused resources. By default, Desktop Engine Setup.exe does not enable network support when installing new instances of MSDE 2000 Release A. You can use the DISABLENETWORKPROTOCOLS=0 parameter to enable network support during installation. Or, if you disable network support when installing an instance of MSDE 2000 Release A, you can later reconfigure the instance to enable network support. For more information about disabling and restoring network access, see Microsoft Knowledge Base article 814130.
By default, Desktop Engine Setup.exe will not install a new instance of MSDE 2000 unless you use the SAPWD parameter to specify a strong sa password. You should always assign a strong password to the sa login unless the application using your instance of MSDE depends in some way on a null sa password. Even if the instance of MSDE 2000 is using Windows Authentication, the sa login becomes immediately active if the instance is ever switched to Mixed Mode. A null, blank, simple, or well-known sa password could be used for unauthorized access. If you need to assign a strong sa password before upgrading your instance of MSDE 2000 to SP3a, see Microsoft Knowledge Base article 322336.
For more information about strong passwords, see "Security Rules" in SQL Server 2000 Books Online.
Whenever possible, for greater security, use Windows Authentication with your MSDE 2000 installation. Consider switching from Mixed Mode to Windows Authentication Mode if the following are true:
The applications using MSDE 2000 can run using Windows Authentication.
You have defined Windows Authentication logins for all users who need to connect to the instance. For more information about adding logins, see "Adding a Windows User or Group" in SQL Server 2000 Books Online.
The instance of MSDE 2000 is not running on Windows 98 or Windows ME.
For more information on changing an instance of MSDE 2000 from Mixed Mode to Windows Authentication Mode, see Microsoft Knowledge Base article 322336.
WHAT???
Archived topic from Iceteks, old topic ID:3761, old post ID:30600