I have a wierd problem and I hope some of you may have some clues for me.
I have a VPN between 2 database servers. One is Hong Kong, One is Europe.
The VPN is working fine, I can copy files between the 2 servers.
If I open Query Analyser on HK server and connect to Europe server using sa login, I can connect, however I CANNOT execute any query, what I got was General Network Error after a minute or two.
If I open Query Analyser on Europe server and connect to Hong Kong server using sa login, I can connect, and I can execute query.
I am only 'select * from sysobjects'
Any idea what went wrong? According to my network guy, all ports on the VPN is opened.
Thank you very much.