Dear All,


I want to establish a remote connection with sql server 2005 in my Asp.net web service.

How to do this in a effective and secured way,

Please reply me with sample code, that will be very helpful for me.

Thanks in advance,

Thanks & Regards,
Vasanth

Username\password encrypted in .config file, or you can use SQL Server public\private keys 2005 and later

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.