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 |
|
midpitts
Starting Member
12 Posts |
 Posted - 2012-03-29 : 15:38:19
|
| I am a student and just completed an assignment setting up and configuring a distributer using the Configure Distributer Wizard. I got a confirmation success screen showing that it was completed. This is my difficulty: I am supposed to be able to expand the Object Exployers Replication folder and see a new distribution database, additional jobs etc. None of these are there. The only things I can see that could be a problem was some alerts that were in the wizard as I went through the various steps. I am not sure how I could get a success screen if these could have been a huge problem. The alerts I saw were as follows: On the SQL Server Agent Start page:For the wizard to configure teh SQL Server Agent service, the SQL server service account must have administartor permissions on the server computer. If the service does not have these permissions, you must chang the configuration manually.On the Snapshot Folder page:The snapshot folder does not support pull subscriptions created at the Subscriber. It is not a network path or it is a drive letter mapped to a network path. To support both push and pull subscriptions, use a network path to refer to this folder. (I don't think this could apply as I am working SQL Server 2008 entirely from one computer and not on a network.) I will be most appreciative of any assistance that can help me clear this up.Thanks,Diane |
|
|
SQLSoldier
Master of MCMs
9 Posts |
Posted - 2012-04-05 : 20:24:51
|
| Setting up the distributor doesn't set up replication. It creates a database called "distribution" (default is distribution, but you cna actually choose a different name). This will show up in Object Explorer as a system database under Databases -> System databases. Then you need to configureone of the databases as a publicher and then someone else as a subscriber.Robert L DavisMicrosoft Certified Master: SQL Server 2008Sr. Product Consultant and Chief SQL EvangelistIdera |
 |
|
|
|
|
|
replication wizard problems