Microsoft KB Archive/250325

= ACC2000: Error Message: Windows NT User or Group 'Domain\User Name' Not Found =

Article ID: 250325

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q250325



Advanced: Requires expert coding, interoperability, and multiuser skills.

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



SYMPTOMS
In a Microsoft Access project, when you try to add a user or a group that has a valid domain account on the Server Logins tab of the SQL Server Security dialog box, you may receive the following error message:

Microsoft SQL-DMO (ODBC State: 42000)

Error 15401: Windows NT user or group 'domain\user name' not found. Check the name again.

NOTE: This issue may also occur with Access projects managed with Access Workflow designer. In Access Workflow designer, you can invoke the same SQL Server Security dialog box, by clicking Database Security on the Tools menu.



CAUSE
The SQL server has been installed as case sensitive, and you used one or more lowercase letters when you typed the domain name.



RESOLUTION
Type the domain name with uppercase letters, or select the proper domain name from the combo box.



Steps to Reproduce the Behavior
 On a clean computer (a computer that has a newly installed version of Microsoft Windows 95, Microsoft Windows 98, or Windows NT 4.0 SP3, and no other applications), run the Setup program of either Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0.NOTE: If you are running SQL Server 7.0, in order to see the dialog box for the next step, make sure to select Custom Setup. In the Character Set/Sort Order/Unicode Collation dialog box, make sure that the Case-insensitive option is not selected (is not checked). Complete Setup with all other defaults. On the same computer, install Access 2000. Make sure MSDE or SQL Server is running.</li> Start Access. In the Microsoft Access dialog box list, select Northwind SQL Project File, and then click OK. The Access project opens.</li> In the Install Database dialog box, click Yes. Access installs the SQL Server database NorthwindCS to your server.</li> After the database is created, click OK in the Installation Successful dialog box, and then click OK on the startup screen.</li> On the Tools menu, point to Security, and then click Database Security. The SQL Server Security dialog box opens.</li> On the Server Logins tab, click Add.</li> Type an existing domain and user name. Type the domain name first, and use lowercase letters. For example, if the domain name is ENGINEERING and the user name is TimSmith, type the following:

engineering\TimSmith

</li> Click OK.</li></ol>

Note that you receive the error message mentioned in the "Symptoms" section of this article.

<div class="references_section">