Re: Registry

From: CurtM (cndmoyer_at_hotmail.com)
Date: 05/14/03


Date: Wed, 14 May 2003 13:46:36 -0700


Sorry to be unclear. What I've noticed of course is that
since I'm local admin on the production servers, I can
open query analyzer using just my Windows login even
though I'm not mapped into the logins on the sql server.
I get in simply because I'm local admin.

So I've been assuming that someone who's a "network admin"
(or more importantly a hacker who has obtained a high-
level password somehow) can also pop right into sql server
as well. This is what I want to prevent. The first
things a hacker/cracker type will go for is high-level
password and, gasp, if this should ever happen I don't
want them to be able to just jump right into our sql
servers which is where our most sensitive data is.

You said that I could just exclude them? How? By limiting
the domain admin sql server login? Hope that makes sense.
What about the builtin\administrators login?
 
>-----Original Message-----
>Don't grant them access. There's no need for them to
>be able to access SQL. I'm not sure what you're asking ?
>
>--
>HTH
>
>Jasper Smith (SQL Server MVP)
>
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"CurtM" <cndmoyer@hotmail.com> wrote in message
>news:025201c31a39$14898240$a101280a@phx.gbl...
>> I'm confused as to what Windows Only mode will buy you
>> assuming that you don't use Mixed Mode logins for you
day-
>> to-day activities on the server (so that no passwords
are
>> floating around the network). Also, I guess what I'm
>> asking is: how can I keep someone out of sql server if
>> they're a local admin or network admin?
>>
>> >-----Original Message-----
>> >He must have permissions on the registry as well. Have
a
>> complicated
>> >password, swithch to Windows Only mode, and take care
>> about permissions on
>> >the OS level as well.
>> >
>> >--
>> >Dejan Sarka, SQL Server MVP
>> >FAQ from Neil & others at: http://www.sqlserverfaq.com
>> >Please reply only to the newsgroups.
>> >PASS - the definitive, global community
>> >for SQL Server professionals - http://www.sqlpass.org
>> >
>> >"CurtM" <cndmoyer@hotmail.com> wrote in message
>> >news:092e01c31976$556a48d0$a001280a@phx.gbl...
>> >> Isn't this true? If a hacker gains access to the
>> >> administrative password, you're hosed. They can
switch
>> >> the registry key to mixed mode and jump right in to
sql
>> >> server? Is there any way to protect yourself against
>> this?
>> >
>> >
>> >.
>> >
>
>
>.
>



Relevant Pages

  • Re: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • Re: error logging on SQL 2008
    ... I was, though, hoping for some more recognizable Reason for that error (state 11, " Token-based server access validation failed with an infrastructure error. ... Suggests that state 11 means "Valid login but server access failure", which doesn't really seem to rhyme with your description. ... How can you login to your SQL Server and use that tool if you can't log into your SQL Server? ... at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server role or right click on it and choose properties from the popup menu, ... Login is a member of the "sysadmin" fixed server role now. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server ... Mark the "sysadmin" checkbox to make this Login a member of this Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > file while you do changes, so the script file in the end contains the ... >> Server, doesn't have the right to grant DB access to Domain Groups. ... > Tibor Karaszi, SQL Server MVP ... >> site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)