Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Locked out of database
Message
De
24/07/2012 08:41:08
 
 
À
24/07/2012 08:23:39
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01549072
Message ID:
01549076
Vues:
48
>Hi,
>
>I have a client who has SQL Server express 2008 R2 installed. We created a database on it and our software runs against this database fine. I need to do some maintenance to it now but cannot get access to the database. The Object Explorer connects fine, but I get messages like:
>
>"The database is not accessible. (ObjectExplorer)"
>
>They don't know the sa password.
>
>One thing I've noticed is that they apparently have SQL Server 2012 installed (which wasn't there last time).
>
>Any ideas what I can do?

You application runs fine, isn't it?
If so, just use the same account you use in your application when you connect with SSMS.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform