Post reply

securing .mdf File

  • February 20, 2007 at 12:37 am

    #62807

    Hi to every one my name is Ameen , i am new to sqlserver 2000 , i want to seucre the .mdf file of sql server 2000   , if any one want to attach the file , if specific setting of sqlserver exist then it will attach the databases file else it will generate the error thx

  • February 20, 2007 at 2:22 am

    #690593

    Navigate to the following link:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=52094&SiteID=1

     

  • February 20, 2007 at 12:10 pm

    #690727

    I will take the easy route.

    Briefly

    Limit the user rights/privileges on your database Server .

  • February 21, 2007 at 7:35 pm

    #691057

    Thanx to reply me .  i want to deliver mdf file in the cd and my software will attach it , but i want to limit  that no one can attach it in sqlserver  , or installing another instance of sql server

  • February 22, 2007 at 12:24 pm

    #691234

    Zip it with a password and unzip it trough your software installer?

    Or some variation of encryption.

  • February 22, 2007 at 1:29 pm

    #691245

    " i want to deliver mdf file in the cd and my software will attach it , but i want to limit that no one can attach it in sqlserver , or installing another instance of sql server "

    This is not possible:

    1) Any SQL Server administrator will be able to make a backup of the database and then restore to another server.

    2) Any windows administrator can stop SQL server and then copy the mdf/ldf files to another server.

    SQL = Scarcely Qualifies as a Language

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply