show your connection or use something like (xxx.xxx.xxx.xxx is an IP address
, 1433 is the default port number for SQL Server, see
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer
)
1. make sure the firewall on the server is properly configured
2. make sure you enabled the TCP/IP protocol on the server
3. try to connect to the remote server in SQL Analyzer to make sure you indeed can connect