Problem while accessing SQL server 2k remotely?
-
I have an SQL Server 2k (personal edition) running on Windows 2000 Pro for testing. I tried to connect from other PC running SQL server to this databse. However, from SQL Query Analyzer on the local PC, I could not find the database once I clicked on the ... which is right to the SQL Sever: text box. The connection between the PC and the Database machine is modem dialup. From either side, I can ping to each other without any problem. Moreover, once I connected my PC to the intranet, I can access/login to any SQl server database which is within the intranet environment. ANy help are greatly appreciated. JW DJ
-
I have an SQL Server 2k (personal edition) running on Windows 2000 Pro for testing. I tried to connect from other PC running SQL server to this databse. However, from SQL Query Analyzer on the local PC, I could not find the database once I clicked on the ... which is right to the SQL Sever: text box. The connection between the PC and the Database machine is modem dialup. From either side, I can ping to each other without any problem. Moreover, once I connected my PC to the intranet, I can access/login to any SQl server database which is within the intranet environment. ANy help are greatly appreciated. JW DJ
The box that appears when you click the '...' button is filled using broadcasts to the local subnet, on UDP port 1434, or by using NetBIOS broadcasts. It's unlikely that this will work over a dial-up connection, because routers do not forward broadcast messages. You'll need to specify the server explicitly. This may not work using names for the same reason as above, so you may need to use an IP address. Stability. What an interesting concept. -- Chris Maunder