problem restoring and killing access to my database

Discussion in 'Databases' started by patrick2, Oct 19, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. patrick2

    patrick2

    A couple of nights ago a did a database restore to my sql2005 database. It restored OK, but was inaccessible until support reset some permissions. It has happened again tonight. I did a restore. Then I try to connect via my application or sql management studio. I cannot do it. I have reopened the ticket with support.

    Any ideas as to what could be causing this?

    ---
    Patrick
    http://www.dealwithme.com
     
    patrick2, Oct 19, 2006
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    Patrick,

    In order to avoid the issue that you are having, you will need to use another user for your SQL Login in your local (development) database, you can not use the same DASP SQL log in


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Oct 19, 2006
    #2
  3. sharnish

    sharnish

    It would be a good idea for DASP to be more specific about this in KB article 10413. I had the same problem.Igot the falseimpression I needed to create a login name in my development database identical to my DASP login name forthe database. I did so and uploaded/attached the database. Then I got locked out.
     
    sharnish, Dec 7, 2006
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    this is something we will look into fixing in the future release.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Dec 9, 2006
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page