ACC2002: Unable to Transfer a SQL Server Database That Is Connected to an Access Project (287415)


The information in this article applies to:

  • Microsoft Access 2002, when used with:
    • Microsoft Windows 98
    • Microsoft Windows 98 Second Edition
This article was previously published under Q287415
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

When you try to transfer a Microsoft SQL Server 2000 database that is connected to a Microsoft Access project (ADP), you receive the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group '<Domain>\<Login>' not found. Check the name again.

CAUSE

The remote server is configured to use Windows Authentication.

RESOLUTION

The remote server must be configured to use Mixed Mode Authentication.

For additional information about configuring the Microsoft SQL Server 2000 Desktop Engine, click the article number below to view the article in the Microsoft Knowledge Base:

301413 ACC2002: "Configuring SQL Server 2000 Desktop Engine" White Paper Available in Download Center

For more information about configuring Microsoft SQL Server 2000, refer to Microsoft SQL Server 2000 Books Online, which is available at the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/portal_7ap1.htm

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Create a new Access project that is connected to a remote SQL Server that is configured to use Windows Authentication.
  2. On the Tools menu, point to Database Utilities, and then click Transfer Database.
  3. In the Transfer Database dialog box, specify a local server, and then click Next.
  4. Click Finish.
Note that approximately halfway through the transfer, you receive the error message that is mentioned in the "Symptoms" section of this article.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbprb KB287415
©2004 Microsoft Corporation. All rights reserved.