Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   urgent help please (http://www.go4expert.com/forums/urgent-help-please-t6317/)

mad_girl 12Sep2007 19:27

urgent help please
 
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

venkatesanj@hcl.in 31Oct2007 17:06

Re: urgent help please
 
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

urstop 11Dec2007 14:16

Re: urgent help please
 
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.


All times are GMT +5.5. The time now is 15:32.