That would work beautifully and save you a LOT of work - especially if all of these users need exactly the same level of rights. Worst case, you'd need a...

You need to check your connection string. Your application (asp page) is trying to access the sql server with Null as the login - "Login failed for user '(null)'". Your...

I may be mis-reading your question, so forgive me if I am. Are you asking how to script an ODBC DSN connection? A co-worker of mine was able to do...

To make a user:

in Mgmt Studio, expand Security and right-click on Logins.

Select 'new login'

Enter a login name

Select 'SQL Server authentication' and enter the password twice

Move to the 'User Mapping' page...

Try leaving the login name blank (on the add new user screen) and clicking on search. Set the location to your network location where login names are validated, then add...