Though here is C++ but I have a database problem?
-
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
What exactly isthe question??? :confused:
-
What exactly isthe question??? :confused:
Sorry I forgot the problem description itself. The problem is that after the PC client and DB Server (currently SQL 2000 sever running on WIndows 2k Pro) were connected via a dialin service, from the PC site I can not see the DB on the DB Server, nor could I login to the SQL residing on DB Server of course. ANy idea, again? JW DJ
-
Sorry I forgot the problem description itself. The problem is that after the PC client and DB Server (currently SQL 2000 sever running on WIndows 2k Pro) were connected via a dialin service, from the PC site I can not see the DB on the DB Server, nor could I login to the SQL residing on DB Server of course. ANy idea, again? JW DJ
Ok, I think i know the problem now, You can access the DB when you are connected to the intranet but now able to access it via dial in. That is because the firewall of the intarnet is not allowing to make connection from outside the intranet. This is to prevent hackers/viruses to connect to the network. You need to talk to the network administrator of your organization and how he can allow access to the DB only from outside the intranet.
-
Ok, I think i know the problem now, You can access the DB when you are connected to the intranet but now able to access it via dial in. That is because the firewall of the intarnet is not allowing to make connection from outside the intranet. This is to prevent hackers/viruses to connect to the network. You need to talk to the network administrator of your organization and how he can allow access to the DB only from outside the intranet.
-
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