Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Access SQL database on different PC

Author  Topic 

Mokkian
Starting Member

3 Posts

Posted - 2010-07-13 : 02:29:00
Hi, I m a new user of MS SQL Server 2008 and I m doing a project linking SQL database with C#. I am now facing problem on how to access one computer database from another computer. My exact condition is that there is a main PC with a database. It is needed to read and edit database in the main PC from a child PC. I have searched on internet and it is somethg related with remote connections. But, I have tried and still cannot figure it out. Can anyone help me? I need all the steps in setting up such database. Thanks.

sql-programmers
Posting Yak Master

190 Posts

Posted - 2010-07-14 : 06:29:16
Open the SSMS and right click on the servername in the Object Explorer and select Properties from the menu. It will open the server properties window, click the Connections from the left navigation and check off the "Allow remote connections to this server" option.

SQL Server Programmers and Consultants
http://www.sql-programmers.com/
Go to Top of Page

Mokkian
Starting Member

3 Posts

Posted - 2010-07-14 : 22:09:33
I have done this settings but still cannot make it. But is it any other settings needed. Can anyone show me all the steps needed?
Go to Top of Page
   

- Advertisement -