Firecat1970
IS-IT--Management
Dear experts,
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 file, 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.
Cheers!
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 file, 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.
Cheers!