All right, we are good to go with continuing to create some users on the SQL server. First off, let's take a quick look at the existing users and see how many of the users are sqllogons and which ones ...

To enable access to your SQL Server for those 1000 Windows users requires a single Windows login based on the Accounting group. ... just create a Windows login for Eddie and specify Deny access.

Ok, for SQL server 2000, ... Yeah, it works but it isn't secure.<BR><BR>Create a local user on that box, call it SQLserviceaccount or SQLadmin or whatever seems appropriate to you.