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 |
|
BrianBurgit
Starting Member
12 Posts |
 Posted - 2008-08-08 : 10:11:00
|
| I'm trying to set up replication from a remote server to a local server. First, I'm trying to register my local server instance on the remote server, by using entering a value like this in the server name field111.222.333.444\ABC I ran these commandssp_helpserver select @@servername to find that ABC is my instance name. Is that how I find the instance name?If I just enter 111.222.333.444 as the server name when registering it, I can connect, but then I cannot set up replication because it needs an instance name.What am I doing wrong?Thanks,Brian |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 00:12:25
|
| What happened when you register with 111.222.333.444\ABC? |
 |
|
|
BrianBurgit
Starting Member
12 Posts |
Posted - 2008-08-12 : 09:52:58
|
| When I try to register as 111.222.333.444\ABC I get a message saying Cannot connect to 111.222.333.444\ABC. An error has occured while establishing a connection to the server....this may be caused by the fact that under the default settings SQL Server does not allow remote connections.But, if I register as 111.222.333.444, then I can connect, I just cannot set up replication. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-12 : 22:53:52
|
| Is ABC host name of local machine? Are servers involved in same domain? |
|
|
|
BrianBurgit
Starting Member
12 Posts |
Posted - 2008-08-13 : 12:18:39
|
| ABC is the host name of the local machine, and the machines are not in the same domain. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 22:58:26
|
| First, looks like you have default instance on ABC. You should connect to it with host name only. Second, domains need be trusted to set replication. But you can try this: create a local windows account with same id/password on both servers and start sql services with it. |
|
|
|
|
|
|
Help with instance name