Install and configure SQL Server 2000 Desktop Engine

Although Microsoft SQL Server 2000 Desktop Engine is not part of a standard Microsoft Office 2003 installation, you can install SQL Server 2000 Desktop Engine from the Office 2003 CD-ROM. This applies to computers running Windows 2000 or later.

ShowInstall SQL Server 2000 Desktop Engine

  1. If you have Microsoft Data Engine (MSDE) installed, uninstall it first before installing the SQL Server 2000 Desktop Engine.
  2. Run the MSDE2KS3.EXE self-extracting program in the \MSDE2000 folder on the Office 2003 CD-ROM, or on the network location at your local site if Office 2003 was installed as a network installation.

By default, the files will be extracted to the C:\sql2ksp3 folder. You can specify another location, but the following instructions are based on this default location.

  1. After the self-extraction is complete, go to the C:\sql2ksp3\msde folder.
  2. Do one of the following:
    • If you are installing SQL Server 2000 Desktop Engine for the first time, you need to use a command-line switch with setup.exe. Click Run on the Start menu, type CMD and press ENTER to bring up the DOS command window. Type the following commands:
CD \sql2ksp3\msde
setup.exe SAPWD="AStrongSAPwd"
  • If you are upgrading an existing instance of SQL Server 2000 Desktop Engine that was included with Microsoft Office XP or Microsoft Access 2002, you need to use command-line switches with setup.exe. Click Run on the Start menu, type CMD and press ENTER to bring up the DOS command window. Type the following commands:
CD \sql2ksp3\msde
setup.exe /upgradesp setup\sqlrun01.msi SAPWD="AStrongSAPwd"

Replace "AStrongSAPwd" with your own strong password for the system administrator (SA) login account.

  1. Restart the operating system to complete the installation.
  2. When the installation or upgrade is complete, you can delete the files in the C:\sql2ksp3 folder.

 Note    For additional information about installing SQL Server 2000 Desktop Engine, refer to the SP3ReadMe.htm in the \sql2ksp3\msde folder.

ShowAbout enabling the system administrator (SA) user name in an Access project

When the Microsoft SQL Sever 2000 Desktop Engine (formerly called the Microsoft Database Engine or MSDE) is installed on Microsoft Windows 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 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. 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 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 platform.
  • The SQL Server must be running on the same computer as the Access project.
  • The current Windows 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).

ShowStart 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.

  1. Double-click the MSSQLServer icon in the icon tray of your windows task bar.

The SQL Server Service Manager window is displayed.

  1. Click Start/Continue.
  2. 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.

ShowCustomizing 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.
SAPWD A new password to replace the default password for the system administrator (SA) login account.

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
 
 
Applies to:
Access 2003