RE: can not access sql server after changing the access right for sa to "denied"

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 12/26/03

  • Next message: Kevin McDonnell [MSFT]: "RE: ReInstall Sql Server" 
    Date: Fri, 26 Dec 2003 19:27:01 GMT

    There are a couple of possible solutions.

    1. Restore master from a backup prior to making this change.
    2. Rebuild master. Recreates the master database & sets back the defaults
    3. Attempt to register the server as NT Administrator using Windows
    Authentication.

    Thanks,

    Kevin McDonnell
    Microsoft Corporation

    This posting is provided AS IS with no warranties, and confers no rights.

  • Next message: Kevin McDonnell [MSFT]: "RE: ReInstall Sql Server"

    Relevant Pages

    • Re: Access denied after OS Disk upgrade!?
      ... Look up the rebuild master utility in Books Online....it will trash anything ... Not sure if this is what you need, but since SQL Server isn't working at ... >> master database are damaged, you may see error messages similar to the ...
      (microsoft.public.sqlserver.connect)
    • Re: unable to start SQL Service ... error code 3417
      ... If the Master database is corrupt, how would you advise I maybe replace with ... "SQL Server cannot start the master database. ... MVP - Windows Live Platform ...
      (microsoft.public.sqlserver.server)
    • RE: master DB users
      ... (No user other than DBA should be allowed to access the master database). ... explicitly to database users in master, except those that SQL Server ... Those that are not in the sys schema ...
      (microsoft.public.sqlserver.security)
    • RE: master DB users
      ... In my company I have a standard that Restric Access to Master Database ... the reason for lising the all master db user with their permission. ...
      (microsoft.public.sqlserver.security)
    • Re: Cannot recover the master database.
      ... To fix a corrupted master database run rebuildm.exe. ... msdb and modle databases and replace them with blank ones. ... You do have a backup of your system databases, ...
      (microsoft.public.sqlserver.server)