Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    3

    Unanswered: Security issue with ODBC

    Recently converted a MS Access VB app to MS SQL SERVER 2005 Express with VB using ODBC for network connection to the DB. One of the users began receiving the following error "Run-time error '-2147467259 (80004005)' [Microsift][ODBC SQL Server]Cannot open database "dbname" requested by the login. The login failed".

    When creating the SQL Express instance I took the defaults allowing Windows Login to the DB.

    What I do not understand is that the user profile is "Domain User". When the user profile is switched to "Domain Admin" login is successful.


    Anyone have an idea?

    Thanks
    Last edited by sentrynj; 03-04-08 at 22:49.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    you are going to want to go into sql server itself and add the network account as a server login and give that login access to the database.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Oct 2007
    Posts
    3
    Sean, thanks for the reply. When you say "network account" do you mean the user account?

    Thanks,
    Pete

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    yes the yourDomain\yourUser domain user account.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •