"Configuring SQL Server 2000 Desktop Engine" white paper is available in Download Center (301413)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q301413
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SUMMARY

The Configuring SQL Server 2000 Desktop Engine white paper (AccSQL02.doc) provides an overview of how to use Microsoft Access 2002 with Microsoft SQL Server 2000 Desktop Engine (SQL Server Desktop Engine). Topics that are covered in this white paper include SQL Server Desktop Engine installation options, resolving connectivity problems, and SQL Server security issues with Access 2002.

The following file is available for download from the Microsoft Download Center:

AccSQL02.exe

The AccSQL02.exe file contains the following file: 
   AccSQL02.doc  A Microsoft Word document
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

MORE INFORMATION

The Configuring SQL Server 2000 Desktop Engine white paper contains the following topics:
  • OVERVIEW OF SQL SERVER 2000 DESKTOP ENGINE
  • SQL SERVER DESKTOP ENGINE INSTALLATION
    • Installation Options
    • Installation Folders
    • Instance Name
    • Upgrading from MSDE 1.0 or SQL Server 7.0
    • SQL Server Logon
    • Creating an Installation Log File
    • Reinstalling SQL Server Desktop Engine
  • RESOLVING CONNECTIVITY PROBLEMS
    • Connecting via TCP/IP to a SQL Server Named Instance
      • Server Configuration for TCP/IP
      • Modify Access ADP Connection Information for TCP/IP
    • Connecting via Named Pipes to a SQL Server Named Instance
      • Named Instance with Windows NT
      • Modify Access ADP Connection Information for Named Pipes Connection
    • Problems with MDAC 2.5 Users Connecting to SQL Server Desktop Engine
  • ACCESS 2002 AND SQL SERVER DESKTOP ENGINE SECURITY
    • Changes to Security Dialog Boxes
    • Granting Permissions to the Database
    • Enabling the System Administrator (sa) logon
    • Integrated Security
    • Enterprise Manager
    • Microsoft Office XP Developer
    • SQL Server Stored Procedures
      • Assigning permissions to a new user
      • Assigning permissions to multiple users
  • MONITORING CONNECTIONS
    • Concurrency Violations
  • CONCLUSION
  • FOR MORE INFORMATION
Modification Type:MinorLast Reviewed:8/25/2004
Keywords:kbConfig kbsetup kbdownload kbfile kbGraphxLink KB301413
©2004 Microsoft Corporation. All rights reserved.