Microsoft SQL Server Access

pts.
Tags:
Access
Desktops
Management
Microsoft Windows
OS
Security
Servers
SQL Server
We are running Sharepoint with Microsoft SQL Server on a Windows 2k3 Server. At some point the raid controller failed. After being replaced we found the database was marked "suspect" and will not open. There seem to be three parts to the database: dbname_PROF, dbname_SITE, and dbname_SERV. The logs indicate that only the bdname_SERV is marked "suspect". I have found information on how to reset the suspect status, however, we do not have access to the 'sa' account. The database developer has moved on to another company (and even though was contacted, cannot remeber the account info). Is there a way to access the database - maybe an account recovery mech. or default account - which will allow us to reset the _SERV portion and open the database?

Answer Wiki

Thanks. We'll let you know when a new response is added.

By default SQL Server includes BUILTINAdministrators as a group which is a member of the sysadmin fixed server roles. This is BUILTINAdministrators group is essentially the same as the local Administrators group on the server. Therefore all you need to do is log on using with and account that has local admin rights and you should be able to adminsiter SQL Server with EM.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following