Sign in
 
HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums
Windows Server TechCenter >
> 
> 
How to repair SQL Server after a dcpromo?

תשובה How to repair SQL Server after a dcpromo?

  • Monday, December 10, 2012 9:31 PM
     
     
    Sign In to Vote
    0

    Hello.  I have the misfortune of trying to repair a SQL Server 2005 instance after the server was dcpromo'ed.  I know very little about SQL server.  I can access the database with SQL Server Management Studio Express using Windows Auth (I don't know the sa password).  I can add users, change permissions, etc. but only one person can connect and use it.  Everyone else gets the "The SELECT permission was denied on the object ‘season’, database ‘DBNAME", schema "dbo" error.

    Using Visual Studio 2008, I can successfully test connection to the two accounts I created for myself, Windows and SQL Auth.

    Is it possible to repair the database at this stage, and if so, how?  I'm sure some of you will ask for more info, and I'll try to do my best to answer.

    Thanks in advance!

     

All Replies