Trying to connect when Builtin/Administrators account deleted...

From: Zach (anonymous_at_discussions.microsoft.com)
Date: 05/25/04 

Date: Mon, 24 May 2004 21:51:03 -0700

Hi everyone,

I'm new to this newsgroup. I have some questions relating to the following scenario:
- SQL Server is using Windows Authentication
- I delete the Builtin\Administrators from Login section
- subsequently I'm not able to connect to SQL Server

How can I:
- switch the SQL Server to Mixed Mode (in command prompt if possible) and try to connect using sa ?
- add the Builtin\Administrators account again?

Thanks in advance
Zach

Relevant Pages

  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server 2005 login issure 2
    ... My programming knowlege is pretty rusty, but if you installed SQL Server ... if you installed with Windows Authentication and then ... ALTER LOGIN sa ENABLE; ... > If by any change you have read my original post titled "SQL Server 2005 ...
    (microsoft.public.sqlserver.connect)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)