<div>
Nope....you're at the mercy of the users/logins that are available on the target server....
</div>


Nope....you're at the mercy of the users/logins that are available on the target server....

<div>
<br />
I resolved it by myself:<br />
<br />
when backing up the database use the following t-sql statement:<br />
<br />
backup database &lt;dbname&gt; to disk = 'fisicalpath' with password = 'mypasswordhere'<br />
<br />
if you want to restore the database:<br />
<br />
restore database &lt;dbname&gt; from disk = 'fisicalpath' with password = 'mypasswordhere'<br />

</div>



I resolved it by myself:

when backing up the database use the following t-sql statement:

backup database <dbname> to disk = 'fisicalpath' with password = 'mypasswordhere'

if you want to restore the database:

restore database <dbname> from disk = 'fisicalpath' with password = 'mypasswordhere'


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm using msde2000. In my app i'm using sql security for the databases. I also provide functions in the application for backup and restore.<br />
My backup function, calls the this sql command: &nbsp;backup database &lt;dbname&gt; to disk = 'fisicalpath'<br />
where fisicalpath is often on a removeable device like pendrive or zipdisks.<br />
<br />
On target machine i disabled the trusted connection by denying access to any windows user (particullary BUILTIN\Administrators) so the user can't access to database data directly.<br />
<br />
But... If take the file and restore it on a different machine running sql server and it allows me to access any data in the database without any password. Is there a system to protect unautorized access to mdf file even after restore?<br />

</div>
</div>


Hi,

I'm using msde2000. In my app i'm using sql security for the databases. I also provide functions in the application for backup and restore.
My backup function, calls the this sql command:  backup database <dbname> to disk = 'fisicalpath'
where fisicalpath is often on a removeable device like pendrive or zipdisks.

On target machine i disabled the trusted connection by denying access to any windows user (particullary BUILTIN\Administrators) so the user can't access to database data directly.

But... If take the file and restore it on a different machine running sql server and it allows me to access any data in the database without any password. Is there a system to protect unautorized access to mdf file even after restore?


Security issues

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.