CONNECT TO REMOTE PC

Question

Post reply

CONNECT TO REMOTE PC

ßhavin

Old Hand

Points: 357
More actions
September 17, 2010 at 4:53 am

#226899

How to Connect SQL Server of a Remote PC?
I want to connect My Home SQL Server PC To My Office SQL Server Machine>
How to achieve this?
Thaks in advance...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

shailesh.thapliyal Right there with Babe Points: 750 More actions · Answer 1

HI,

I guess for that you need to be on same network. First connect to office network then you can connect to the server.

Thanks,

Shailesh

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 2

Bhavin_Bhatt25 (9/17/2010)
How to Connect SQL Server of a Remote PC?
I want to connect My Home SQL Server PC To My Office SQL Server Machine>
How to achieve this?
Thaks in advance...

hi Bhavin

This link will help to U

http://support.microsoft.com/kb/914277

Or this

http://madhuottapalam.blogspot.com/2006/12/connect-to-remote-sql-server.html

Ali
MCTS SQL Server2k8

ßhavin Old Hand Points: 357 More actions · Answer 3

Whats the next step after doing all these configs?

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 4

Bhavin_Bhatt25 (9/28/2010)
Whats the next step after doing all these configs?

Hi

I think now you can see Ur's office SQL server at Home's SQl server, B'coz U have ragister it now. as per above link.

If U can see your Office server then its connected, what next you want to do?

Or may be I can't Understand what's U R looking For?

Ali
MCTS SQL Server2k8

ßhavin Old Hand Points: 357 More actions · Answer 5

What I mean to say is..

After configuring the settings in firewall and sql server surface area configuration.

how do I connect my Office PC from home PC using SQL Server Management Studio?

IF I need to use my Office Modem IP or anything like this?

Thanks.

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 6

Hi Bhavin

Can u Ping/ Share Resorces from Office to Home PC If Yes Just do as following.

1. Right button on “My computer” and select Manage and you will get Computer Management Window

2. Right click on Computer Management and select Connect to another computer.

3. You will have a "Select Computer Window"

4. Give the Remote Computer Name and press OK

5. Now, you will have the remote computer's Computer Management Window

6. Click on Services and Applications7. Select SQL Server Configuration Manager

And Then do this.

1. Open SQL Server Management Studio. lagin Ur Local Sql Server

2. Right click on Local Server

3. New Server Ragistration.

4. In the New Server Registration dialog, enter the name of the remote computer in the Server name field, click on Test and then Save. If the Database Engine on the remote computer requires SQL Server authentication, you have to change Authentication to SQL Server Authentication to enter the username and password.

5. Back in the Registered Servers window in SQL Server Management Studio,

Ali
MCTS SQL Server2k8