Removed BUILTIN/Administrators from sysadmins - reinstall?

From: Magnus (magnus_laser_inte@hotmail.com)
Date: 07/17/02


From: "Magnus" <magnus_laser_inte@hotmail.com>
Date: Wed, 17 Jul 2002 13:45:44 +0200


Hi!

As one of the last steps in applying hotfixes and such on
a small IIS and SQL server as suggested by MS baseline
security analyzer late one night I removed (without thinking)
BUILTIN/administrators from the System Administrators
group in the server roles in the MS SQL 2k. The only
other account in that group, sa, has a 15+ char randomly
chosen password.

I guess the only thing is to backup the database and reinstall?

Thanks. Magnus, Sweden



Relevant Pages

  • Re: New to Merge/Replication
    ... ADO.NET 3.0 includes "Synchronization Services" that does not require IIS. ... Hitchhiker's Guide to Visual Studio and SQL Server ... It was my deepest hope that Merge/Replication between SQL Compact Edition and SQL Server 2005 Enterprise Edition would have it's own sync services NOT dependent on IIS. ... You can use merge replication with SQL Server on your main desktop serving as the publisher with SQL Compact on PPC, TabletPC, or other desktops as subscribers, so that would probably be the easiest solution for you. ...
    (microsoft.public.sqlserver.ce)
  • Re: Help on synch to SQL server
    ... from SQL CE to SQL Server from your smart-device application's code. ... This can occur whenever the device has a network path to IIS, ... Unlike merge replication between SQL Servers where you can use RMO ... Ideally I would like to use Sql CE to synch with a SQL ...
    (microsoft.public.sqlserver.ce)
  • Re: SMS_MP_CONTROL_MANAGER error 4960
    ... When I try to restart the IIS it says nothing.... ... Manually restart the SMS Agent Host service on the MP. ... MP encountered an error when connecting to SQL Server. ... The Default Web Site is disabled in IIS. ...
    (microsoft.public.sms.setup)
  • RE: IUsr can not login
    ... I too am not sure what the IIS lockdown tool does (I am a SQL Server ... that had been assigned permission to login into SQL ... Amongst the NT account names will be the account/group that IIS ...
    (microsoft.public.sqlserver.security)
  • Re: Internet Information Services in MCE
    ... Per user Group Policy Restrictions for XP Home and XP Pro ... However, I am able to run SQL Server Dev Edition on my work laptop, which is ... I've installed the IIS component but I'm not sure I have a good ... I'm trying to install SQL Server 2005, ...
    (microsoft.public.windows.mediacenter)