I have an access (2002) project which i connect with SQL server 2000.
The server name = MAINSERVER
In the local network i setup the connection: File -> connection... and i give the name (MAINSERVER) and the databasename. It works fine.
But several users connect (with the same project) from home with a VPN. They can't connect using the servername, but they have to work with the IP address of the server.
Does anyone knows why they cannot work with the servername MAINSERVER???
Yes, there is a firewall. Perhaps that is the problem
I'm at home now, and I just started the VPN, and then the query analyzer. Then i was asked for the servername and I typed the IP address (The name doesn't work as you know)
when i type sp_serverhelp i see the following:
network name MAINSERVER
status rpc,rpc out,use remote collation
collation name NULL