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 |
|
avipenina
Starting Member
44 Posts |
 Posted - 2007-08-08 : 00:59:44
|
| Hi,i've enabled the certification authentication login i use SQL 2K5 ENTmy problem is like that: in the client network utility i check the Force protocol encryption and connectto the server the client can't connect because he doesn't have the certificate install on his machine which it's OK.the problem is when i remove the Force protocol encryption on the client he connect successfully without thecertificate install on his machine or any thing.i double check that on the server i've YES on the Force Encryption in the protocols For MSSQLSERVER.why is that???THX |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-08 : 14:01:46
|
| Enforcing encryption is different from certificate, client can talk to sql server as long as client/server communication is encrypted. |
 |
|
|
avipenina
Starting Member
44 Posts |
Posted - 2007-08-08 : 14:23:05
|
quote:
Originally posted by rmiao
Enforcing encryption is different from certificate, client can talk to sql server as long as client/server communication is encrypted.
how it can be encrypted if the client doesn't have the certificate install on his machine and the server enforce encryption? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-08 : 14:47:31
|
| It does on protocol level. |
|
|
|
avipenina
Starting Member
44 Posts |
Posted - 2007-08-08 : 15:24:01
|
quote:
Originally posted by rmiao
It does on protocol level.
ok. so how can i view that the connection is indeed secure with MS Network Monitor? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-08 : 15:37:11
|
| It's encrypted if you don't see readable text in the package. |
|
|
|
|
|
|
Force Encryption Login not working