Accessing Database Through Registry | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Accessing Database Through Registry

A small quesion: I’ve a VB application that calls a Connection file to connect to a server; placed on a share with the following entries.<br /> Provider=SQLOLEDB.1;Integrated Security=SSPI<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ersist Security Info=False;Initial <br /> Catalog=db1;Data Source=SERVER1<br />Since its a share; users can view the file and see the server and database name which i don’t want them to see.<br />Is there a way that if i could make these entries in the registry of this shared server and encrypt the passwords for sql-connection and so that user couldn’t view other info.<br />The connection-file is placed on the share for sake of convinience and to make sure every user uses the same server connection.<br />I can use FILE-DSN but it can still be accessed and can be viewed through notepad.<br />We can’t hard-code the connection into the appication, for we often change the connection settings.<br />My question is how to hide these entries from user along with allowing them access the server from a common connection.<br /><br /><br />Regards!!<br />
Information about encrypting pwds using registry: HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.