Hi,

I'm using SQL 2008 Express with a multi user VB.NET Windows application.

Do I have to add each user to the SQL user account? Does NT Authority\SYSTEM work? I do not know how this works. So far I have NT Authority\SYSTEM in the Security-Logins of the Server. But do I have to add it also in the database? In the databse Security-User, I have the following:

dbo
guest
INFORMATION_SCHEMA
sys

I tested the app in one of the users and it gives me error as follows:

Cannot open database "Print" requested by the login. The login failed.
Login failed for user domain\username.

What could be the reason?

Somebody correct me if I'm wrong, but I believe that you need to add WorkGroup users if in a workgroup environment or Domain Users if in a domain envirionment and make sure the user is in the particular group.  Once added for the SQL instance, go to the properties of the user account and select user mappings and you should be able to specifiy what databases the account has access.  Adding each individual user will work also.  But you'll still need to set the user mapping.

for applications where many people will be using them, we use a regular sql login, instead of a windows authenticated one.



we make up a username/password for the application and manage what the application can do to what tables at that point.



then for the items in the application that need tighter security we add a table that the application reads to turn on or off other permissions.

Vb.net 2005, Teradata, Sql Server 2005, mainframe automation