February 25, 2009 at 6:17 am
Hello all,
How can I set up snapshot repliaction between a SQL2000 db and a SQL2005 db?
The publication has been created on SQL2000. The SQL2005 Standard Edition SP2 box has been added to the Remote servers list.
I use Management Studio to create a new subscription (this must be a push subscription).
It opens up the New Subscription Wizard.
After Next, the window in which the publication can be chosen shows the SQL2000 box, but no publication; instead, it shows the following error:
'There are no publications to which you can subscribe, either because this server has no publications or because you do not have sufficient privileges to access the publications.'
In the meantime, I have given the account all admin rights possible on OS and SQL level, and it has been added to the Public Access List. Still no success.
Can you help please?
Does the Remote Server settings needs something special?
tia
Hans
February 26, 2009 at 8:54 am
It looks like there are no publications actually defined.
please verify the results with sp_helppublication
* Noel
February 27, 2009 at 7:08 am
Hello Noel,
I ran sp_helppublication on the publication db, and it returned these results:
1timesheet_prd_TRA01110Snapshot publication of timesheet_prd_TRA database from Publisher NL00-TSHEET1TST.001100000NULL336001NULLNULLNULL0NULL21NULLanonymous00NULL14NULLNULL100
It was a great help, because I saw that there was no job_id; it turned out that the script that I ran to create the publication had some part missing!
After running the missing part of the script, the publication became visible.
Thanks for helping out.
Hans
February 27, 2009 at 8:07 am
H (2/27/2009)
Hello Noel,I ran sp_helppublication on the publication db, and it returned these results:
1timesheet_prd_TRA01110Snapshot publication of timesheet_prd_TRA database from Publisher NL00-TSHEET1TST.001100000NULL336001NULLNULLNULL0NULL21NULLanonymous00NULL14NULLNULL100
It was a great help, because I saw that there was no job_id; it turned out that the script that I ran to create the publication had some part missing!
After running the missing part of the script, the publication became visible.
Thanks for helping out.
Hans
Yeah, looks like the agent was missing.
Glad you solved the problem.
Happy Friday!
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply