Microsoft SQL Server Access
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 7, 2006 8:25 AM
UPDATED:
March 8, 2006 5:11 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
