Once you bring up the utility and select the MSDE tab you should see something like this: In order to use this functionality you need to run the utility under and administrative account - the utility connects to MSDE or SQL Server via Windows Authentication. It also allows you to reset passwords for any Sql Server account. It allows you to set the Authentication type (Windows Security or Mixed mode Sql Server & Windows Security). Once installation completes it does not automatically start the server, so you can do this either via the Services applet in Administrative Tools or by using the command line:Ĭhanging settings after MSDE is already installedThe Web Store Configuration Utility (which is accessible from the Program Menu Group) has an MSDE tab page that allows you configure MSDE security directly.
Note that setting security mode to SQL actually supports both SQL and Windows Auth. SETUP SECURITYMODE=SQL SAPWD= yourpasswordĪlternately you can add the following into setup.ini before running the setup: Windows auth is usually not appropriate for Web applications, so you have to override a few installation settings by manually running the setup program with a couple of flags: By default MSDE installs with only Windows Security allowed.
Start by installing correctly!Even if you are planning on using DbaMgr2k make sure that you install MSDE properly. The rest of this topic describes how to manually configure MSDE. Hence it generally is the developers responsibility to configure MSDE manually. MSDE configuration is a non trivial task unfortunately because Microsoft does not ship any tools to administer the server and because installation occurs essentially unattended without giving you installation options or prompts.
0 kommentar(er)
