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: How to recover master database
      ... My database master was destroided, ... RESTORE DATABASE must be used in ... I need recover information about the aplicactions users. ... >> How Do I do to recover information from master database ...
      (microsoft.public.sqlserver.server)
    • 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)
    • Re: Looking for best solution
      ... If you have a master database, and want to "merge" changes into it, take a ... > ...currently the master table includes all customer data and the field rep ... would I then still use the replication method of updating the data ... >> Jeff Boyce ...
      (microsoft.public.access.tablesdbdesign)
    • Re: SQL 6.5 - 2000 Problems
      ... Do you get the error "The following logins are missing from master"? ... order to isolate this issue, can you please help collect some information? ... I have tried using the upgrade wizard but I keep getting errors ... > saying that user is not in the master database and the upgrade my fail (I ...
      (microsoft.public.sqlserver.setup)