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 |
|
csaha
Yak Posting Veteran
52 Posts |
 Posted - 2012-08-30 : 17:42:17
|
| I would like to create the distributor separate from the publisher. So on configuration of the distributor(server1), I choose the second option and add and got the following error message. My publisher server will be server 1. But I want to connect to server 2(remote server) for the distribution database. I get the following error message: Server1 is not enabled as a Publisher at the Distributor, Server2. Contact the administrator of the Distributor to enable this server as a Publisher. Does that mean I have to create the distributor and publisher in the same server? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
csaha
Yak Posting Veteran
52 Posts |
Posted - 2012-08-31 : 12:20:34
|
| I have created the distributor in the remote server(server1). In the distributor properties select a page menu distribution database is created in server 1, Publishers is created server2. Entered the password when I assigned the publisher connection. Where do I create the publisher? When I create the publisher in server1 where the distributor is created error :Server 1 must be enabled as a Publisher before you can create a publication. In the following dialog box, enable this server as a Publisher. Do I enable both server1 and server 2 as publisher. I want the publisher to reside in server2.When I create publisher in server2 error, distribution database does not exist. Not quiet sure what steps I am missing. Please advice. |
 |
|
|
csaha
Yak Posting Veteran
52 Posts |
Posted - 2012-08-31 : 15:26:27
|
| I used the following link to create remote distributor database:http://www.sqlservercentral.com/articles/Stairway+Series/72282/ |
|
|
|
|
|
|
Cannot create a remote distribution database