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 |
|
mca47378
Starting Member
3 Posts |
 Posted - 2009-04-30 : 03:19:36
|
| Hi AllI have a SQL Server 2000 running on Win2k3.I am trying connecting to SQL locally on the Enterprise Manager on the machine butI get this error: “A Connection could not be established to localReason: Encryption not supported on sql serverConnectionopne (prelogin(handshake)).”When I am trying with Query analyser I got another addition msg that is"Sql server ODBC driver" rest of the error is same.The odd thing is that I can connect to that SQL Server from otherremote machines through Enterprise Manager, I just can’t connectlocally. All help is appreciated.ThanksMithalesh |
|
|
mca47378
Starting Member
3 Posts |
Posted - 2009-04-30 : 07:11:39
|
| Hi All,I was able to solve it. We just need to uncheck the Encryption support in Client Network Utility. But now I am not able to connect to other sql server DB on other machine, but I can connect to this DB from other machinet. I am getting error"Msg 17, Level 16, State 1[ODBC SQL Server Driver][DBNETLIB]Sql Server does not exist of access deniedPlease help me to troubleshoot this.ThanksMithaleshMithalesh |
 |
|
|
mca47378
Starting Member
3 Posts |
Posted - 2009-04-30 : 07:48:44
|
| My Client is on Win Server 2003 and Server on Wix XP 3. I thought that might be helpful to you in helping me.Mithalesh |
|
|
|
|
|
|
Local Connection Problem.