Re: Password MDF

Julián Sanz García (jsanz@xxxxxxxxxxxx) writes:
¿Are there any way to protect a database that is reditributed with a
desktop application? I want to protect this database with an user and a
password, something like access, but with SQL Server 2005, if you have
SQL Server 2005 Management Studio, you can access without any problems
and you can see all database objects.

As far as I know the password for Access databases is easily cracked
and offers no real protection.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: MDF file level security from copying
    ... is a way to protect the MDF files, ... located on FAT like Windows 98 and Windows ME, ... >BTW, if you are concerned about the database schema, as ... >> file while the sql server is stopped? ...
    (microsoft.public.sqlserver.security)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How can I secure a MSDE database for users who have SQL Server?
    ... > How can I protect a MSDE-database so that SQL Server Enterprise ... > Manager always asks for a password if you want to access the database ... if you know the login name and password. ...
    (microsoft.public.sqlserver.msde)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Password protect access DB?
    ... There are cracks even for SQL Server admin passwords. ... What is the purpose of your security ... ... protect your data from being manipulated without the interface or prevent ... directly in the database. ...
    (microsoft.public.dotnet.languages.vb)