Install SQL Server 2000 Desktop EngineAlthough Microsoft SQL Server 2000 Desktop Engine is not part of a standard Microsoft Office XP installation, you can install SQL Server 2000 Desktop Engine from the Office XP CD-ROM. This applies to computers running Windows 2000 or Windows 98 and later.
Install SQL Server 2000 Desktop Engine
If you have Microsoft Data Engine ( MSDE) installed, uninstall it first before installing the SQL Server 2000 Desktop Engine.
In Windows Explorer, open the \MSDE2000 folder on the Office XP CD-ROM, or on the network location at your local site if Office XP was installed as a network installation.
Note Be sure to read the Readme.txt file in the \MSDE2000 folder for late-breaking information.
Double click setup.exe.
Restart the operating system to complete the installation.
Caution Microsoft strongly recommends you change your password if you use the System Administrator (SA) password to log on, especially on a Windows 98 operating system.
About enabling the System Administrator (SA) user name in an Access project
Note The hyperlink in this topic goes to the Web. You can switch back to Help at any time.
When the Microsoft SQL Sever 2000 Desktop Engine (formerly called the Microsoft Database Engine or MSDE) is installed on Microsoft Windows NT computers, it is installed with Windows NT Authentication implemented (this feature is also known as integrated security). When a user connects to the SQL Server database through a Microsoft Access project, the connection is enabled through a Windows NT user account. SQL Server verifies that the account name and password were validated when the user logged on to the system and grants access to the database, without requiring a separate logon name or password.
With the default installation of the Microsoft SQL Server 2000 Desktop Engine with integrated security, the user must be a member of the administrator group for the machine on which the Access project resides. This makes it difficult to allow other users to gain access to the Access project.
There is currently no simple way for the system administrator to create new logon accounts to the locally installed SQL Server database except by using SQL Tools or Transact-SQL (TSQL) commands. See the Microsoft Developer Network Web site for more information on TSQL.
You can change the security mode for accessing the SQL Server database on a computer running Windows NT. By setting properties from the View menu, you can enable mixed mode security. Mixed mode security allows access to the database from either a Windows NT account or through a SQL Server account by using the default system administrator (SA) account with no password.
Using the default SA account, users can access the SQL Server database through the Access project without any additional security requirements. The administrator of the SQL Server can also add additional security by changing the default SA account password.
In order for the Enable system administrator (SA) user name check box to be enabled, the following must be true.
- The Access project must be connected to a SQL Server 7.0 (or later) database or a Microsoft SQL Server 2000 Desktop Engine.
- The SQL Server database must be running on a Windows NT platform.
- The SQL Server must be running on the same computer as the Access project.
- The current Windows NT user must be an Administrator for the computer.
- The current SQL Server user must be a member of the System Administrator role.
Note After changing the security mode, it is strongly recommended that the SA password be changed by using the Set Login Password command (on the Tools menu, point to Security).
Start the SQL Server Service Manager
Once you install Microsoft SQL Server 2000 Desktop Engine on your computer, you may need to start the SQL Server Service Manager. SQL Server 2000 Desktop Engine starts automatically on Windows 2000 or later, but you might want to automatically start it on Windows 98 or later.
Double-click the MSSQLServer icon in the icon tray of your windows task bar.
The SQL Server Service Manager window is displayed.
Click Start/Continue.
If you want SQL Server Service Manager to automatically start each time you start Windows, select the Auto-start service when OS starts check box.
Customizing the installation
You can do a custom installation of SQL Server 2000 Desktop Engine by using the following configuration options either in the Microsoft Windows setup.ini file, or as command line switches when you run setup.exe.
Note All configuration options must be in upper-case.
| Setting | Description |
|---|---|
| TARGETDIR | The name of the folder to install SQL Server 2000 Desktop Engine. The default value is C:\Program Files\Microsoft SQL Server\. |
| DATADIR | The name of an optional folder for data files. The default value is the value of TARGETDIR. |
| COLLATION | The name of a collation sequence. |
| INSTANCENAME | The name of the SQL Server. The Default value is MSSQLSERVER. |
The following is an example of a custom installation using command line switches.
Setup.exe \\MySWdisk\SQLSW\ TARGETDIR="C:\Program Files\SQL8\" DATADIR="C:\Program Files\SQLDATA\" COLLATION="SQL_Latin1_General_CP1257_CS_AS" INSTANCENAME=myinstance