The best magazine
- 1). Click on the "Start" button from the desktop and then move your mouse over the "Programs" option. Click on the "Administrative Tools" option and then click on the "Internet Services Manager" option.
- 2). Locate your SQL server from the left navigation pane and then right click on the application for your server. Click on the "Properties" option.
- 3). Click on the "Direct Security" tab and then click on the "Edit" option. The Authentication Method dialog box will then appear on your screen.
- 4). Click on the box next to the "Anonymous Access" field so that it's deselected. Click on the box next to the "Integrated Windows" field so that it's selected and then click on the "OK" button. Close out of all of the dialog boxes.
- 5). Click on the "Start" button from the desktop on your computer and then move your mouse over the "All Programs" option.
- 6). Click on the "Microsoft SQL Server" option and then click on the "Enterprise Manager" option. The Enterprise Manager dialog box will then appear on your screen.
- 7). Click on your server name from the left navigation pane and then select the database on the server that you want to configure Windows security for.
- 8). Right click on the "Users" option and then click on the "New Database User" option. The Database User Properties dialog box will then appear.
- 9). Enter the domain or user name into the "Login" field and then click on the "OK" button. The users will then have access.
Source: ...