Re: Secure a SQL-Server 2000 database.

From: Peter A. Schott (pschott@drivefinancial.com)
Date: 01/20/03 

From: Peter A. Schott <pschott@drivefinancial.com>
Date: Mon, 20 Jan 2003 16:33:23 -0600

Well, if you have initial rights to the server and can control which account
SQL Server runs under, you could always log in as that user, encrypt the
files, and set SQL Server to run under that account.

It works, but it may not be the best way to handle it. Besides, if the user
can change that password, they can still mess with the database.

Just some thoughts.

-Pete

ingar@eide.gs (Ingar Eide) wrote:

> Mary Chipman <mchip@nomail.please> wrote in message news:<l2eg2vcjb8bsorb4fllug7jthqlktja64b@4ax.com>...
> > You can't secure a database from a sysadmin on an instance of SQL
> > Server. If you have the ability to install your own named instance on
> > a client site, you could do it that way by not allowing the client to
> > have sysadmin access to that instance.
>
> Yes, I do that.
> But if the client stops the server, and copy the files to another
> SQL-Server-instance where he has an sysadmin, he can just use
> sp_attach_db, and then he has full access to my db.
>
> Ingar.

Relevant Pages

  • RE: Cant install Windows Small Business 2003 Client
    ... Make sure that the Small Business Server ... that if the client computer is asking for the user and password is because is ... Try deleting one computer and create a new user account and recreate the ... computer object to see if that account can be use connectcomputer then. ...
    (microsoft.public.windows.server.sbs)
  • Re: Using EFS with Network Shares and SFU 3.5
    ... It does not take EFS into account. ... could again use the sharing server audit logs to see if success ... Read extended attribute and Read data, since the NFS client may ... Windows and *nix clients. ...
    (microsoft.public.windows.server.security)
  • RE: configuring client users
    ... This newsgroup only focuses on SBS technical issues. ... | Thread-Topic: configuring client users ... |> computer to SBS server while we need use "set up computer wizard" to ... |> For user account issue, please understand that if you join the client ...
    (microsoft.public.windows.server.sbs)
  • RE: configuring client users
    ... > Welcome to SBS newsgroup. ... we use "connect computer wizard" to connect the client ... > computer to SBS server while we need use "set up computer wizard" to set up ... > best interest to rerun the wizard again to add the client computer account ...
    (microsoft.public.windows.server.sbs)
  • Re: Adv Client with Workgroup Computers
    ... I was trying to use the SMS tools from the SMS server to initiate harware ... Inv for example the account is a domain account but the Client PC is in a ... Is there a procedure for installing the ADV client localy on a workgroup ... I have manually added to the WINS server. ...
    (microsoft.public.sms.admin)
Quantcast