-
March 26th, 2009, 06:08 AM
#1
SQL Express Account
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?
-
April 10th, 2009, 03:01 PM
#2
Re: SQL Express Account
The user I would authenticate with would be 'sa' which is the default for the SQL Administrator. There some issues with SQL Express in DB authentication. You may want to also try SQL CE (Compact Edition) or go to the full fledged version where Windows Server authentication is supported.
Hope this helps,
Larry Darrah
MS AE
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|