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 |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2004-05-18 : 16:25:43
|
| I have an application installed on my app server and it database resides on another server with SQL2000 installed. Not sure if the client was installed on my application server or not. But yesterday someone installed sql7.0 client connectivity on my app server and since than my original app is not able to connect to my app database. I'm getting following error. I tried uninstalling client and installing SQL2000 client still get the same message. Any help will be appreicated.SQLState: '01000'SQL Server error: 20[Microsoft][ODBC SQL Server driver][TCP/IP Sockets]connectionOpen(PreloginHandshake()).Connection Failed.SQLState:'08001'SQL Server Error: 20[Microsoft][ODBC SQL Server driver][TCP/IP Sockets]Encrytion not supported on SQL Server.What can I check to see what went wrong.Thanks,Jay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-18 : 16:43:50
|
| I would install the latest MDAC. You could also install SQL 2000 service pack 3a on the client machine.Tara |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
0b1
Starting Member
1 Post |
Posted - 2007-09-12 : 17:41:21
|
| It looks like someone turned on Encryption in the client...run C:\WINDOWS\system32\cliconfg.exe make sure the Force protocol encryption is disabled (unchecked) |
|
|
|
|
|
|
SQL ODBC