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
- 5498 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 elements of dbms?
How to get the definition of a user defined function back?
What are the transaction properties?
How do I start and stop sql server?
System variable and temporary variables
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is the difference between char and varchar2 datatype in sql?
What is statement level trigger?
How to defragment table indexes?
Explain the types of indexes.
Can two tables share the same primary key?
What is the fastest way to permanently delete a 1 million row table named customers?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Please differentiate between a local and a global temporary table?
What is an execution plan? When would you use it?
