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

Article translations Article translations
Article ID: 199395 - View products that this article applies to.
This article was previously published under Q199395
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

Expand all | Collapse all

On This Page

SUMMARY

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.

MORE INFORMATION

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

Properties

Article ID: 199395 - Last Review: October 11, 2013 - Revision: 2.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhowto KB199395

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com