Re: Remote SQL Server

From: Chris Miller (cmiller_at_compuville.net)
Date: 01/22/04 

Date: Thu, 22 Jan 2004 15:19:38 -0500

I'm going to try to lock it down to only a list of known host ranges, but
I'm not sure that will be possiable.

Where do I set what hosts each user can login from? Also, how do I set sa to
only be allowed to connect from localhost?

-Chris

"Don Grover" <spamfree@assoft.com.au> wrote in message
news:%23JhsCNS4DHA.2404@TK2MSFTNGP10.phx.gbl...
> I get about 10-20,000 hits a night from what looks like dictionary
attacks.
> Make sure all users & sa user have a a very long non standard password.
> Can you lock the firewall down to a list of known host ranges on port 1433
> ?.
> Run MS Base line security application on sql server box !.
> Remove all non essensial db's on sql installation.
>
> Regards
> Don Grover
>
> "Chris Miller" <cmiller@compuville.net> wrote in message
> news:1010agvq9v9k154@corp.supernews.com...
> > I've got a customer who has an application written in Access. They are
> > hitting some boundaries of Access, and are ready to move to SQL. They
are
> > going to keep the front end in Access b/c of the massive amounts of code
> > they have written. We are going to set them up a SQL server in a
> datacenter,
> > and use linked tables in their access database. They have offices all
over
> > the eastern half of the US, so they will need to connect to the SQL
server
> > from anywhere, pretty much.
> >
> >
> >
> > Basically my question is how can I keep this secure? I'm going to setup
> > encryption. Is it a bad idea to leave SQL server open on the public?
How
> > can I lock it down and still keep functionality?
> >
> >
>
>

Relevant Pages

  • Irregular read-only errors
    ... not allowing me to open a recordset with the correct cursor and lock ... I'm about ready to switch to using SQL Server (which I know I probably ... be an easy switch so if I could sort out Access for the time being ... Would setting the ADO connection mode to adModeReadWrite accomplish ...
    (microsoft.public.inetserver.asp.db)
  • Re: Locking question when using Select clause with For Update and Skip locked
    ... This is working fine in SQL Server and multiple session can get the ... But in Oracle the first session only return 1 row but locks all the ... It looks like both the session got the ROW-X lock but one session is ...
    (comp.databases.oracle.server)
  • Re: OLE DB Cursors
    ... You don't do this with properties in the SQL Server OLE DB provider. ... client-side cursor, otherwise you have a server-side cursor managed from the ... I have to do a lot of updates() here, ... > its optimistic lock / client cursor. ...
    (microsoft.public.data.oledb)
  • Re: How does CREATE INDEX impact current users?
    ... take an X lock on the table, thus preventing any access to the table at all. ... This problem is alleviated in SQL Server 2005 with the concept of online ... Creating a clustered index does not copy the table per se - the heap ...
    (microsoft.public.sqlserver.server)
  • Re: Hung up using a SELECT MAX when an alter database has been execute in a SQL Server database
    ... exclusive lock, as it does for the ALTER TABLE statement. ... see "Isolation Levels" in SQL Server Books Online. ... Public Sub StartConnection() ... Set objRstSel = New ADODB.Recordset ...
    (microsoft.public.data.oledb)
Quantcast