April 30, 2009 at 2:44 am
Hi All
I have a SQL Server 2000 running on Win2k3.
I am trying connecting to SQL locally on the Enterprise Manager on the machine but
I get this error: “A Connection could not be established to local
Reason: Encryption not supported on sql server
ConnectionOpen (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 other
remote machines through Enterprise Manager, I just can’t connect
locally. All help is appreciated.
Thanks
Mithalesh
Mithalesh Gupta
mithaleshgupta@aol.com
8802955929
April 30, 2009 at 5:18 am
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 still I can't 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 denied
Please help me to troubleshoot this.
Thanks
Mithalesh
Mithalesh Gupta
mithaleshgupta@aol.com
8802955929
April 30, 2009 at 5:48 am
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 Gupta
mithaleshgupta@aol.com
8802955929
April 30, 2009 at 7:24 am
🙂
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply