Interested to Buy Any Domain ? << Click Here >> for more details...
How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
- 1 Answers
- 5446 Views
- I also Faced
- E-Mail Answers
Answer Posted / bhaskar
To some extent what you can/should do to restrict direct
access depends on you application and deployment
requirements, and what type of direct access you are trying
to prevent. For instance, if you are sole administrator of
all machines that the app will be deployed on, you may be
able to restrict access by locking down the SA password and
dissallowing access to the DB files via the filesystem.
If, on the other hand, you are not the admin, it will be
pretty much impossible to completely block direct access
against a determined admin. The databases can always be
copied via the filesystem to another machine with a useable
SA account.
Even if you are not the admin of the machine, there are
some things you can do to avoid casual access outside of
the app itself. Here is an article that talks about
securing your connection string:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnnetsec/html/THCMCh14.asp
You can also use an application role for server-side
permissions. See:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_security_89ir.asp
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are the properties of the transaction?
How to configure odbc dsn with different port numbers?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
How to create a user to access a database in ms sql server using "create user" statements?
What is difference between global temporary tables and local temporary tables?
What is an execution plan?
What is a scheduled job or what is a scheduled task?
How to transfer an existing table from one schema to another schema in ms sql server?
What are database states in ms sql server?
Are semicolons required at the end of sql statements in sql server 2005?
What is compression - row-level and page-level compression?
What is the contrast between sql and pl/sql?
What are the character string functions supported by sql server 2005?
What is it’s similarity with sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
