x

Subscriber does not create the database

I have created the subscriber database but I cannot see the tables. I can only see the System tables. Why do I see that difference. Please advice.alt text

more ▼

asked Aug 09, 2012 at 08:36 PM in Default

avatar image

Chitrarekha
140 37 42 45

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

I hope you have completed the following - Created Publisher and Publication Created Subscriber and Subscription

Once the above steps are completed, you must generate the snapshot, this applies initial copy of the schema and data into the subscribers. Once this is applied, you can see the articles in your subscribers.

more ▼

answered Aug 10, 2012 at 05:23 AM

avatar image

Cyborg
10.8k 37 53 51

(comments are locked)
10|1200 characters needed characters left

I suspect that this has a lot to do with your previous question and the fact that the distributor cannot connect to the subscriber to actually apply the snapshot. Fix the permissions issue and everything should run fine.

more ▼

answered Aug 10, 2012 at 08:01 AM

avatar image

WilliamD
26.2k 18 33 48

  • permissions are usually the reason for items to be hidden from the object explorer in my experience

Aug 10, 2012 at 02:12 PM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x358

asked: Aug 09, 2012 at 08:36 PM

Seen: 604 times

Last Updated: Aug 10, 2012 at 02:12 PM

Copyright 2016 Redgate Software. Privacy Policy