I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got 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."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:
Quote:
Originally Posted by
Hello,
I am learning SQL Server 2005 Express. I need to test replication but
when I run New Subscription Wizard I got 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."
I see no option for publications. Does this mean that in Express I
cannot run replication? If I can, how?
Thank you very much
/RAM/
SQLExpress can use Replication, but only as subscriber. And your message
says, SQLExpress cannot access the publisher. Do you have a publisher
running? Publisher cannot be done with SQLExpress.
bye, Helmut|||On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@.inode.at>
wrote:
Quote:
Originally Posted by
>Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:
>
Quote:
Originally Posted by
>Hello,
>I am learning SQL Server 2005 Express. I need to test replication but
>when I run New Subscription Wizard I got 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."
>I see no option for publications. Does this mean that in Express I
>cannot run replication? If I can, how?
>Thank you very much
>/RAM/
>
>SQLExpress can use Replication, but only as subscriber. And your message
>says, SQLExpress cannot access the publisher. Do you have a publisher
>running? Publisher cannot be done with SQLExpress.
>
>bye, Helmut
thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?
/RAM/|||Am Fri, 07 Jul 2006 16:05:09 +0200 schrieb R.A.M.:
...
Quote:
Originally Posted by
BTW, is Replication and Data Mirroring the same thing?
>
/RAM/
Hmm, i am no expert for this. As much as i know is, that data mirroring
means it happens in real time, so you can switch with no delay from one
server to the other one. Replikation goes in intervals, between the
intervals data between the two databases is different. But i am not sure if
this is the right definition.
bye, Helmut|||"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:v7qsa2tmij36hi65heqv02j8p52t59nesi@.4ax.com...
Quote:
Originally Posted by
On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <user22@.inode.at>
wrote:
>
thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?
No.
Quote:
Originally Posted by
>
/RAM/
>
No comments:
Post a Comment