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:
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.
MORE INFORMATION
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.
- Start Access. In the Microsoft Access dialog box list, select Northwind SQL Project File, and then click OK. The Access project opens.
- In the Install Database dialog box, click Yes. Access installs the SQL Server database NorthwindCS to your server.
- After the database is created, click OK in the Installation Successful dialog box, and then click OK on the startup screen.
- On the Tools menu, point to Security, and then click Database Security. The SQL Server Security dialog box opens.
- On the Server Logins tab, click Add.
- 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
- Click OK.
Note that you receive the error message mentioned in the "Symptoms" section of this article.
REFERENCES
For additional information on another issue involving case-sensitivity settings in Microsoft SQL Server, click the article number below to view the article in the Microsoft Knowledge Base:
223202 ACC2000: Unexpected Behavior with Case-Sensitive Objects
Additional query words: prb AWD
Keywords: kberrmsg kbprb kbworkflowdesigner KB250325
