How can I secure a MSDE database for users who have SQL Server?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ed-it (ed-it_at_euronet.nl)
Date: 05/12/04 

Date: 12 May 2004 06:09:36 -0700

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
in SQL Server E.M.?

I've created a .NET-application that uses MSDE. I know some of the
users where the application will be running will also have SQL Server
running. I don't want them to look around in my db. How do I protect
my database so that it's only accessible for my application and only
in SQL Server Ent.Man. if you know the login name and password. It
works with SQL Server authentication but not with Windows
authentication.
I install MSDE with mixed mode (SECURITYMODE=SQL) and a password
(SAPWD=mypassword). The connection from my application uses: "User
ID=sa; Password=mypassword".

Thanks for your help,
Ed

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)