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:http://www.codeproject.com/aspnet/encrypt.asp HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |