During my recent developments, I have some information about working with the free base of the MSSQL Server 2000 MSDE. This information, I would like to share with you, it can not remain without attention and someone useful. To start you need to download this very free version of MSSQL server, you can do with my site http://newlinestudio.ru. Or dial in search query: "Download MSDE 2000", "download MSDE" etc. Free Ustanovku the server must comply with the parameters. Run setup. Exe c parameters presented below. Next presents possible options, but personally I run with only one sapwd = "mssql".
Options
sapwd = "mssql",
securitymode = SQL,
DISABLENETWORKPROTOCOLS = 0
With these parameters you use SQL authentication and password for the system administrator mssql. Server installation occurs almost blind. After installing the server you need to restart the system. After a successful installation in the system tray near the clock should have an icon running SQL Server. If the server does not start automatically, you can start it manually by right-clicking the icon server. Now that the server is installed, we can create the database, but it is very uncomfortable without the use of visual manager, but this is not a free version of MSDE. Personally, I use a free manager "DbaMgr2k". If you do not come you can find another. After installing the manager you'll be able to create databases and manage them using the visual editor. Restrictions on the use MSDE 2000
1. The first limitation and the most noticeable, in my opinion, this is the number of simultaneous connections to the database, no more than two *
2. Second, this limitation on the size of your database. The size of the base should not exceed 2 GB. **
* - If you want to MSDE 2005, it has no restrictions on the number of simultaneous connections
** - The size of the database in MSDE 2005 is 4 GB.