How to login to a domain server as admin using vb.net
Posted on 2011-05-03
I have developed an application which is storing ID,Name,FirstName,Photo of an employee, In the Photo field i am storing the address of the picture which is e.g 192.168.0.1/Db files/pic1.jpg.
Db files is a shared folder in Domain Server to which only the domain admin account has the access. the problem is, when i login from a client computer as admin then i can store,see,delete and update employee pictures on the server. However when other user without admin power logsin then they can't access db files.
my connection string is
myCon= New SqlConnection("Data Source=192.168.0.1;Initial Catalog=abc;User ID=sa;Password=123")
i have a solution but i don't want that, if you give access permission on db files to every one then it is ok, but i don't want that, because irresponsible user then can logs in and can make changes.
Could you tell me that solution or another alternative.