Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.

Question Posted / dinesh sharma


How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then as..

Answer / 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

More SQL Server Interview Questions

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

Define compound operators?

0 Answers  

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

What is temporal data type?

0 Answers  

What is a field in a table?

0 Answers  

What is the significance of master, tempdb and model databases?

0 Answers  

Explain primary key in sql server?

0 Answers  

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

What are distributed partitioned views?

0 Answers  

Is it ok to shrink transaction log?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories