• Tam's Crazy Blog About Technology and More…

Databases Msde
by Tam

During my last development, I had a little bit of 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 to come in handy. For First you need to download a free version of this very MSSQL server, you can do with my site. or type in a search engine query: 'Download MSDE 2000', 'download MSDE', etc. The installation of a free server, you must perform parameters. Run the setup. Exe c parameters shown below.

Here are the options available, but personally, I run with only one sapwd = 'mssql'. Options sapwd = 'mssql', securitymode = SQL, DISABLENETWORKPROTOCOLS = 0 With these settings, you set the login and password for the SQL system Administrator mssql. Installing the server is almost blind. After installing the server you need to restart the system. After a successful installation in the system tray near the clock should appear running SQL Server. If the server does not start automatically, you can start it manually by right-clicking the icon for the server. Now that the server is installed we can create the database, but it's extremely uncomfortable without using a visual manager, and there is no such a free version of MSDE. Personally, I use free download manager 'DbMgr2k'.

If it does not suit you, you can find another. After installing the manager you will have the opportunity to create databases and manage them using the visual editor. Limitations of MSDE 2000, 1. The first and most noticeable limitation, in my opinion, is the number of simultaneous connections to the database, no more than two * 2. Second, it limit on the size of your database. Base size should not exceed 2 GB. ** * – If you want to install MSDE 2005, then there is no limit to the number of simultaneous connections ** – The size of the database in MSDE 2005 is 4 GB.

Tags: ,


November 21st


© 1998-2017 Page Crazy All Rights Reserved