Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locked out of database
Message
 
To
24/07/2012 08:23:39
General information
Forum:
Microsoft SQL Server
Category:
Security
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01549072
Message ID:
01549076
Views:
47
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform