SQL Query analyzer not connect to server

[vtrong2002]

Hi all.
I user wingate5.2.3, client use SQL Query analyzer connect to SQl server error (Windows client not use proxy):
"Unable to connect to server 224.24.65.58 (Example)
Server: Msg 18, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error "

Please help me.
Thanks

[Pascal]

Is this connecting from a client behind the WinGate Server to a server on the Internet? (If yes, how does the client connect through WG? [wgic/proxy/nat] Does this work if you do it directly from the server itself?

This kb article from Microsoft might be of use as it talks about the problem. The test with establishing the connection directly from the WG Server would help isolate potential problem areas.

[vtrong2002]

Client connect WG by wgic
and in system message, FireWall, i don't see any message.

[Pascal]

Have you tried it via NAT? Did the knowledge base article offer any help at all?

[vtrong2002]

I think, if I have new message in System message or FireWall, this is server or port, which is dened by Wingate sever, I can open if it block SQL client connect to SQL server

[Pascal]

From memory - I think that would have been port 1433? What mode do you have WGIC set to run in on the client? (Local, Mixed, etc.)

[vtrong2002]

From memory - I think that would have been port 1433? What mode do you have WGIC set to run in on the client? (Local, Mixed, etc.)

Yes, I openned this port and WGIC I set Mixed mode

[Pascal]

Ok, opening the port WinGate side should not have made a difference to the WGIC connection - only to the WinGate Server attempting the same connection.

With that port open, can the WinGate server connect or do you get the same message? If it cannot connect - can you check the settings as described in the Knowledge Base article?

[vtrong2002]

I'm sorry. I don't see any message in System Messager or FireWall.

[Pascal]

Even when connecting from the Wingate server itself? Does that work - can you connect to the SQL Server from your WinGate server?

[vtrong2002]

Even when connecting from the Wingate server itself? Does that work - can you connect to the SQL Server from your WinGate server?

Soory i don't understand what you said
I think, I have to connect to the SQL Server in my computer which is instal Wingate Server?

Thanks.

[Pascal]

Yes. If you try to connect to SQL Server database from the machine that has WinGate installation. Does that work?

[vtrong2002]

Yes. If you try to connect to SQL Server database from the machine that has WinGate installation. Does that work?

Yes, that is good.
And when I use new computer which connect to internet not use firewall (wingate Server and client), SQL Client connect to SQL server is very good.