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 '12 at 08:36 PM in Default

Chitrarekha gravatar image

140 30 40 43

(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 '12 at 05:23 AM

Cyborg gravatar image

10.6k 36 39 45

(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 '12 at 08:01 AM

WilliamD gravatar image

25.8k 17 19 41

+1 - permissions are usually the reason for items to be hidden from the object explorer in my experience
Aug 10 '12 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Aug 09 '12 at 08:36 PM

Seen: 477 times

Last Updated: Aug 10 '12 at 02:12 PM