By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,784 Members | 3,582 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,784 IT Pros & Developers. It's quick & easy.

2005 Express: testing replication

P: n/a
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/
Jul 7 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:
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
Jul 7 '06 #2

P: n/a
On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <us****@inode.at>
wrote:
>Am Fri, 07 Jul 2006 13:59:23 +0200 schrieb R.A.M.:
>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/

Jul 7 '06 #3

P: n/a
Am Fri, 07 Jul 2006 16:05:09 +0200 schrieb R.A.M.:

....
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
Jul 7 '06 #4

P: n/a

"R.A.M." <r_********@poczta.onet.plwrote in message
news:v7********************************@4ax.com...
On Fri, 7 Jul 2006 14:55:16 +0200, Helmut Woess <us****@inode.at>
wrote:

thank you
no, I have only Express Edition.
pity.
BTW, is Replication and Data Mirroring the same thing?
No.

>
/RAM/

Jul 8 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.