Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    33

    Unanswered: Problem access db from VB.NET after restoration

    Hi,

    I am working on a .NET application (VB.NET). We had to restore our SQL server database from yesterday's backup as we accidentally overwrote some tables. After restorign, we are able to log to the database alright from SQL Query analyzer and Enterprise manager but when we try to access it from the .NET application, it gives an error message "Cannot open database requested in login '****' login fails.
    Login failed for user '****'". What could be the reason and what would be the solution?

    Thanks in advance

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    have you changed the userid or password for the VB.NET files from the ones in your restored db.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Check to see what the default database of the user is. Also, make sure the user still has rights in the database he is trying to access.

Posting Permissions

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