ACC2000: Determining If You Are Running MSDE or SQL Server 7.0

To see whether you are running Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0, you can check the Sqlstp.log file located in your Windows or Winnt folder.

The setup log file, Sqlstp.log, is created during setup and contains detailed information about your Microsoft Data Engine or Microsoft SQL Server 7.0 configuration. To open this file, follow these steps:

1. Start Notepad.
2. On the File menu, click Open.
3. In the Open dialog box, browse to your Windows or Winnt folder.
4. In the Files of type box, select All Files (*.*.)
5. In the File name box, type Sqlstp.log.
6. Click Open.

If the Sqlstp.log file is very large, you may need to open it in WordPad or another text editor.

In the first several lines, the entry "SQL Server ProductType:" tells you what version you are running. The Microsoft Data Engine will say "Office," whereas Microsoft SQL Server 7.0 will say "Standard" for this entry.

Example Entries for Microsoft Data Engine

16:20:05 Begin Setup
16:20:05 7.00.549
16:20:05 Mode=Normal
16:20:06 System: Windows 98
16:20:06 Mapping: 0x1
16:20:06 SQL Server ProductType: Office
16:20:07 Begin Action: CheckRequirements

Example Entries for Microsoft SQL Server 7.0

09:35:26 Begin Setup
09:35:26 7.00.517
09:35:26 Mode=Normal
09:35:27 Begin Action: CheckRequirements
09:35:27 System: Windows NT Server
09:35:27 Version: 4.0.1381
09:35:29 SQL Server ProductType: Standard