urgent help please

Discussion in 'SQL Server' started by mad_girl, Sep 12, 2007.

  1. mad_girl

    mad_girl New Member

    Joined:
    Aug 14, 2007
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    0
    can any one do me a favor and tell in steps what should i do to solve this problem:
    i finished my database and connected it to VB 2005 code and it works great,but now i want to make the access to it by user name and password .so i created anew login in my server.. now i want to
    1-encrypt the database or i don know just make it closed when it's transfered to the client computer
    2-make the code access the server or the database through this login account only
    3-make the client through code only execute procedures in database and nothing else.......
    so how to make the whole story work
     
  2. venkatesanj@hcl.in

    venkatesanj@hcl.in New Member

    Joined:
    Oct 19, 2007
    Messages:
    24
    Likes Received:
    1
    Trophy Points:
    0
    Yes you can achieve it using SQL server Login credentials.

    Create your own user in your machine (SQL server user authentication) and use the same in the connection string for ado.net connections with the database.

    You should specify like command.CommandType=CommandType.StoredProcedure;

    Regards,
    Venkatesan Prabu. J
     
  3. urstop

    urstop New Member

    Joined:
    Oct 17, 2007
    Messages:
    84
    Likes Received:
    0
    Trophy Points:
    0
    You can use some kind of encoding/decoding in your application. Encode all the data before saving in the database. that way for some one who opens the database directly cannont make out wha thte data is.

    Similary when you need to display the data thru the applicaiton, get the data, decode it and display to the user.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice