Re: Securing a SQL Server Database

Greg
You cannot prevent from SA accessing your database. In order to restore the
database , the user need to be a sysadmin or a member of dbcreator server
role
I'd suggest you to spend a few days to learn a security topic in SQL Server
2005 ,because the MS has introduced lots of features and objects


"Greg" <AccessVBAnet@xxxxxxxxxxxxxxxxx> wrote in message
news:0758BE75-1A5A-4FB5-922C-D5D4AA436225@xxxxxxxxxxxxxxxx
I have a SQL Server 2005 database that is used by an Access ADP program.
What
I'd like to do with my SQL Server 2005 database is secure it with a
UserName
and Password that is only known to my program. Any other use who logs in
to
SQL Server, even the SA User, should not be able to access the database.
Right now, my Access database looks for a secret built in UserName and
Password to connect to the database and then I handle the application
security with my own modules.

My concern is that I don't want any other Access ADP application or
someone
with the SQL Management Studio with an SA Account to be able to access the
database. In other words, the database would only be accessible from my
ADP
Application is it can provide the username and password.

I also want the security to be in such a manner that if the database was
copied, it could not be opened at another machine unless they had the
proper
username and password. I know how to do this with MS Access and am new to
SQL
Server security and could use some help with figuring this out.

How is this done with SQL Server?

And, lastly, how can I create a UserName and Password SQL Account from my
ADP Database application if I need to?

Thanks in advance for your assistance.

Greg




.

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... SQL Server 2000 Out-of-the-Box database security solution. ... database protection and privacy software is an industry-proven ...
    (microsoft.public.sqlserver.security)
  • Re: SQL or Access DB
    ... i am aware of the security modell of SQL server (we do use SQL server ... an end user,,, there is not reall alternative as a worgroup Access database ... MSDE and SQL express are all free ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
    (microsoft.public.sqlserver.security)
  • RE: ASP.Net not impersonating for WSE 2.0
    ... When using username tokens in WSE, this is not an integrated security ... and thus is not integrated into windows security at all. ... Setting up a database that contains credentials is similar to any ...
    (microsoft.public.dotnet.framework.aspnet.webservices)