Re: sa loginname being hacked

From: Pipo (NoSpam_at_me.com)
Date: 10/17/05

  • Next message: Rob R. Ainscough: "Re: Is there any way to prevent hacker trying to guess sa password?"
    Date: Mon, 17 Oct 2005 15:36:54 +0200
    
    

    I understand. Thanks

    "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
    news:OTwUzjx0FHA.3660@TK2MSFTNGP15.phx.gbl...
    > Non-trusted connections using the standard SQL 'sa' login are not allowed
    > when SQL Server is configured for only Windows authentication. This is
    the
    > most secure authentication method.
    >
    > --
    > Hope this helps.
    >
    > Dan Guzman
    > SQL Server MVP
    >
    > "Pipo" <NoSpam@me.com> wrote in message
    > news:%23UVSk3v0FHA.2752@TK2MSFTNGP12.phx.gbl...
    > > What do you mean by that?
    > > I still have the sa account which is active....so they still can get in
    > > via
    > > the sa account.
    > >
    > > "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
    > > news:%23Zigups0FHA.1040@TK2MSFTNGP14.phx.gbl...
    > >> Have you considered Windows Authentication?
    > >>
    > >> --
    > >> Hope this helps.
    > >>
    > >> Dan Guzman
    > >> SQL Server MVP
    > >>
    > >> "Pipo" <Pipo@home.com> wrote in message
    > >> news:u757cPo0FHA.1564@tk2msftngp13.phx.gbl...
    > >> > Thanks for the answer Helmut, but we cant do the VPN solution you
    > > suggest.
    > >> > Yes, it is encrypted, they dont have the password yet!!!
    > >> > But if we dont do anything about it they will get it.
    > >> > For now we change the password every 5 minutes but we need more
    securit
    > > y.
    > >> > So changing the sa loginname will be a good place to start, I cant
    > > figure
    > >> > out why I cant change that loginname!!! (like in Oracle!!)
    > >> > Or give the sa user no more rights and create my own 'sa'...:-s
    > >> >
    > >> > But I guess that the security of SQL server isnt that good or I am
    > >> > wrong?????
    > >> >
    > >> >
    > >> >
    > >> >
    > >> >
    > >> > "helmut woess" <hw@iis.at> schreef in bericht
    > >> > news:1jmjhgla30xw6.g3j5avfsyn1b.dlg@40tude.net...
    > >> >> Am Sun, 16 Oct 2005 18:41:40 +0200 schrieb Pipo:
    > >> >>
    > >> >>> Yes, we did. We know one of their IPs and blocked it...
    > >> >>> But they are using now another IP (IPnumber 9 and 3 different
    domains
    > >> >>> also!!...:-<)
    > >> >>> It takes a lot of work every time blocking another IP of theirs....
    > >> >>> So the easy thing for us is to just simply(??) change the sa
    > >> >>> loginname
    > >> >>> into
    > >> >>> something else.
    > >> >>> But I guess that's not possible??
    > >> >>> We cant change our Domain name or SQL server name also...!!
    > >> >>> Why cant I change the sa loginname???
    > >> >>>
    > >> >>> thanks for the help Joseph
    > >> >>>
    > >> >>> "Joseph Bittman MVP MCSD" <RyanBittman@msn.com> schreef in bericht
    > >> >>> news:ukgdT5m0FHA.2884@TK2MSFTNGP09.phx.gbl...
    > >> >>>> October 16, 2005
    > >> >>>>
    > >> >>>> Don't you have a router in place between the SQL Server and the
    > >> >>>> outside
    > >> >>>> world? Can't you trace where the packets are coming from and block
    > > that
    > >> >>>> IP/Domain name?
    > >> >>>>
    > >> >>>> --
    > >> >>>> Joseph Bittman
    > >> >>>> Microsoft Certified Solution Developer
    > >> >>>> Microsoft Most Valuable Professional -- DPM
    > >> >>>>
    > >> >>>> Web Site: http://71.39.42.23/
    > >> >>>> Static IP
    > >> >>>> "Pipo" <Pipo@home.com> wrote in message
    > >> >>>> news:OAK3n%23l0FHA.560@TK2MSFTNGP12.phx.gbl...
    > >> >>>>> Hi,
    > >> >>>>>
    > >> >>>>> Is there a way to change the sa as loginname?
    > >> >>>>> At work we are getting haked by 'brut-force', every second we are
    > >> >>>>> beinbg
    > >> >>>>> attacked with sa and a password.
    > >> >>>>> It's a matter of time when the password will be hacked, so
    changing
    > >> >>>>> the
    > >> >>>>> password isnt a solution.
    > >> >>>>> If we also can change the sa loginname we will be better of.
    > >> >>>>> Or is there something else we can do to prevent the hackers to
    get
    > > our
    > >> >>>>> sa
    > >> >>>>> password?
    > >> >>>>>
    > >> >>>>> Many thanks
    > >> >>>>>
    > >> >>>>
    > >> >>>>
    > >> >> Is your traffic between clients and Server encrypted? If not they
    can
    > >> >> find
    > >> >> login and passwort in clear text in the traffic.
    > >> >> I can highly recommend to use a simple VPN-Server and allow
    > >> >> connections
    > >> >> from outside only over VPN!
    > >> >>
    > >> >> bye, helmut
    > >> >
    > >> >
    > >>
    > >>
    > >
    > >
    >
    >


  • Next message: Rob R. Ainscough: "Re: Is there any way to prevent hacker trying to guess sa password?"

    Relevant Pages

    • 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: 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: Credentials not being passed with remote access
      ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
      (microsoft.public.sqlserver.security)
    • Re: asp.net sql trusted connections between machines
      ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
      (microsoft.public.dotnet.framework.aspnet)