SQL Server Remote Connection

[coolrox86]

Hello,

I am using Microsoft SQL Server Management Studio. I am trying to connect my PC SQL server with other PC SQL server via wireless router. I can connect it, however, I cannot detect any folders transfer between these 2 PCs under "Databases" folder.

Does anyone has any idea on how this could happen and how to solve it?

Thanks for your help in advance.;-)

Thanks,
Coolrox

 

[kam1787]

I am not an expert on SQL Server, but I am not certain what you want to happen, or what you think should happen.

Do you want one database to be a copy of another? One database to update another?

Folders are a physical matter - there are files inside a folder. A database can exist on [or 'span'] different drives...........so folders are not really relevant.

Normally one connects to a database, not databases connecting to each other. Databases can 'talk' to each other but this is done via software, either via a database utility or software program.

 

[coolrox86]

I am not an expert on SQL Server, but I am not certain what you want to happen, or what you think should happen.

Do you want one database to be a copy of another? One database to update another?

Folders are a physical matter - there are files inside a folder. A database can exist on [or 'span'] different drives...........so folders are not really relevant.

Normally one connects to a database, not databases connecting to each other. Databases can 'talk' to each other but this is done via software, either via a database utility or software program.

Yes, I want the database information generated in 1st PC being copied to the database of 2nd PC via SQL server and update it constantly. That means, 1st PC is the host server, database info is only transferred from 1st to 2nd PC. I have tried to do it but it doesn't work.