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.
| Author |
Topic |
|
petek
Posting Yak Master
192 Posts |
 Posted - 2008-10-29 : 11:34:16
|
| Hi all,Firstly Thanks for looking at this post.I am trying to configure replication between my local machine and a remote box.the remote box is on another subnet and has a different ip address range. how can i connect to this box??Kind RegardsPete. |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-01-02 : 06:16:37
|
| i thick i sorted it.....basically you need to create server aliases....Open SQL Server 2005 Surface Area Configuration from the Configuration Tools, select Surface Area configuration for services and Connections then under Database Engine select Remote Connections and check Local and remote Connections and check Using both TCP/IP and named pipes (Check with Network administrator for security and firewall settings) and applyThen select SQL Server Configuration Manager from program files and click SQL Native Client Configuration and right-click Aliases. And create a new server alias:Alias Name MyServerPort No Protocol (remote server IP Address)Server (Remote Server Name)The server alias should be listed in Management Studio under server objects, linked providers.Then do the same on the remote server and they should be linked. I documented this when I had to do it should anybody want the document.Hope it helps...Kind RegardsPete. |
 |
|
|
satyas
Starting Member
1 Post |
Posted - 2009-01-17 : 00:08:21
|
| Hi, We are working with remote databases in various locations across the state and in the central server all connected to BROAD BAND and will the same method what you have mentioned has to be used for connectivity and use replication. Please reply. Thanks in Advance. |
|
|
|
anabelle
Starting Member
19 Posts |
Posted - 2009-01-30 : 01:44:56
|
| hello petek i wud like to have ur documentation on the remote server, i am a beginner on my job and still coping up with the task, it wud be of great help if i wud read it, so that i wud be effecient and productive here..Many thanks... |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-02-01 : 23:58:21
|
| what should be done, the we use internet and that has a very low speed ?there will be a big problem for initial snapshot ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-02 : 00:00:31
|
quote:
Originally posted by sagitariusmzi
what should be done, the we use internet and that has a very low speed ?there will be a big problem for initial snapshot ?
How big is your publication? Why are you considering replication is speed is so less? |
|
|
|
|
|
|
Remote Subscription......