A1VBCode Forums

SQL Express Account


http://www.a1vbcode.com/vbforums/Topic27311.aspx

By shers - 3/26/2009

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?

By MaslowB - 6/11/2009

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.