Microsoft KB Archive/287415

= ACC2002: Unable to Transfer a SQL Server Database That Is Connected to an Access Project =

Article ID: 287415

Article Last Modified on 1/26/2005

-

APPLIES TO

 Microsoft Access 2002 Standard Edition, when used with:  Microsoft Windows 98 Standard Edition

 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 '\<Login>' not found. Check the name again.

<div class="cause_section">

CAUSE
The remote server is configured to use Windows Authentication.

<div class="resolution_section">

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: &quot;Configuring SQL Server 2000 Desktop Engine&quot; 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

<div class="status_section">

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

<div class="moreinformation_section">

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 &quot;Symptoms&quot; section of this article.

Additional query words: pra

Keywords: kbprb KB287415

-

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

© Microsoft Corporation. All rights reserved.