Typically, I support our product and server (SQL 2000) remotely from our office via a vpn to connect enterprise manager and my red-gate tools to compare and update database files. This site, I could not connect to using the vpn, although I can remote desktop into it. The sql server is utilizing the default port. I thought it might be a firewall issue, but now I'm on site, and plugged into their network and still cannot connect using enterprise manager. If I remote desktop into the actual server, enterprise manager runs fine, and sql server is running.
My application is installed on 30 workstations at the facility, and it connects fine utilizing a stringconnect. The application is working! How come if I can connect from the vfp application, I cannot get a connection with Enterprise manager? Any idea's greatly appreciated.
The only difference at this site, is that the server has two network cards, it's a hp server, and they are using the hp team manager to use both cards. I'm no network/hardware person, so I don't know if this really makes a difference.
Thanks for any insight
Kirk