Re: Securing MSSQL

Tech-Archive recommends: Fix windows errors by optimizing your registry


Thanks Linchi:
Can someone copy the mdf/ldf and try to "restore" the DB from these files?
Is it possible to be done?

"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> escreveu na mensagem
news:CF856974-26B3-4162-B2F8-1BEE430D1464@xxxxxxxxxxxxxxxx
Local admin group is sysadmin in SQL Server by default. You can remove
them
and just leave yourself in the sysadmin role.

From Management Studio, expand Security under the SQL instance --> expand
Server Roles --> double click on syadmin to find who's in there.

Linchi

"Paulo" wrote:

Hi, if any one enters as administrator account on windows server will
have
access to the MS SQL DB... I changed the sa pwd account...

I'd like just me (developer) having access to it...

Is it possible? Can I create some user that just this account can access
the
MS SQL DB...? I want avoiding people entering/looking/changing the
tables,
etc...

Thanks





.

Relevant Pages

  • Re: SQLDUMPER library error message (PLEASE HELP)
    ... I ran services.msc and disabelled SQL Server VSS ... >>> Accounting 2007, a new program that I do not even know when or why I ... >> an MS Office 2007 trial - or do a System Restore. ... you'll see an entry made just ...
    (microsoft.public.windowsxp.general)
  • Re: Migration ?
    ... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migration ?
    ... During a restore, all of the metadata is upgraded. ... Moving the Master and MSDB database, what if the old server where those ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)
  • Re: Restoring a SSP 3.0
    ... Also make sure this accounts are configured correctly in the IIS application ... Backup ContentDB in SQL Server using SQL Managagement Studio ... Restore the ContentDB from step 1 to new env. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SQLDUMPER library error message (PLEASE HELP)
    ... which "provides the interface to backup/restore Microsoft SQL ... I'd go back to a Restore Point, but I don't know when installed the ... > an MS Office 2007 trial - or do a System Restore. ... you'll see an entry made just ...
    (microsoft.public.windowsxp.general)