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

Chitrarekha gravatar image

Chitrarekha
140 32 42 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, 2012 at 05:23 AM

Cyborg gravatar image

Cyborg
10.6k 36 40 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, 2012 at 08:01 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

+1 - 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.

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x305

asked: Aug 09, 2012 at 08:36 PM

Seen: 519 times

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