Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sopaul
Starting Member
2 Posts |
 Posted - 2003-09-01 : 16:17:11
|
| Hello!!!IS there any way to send the connection password encrypted??? I´ve set the User Id and the password, and both are sent by clear text on the net... can I change it???Thanks for your help!!!!Pablo |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-09-19 : 07:41:42
|
| Create a simple DLL to return connection and register it in the web server. Create connections using the dll. I belive it is the simplest way. correct me if i am wrong.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-19 : 22:32:37
|
| You can always use the HTTPS protocol when connecting to your web site. All data between the client and server will be encrypted.Additionally you can encrypt network traffic between SQL Server and the web server. Run the Server Network Utility in the SQL Server program group, there is a checkbox to set network encryption. All network protocols can be encrypted in SQL 2000, earlier versions only encrypt under the Multiprotocol library. This should be done even if you use the DLL like samsekar suggested.Books Online has more details if you need them. |
|
|
|
sopaul
Starting Member
2 Posts |
Posted - 2003-09-22 : 22:55:31
|
| Thanks all for your help!!!I was searching the ADO documentation and after MDAC 2.5 the password is encrypt in all conections... there´s no problem!!!Regards,Pablo |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-09-22 : 23:14:33
|
| How about posting the syntax of the ADO statement to encrypt the password?Sam |
|
|
|
SqlStar
Posting Yak Master
121 Posts |
Posted - 2003-09-23 : 05:09:38
|
| Sam,We have to decrypt that password string and send to as connection string.":-) IT Knowledge is power :-)" |
|
|
|
|
|
|
Password encryption when opening an ADO Connection