CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    265

    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?

  2. #2
    Join Date
    Oct 2008
    Posts
    47

    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
  •  





Click Here to Expand Forum to Full Width

Featured