I want to be able to access my SQL Server on my computer from another computer on the network.
Both computers have SQL Server installed now I just need to know how to configure the Host system and what ports I need to open on the firewall for example.
Thanks.
To access from computer A to computer B, you can register/Connect B on A. default port 1433.
SQL Server 2000: on Computer A, open Enterprise Manger, right click SQL server group–>New SQL server registration.. follow the instruction.. SQL 2005 SQL Server Mangement Studio, just connect computer B directly or register…
If you want to join database tables between computer A and computer B, your best answer is to create linked server. on SQL 2000: security->linked server–>new linked server; on SQL2005: server objects–>linked server… From any database in computer A, You can refer or join tables on computer B as linkedserverB.dbname.dbo.tablename
To access from computer A to computer B, you can register/Connect B on A. default port 1433.
SQL Server 2000: on Computer A, open Enterprise Manger, right click SQL server group–>New SQL server registration.. follow the instruction.. SQL 2005 SQL Server Mangement Studio, just connect computer B directly or register…
If you want to join database tables between computer A and computer B, your best answer is to create linked server. on SQL 2000: security->linked server–>new linked server; on SQL2005: server objects–>linked server… From any database in computer A, You can refer or join tables on computer B as linkedserverB.dbname.dbo.tablename
References :