Changing the Default Login for SQL Server

From: R Bolling (robboll@hotmail.com)
Date: 04/13/03

  • Next message: Sean: "Win2k Server Administrator Password Recovery" 
    From: robboll@hotmail.com (R Bolling)
Date: 13 Apr 2003 07:28:41 -0700

    Hello -- I am trying to change the login mode to SQL Server Logins and
    followed the article per:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285097

    The problem is that the option "Edit SQL Server Registration
    Propertied..." is not available regardless of what value I set the
    loginmode value to.

    Anybody got a clue as to what what might be going on?

    Thanks,

    Robbie Bollinger

  • Next message: Sean: "Win2k Server Administrator Password Recovery"

    Relevant Pages

    • End User Security Administrator for a Intranet Application
      ... This will involve creating sql server logins and ... administrator needs the SQL server fixed server ... I really don't want to give end users the sysadmin fixed ...
      (microsoft.public.sqlserver.security)
    • Re: access deny the sa account
      ... > authority, is it possible to disable the account sa to access the ... not with SQL Server logins. ... Andrea Montanari (Microsoft MVP - SQL Server) ...
      (microsoft.public.sqlserver.msde)
    • Re: Cross VPN Domain Authentication
      ... around having to maintain those SQL Server logins and the user ambiguity ... SQL Server DBA ... Children's Oncology Group ...
      (microsoft.public.sqlserver.security)
    • Re: sql2005 enforce user change password in 30 days
      ... I'm guessing that you mean SQL Server logins. ... Windows-based logins are ... DomainSecurityPolicies). ...
      (microsoft.public.sqlserver.security)
    • Re: Distributor SQLSERVERAgent Account
      ... accounts and SQL Server logins. ... a domain user account if you are to replicate from one ... >running SQL Server Agent as LocalSystem and sa? ...
      (microsoft.public.sqlserver.replication)