Microsoft KB Archive/301413

= &quot;Configuring SQL Server 2000 Desktop Engine&quot; white paper is available in Download Center =

Article ID: 301413

Article Last Modified on 8/25/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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

Additional query words: inf

Keywords: kbdownload kbgraphxlink kbfile kbsetup kbconfig KB301413

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.