Remote connection SQL | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Remote connection SQL

Hello, We want to connect a SQL DB (SQL 2000) from remote (internet). What are the steps to be taken to do this? When I try this I get the error :
ConnectionOpen(invalid instance) Connection is invalid. What do I do wrong? With regards Geeraert Ralph
Are you using VPN!?? Ensure if the network settings are correct! If it is named instance have you check for the correct instance name !? Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
1. launch VPN
2. if you are connecting your SQL sever via named pipes try using IP address of SQL server instead. (set IP address in your ODBC settings, connect string or Enterprise Manager) it’s all good