How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
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 |
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is difference between stored procedure and function?
What are synonyms?
How to connect a database with sql express.?
what stored procedure would you use to view lock information? : Sql server administration
What is Sqlpaging in SqlServer 2005 ?
What are different types of statements that are supported by sql?
How to convert a table data in XML format in sql server?
write the query for taking database backup in sql
10 Answers ABC, IBM, Logica CMG, MA,
What is openxml in sql server?
How can you insert null values in a column while inserting the data?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?