Push failed on New publication - error says owner may not exist or

#1

Hello,

I am just starting out in the replicatin scene. I am reading a manual on
the topic but still in the early chapters. What I did for practice was to
create a publisher/distributor on my dev server using the wizard, but it is
not working. I did get a message that the location of the repdata/log was
restricted or something like that. It is on my local server. I want to
replicate a test table from the publishing DB to another DB on the server in
the same directory structure as RepData. Here is what I did after creating
the publisher/distributor and request suggestions what else I need to do to
make this work

First I create the test table - tbl1 in the publisher DB - DB1. tbl1 has a
primary key field and one varchar field. I insert 4 rows of test data. Then
I create a new "Transactional" publication using the wizard. In the article
section of the wizard I select tbl1 as my article. I click on the elipse
button and name the owner of the destination table as the name of the dB that
I want to subscribe to this publication, DB2. Then I follow the wizard and
click finish. I get the snapshot, the log and the agent. Then on the agent
I click on "Push new publication". I select DB2 as the subscriber DB.
Afterwards, the snapshot says "Never Started" even though I clicked start.
Then I look at the Distribution Agents folder and see an error message that
says:

"Specified owner name 'DB2' either does not exist or you do not have
permission to use it."

Well, DB2 does exist and I am administrator of everything. Could someone
tell me what I need to do/change/re-do to make this work?

Thanks,
Rich

#2

I changed my test replication to a snapshop, and that seems to be working
fine. From what little understanding I have about sql serve replication, I
believe snapshot replication rewrites the entire table based on the currently
set schedule. And Transactional replication only writes inserted rows and
updates. Is this correct?

Either way, I am still having a problem setting up transactional
replication. Any suggestions appreciated.

"Rich" wrote:

Quote:

Hello,

I am just starting out in the replicatin scene. I am reading a manual on
the topic but still in the early chapters. What I did for practice was to
create a publisher/distributor on my dev server using the wizard, but it is
not working. I did get a message that the location of the repdata/log was
restricted or something like that. It is on my local server. I want to
replicate a test table from the publishing DB to another DB on the server in
the same directory structure as RepData. Here is what I did after creating
the publisher/distributor and request suggestions what else I need to do to
make this work

First I create the test table - tbl1 in the publisher DB - DB1. tbl1 has a
primary key field and one varchar field. I insert 4 rows of test data. Then
I create a new "Transactional" publication using the wizard. In the article
section of the wizard I select tbl1 as my article. I click on the elipse
button and name the owner of the destination table as the name of the dB that
I want to subscribe to this publication, DB2. Then I follow the wizard and
click finish. I get the snapshot, the log and the agent. Then on the agent
I click on "Push new publication". I select DB2 as the subscriber DB.
Afterwards, the snapshot says "Never Started" even though I clicked start.
Then I look at the Distribution Agents folder and see an error message that
says:

"Specified owner name 'DB2' either does not exist or you do not have
permission to use it."

Well, DB2 does exist and I am administrator of everything. Could someone
tell me what I need to do/change/re-do to make this work?

Thanks,
Rich

#3

Here is your mistake> click on the ellipse

Quote:

button and name the owner of the destination table as the name of the dB
that
I want to subscribe to this publication, DB2.

Recreate the publication, but leave out this step. It should work now.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Rich" <Rich (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello,

I am just starting out in the replicatin scene. I am reading a manual on
the topic but still in the early chapters. What I did for practice was to
create a publisher/distributor on my dev server using the wizard, but it
is
not working. I did get a message that the location of the repdata/log was
restricted or something like that. It is on my local server. I want to
replicate a test table from the publishing DB to another DB on the server
in
the same directory structure as RepData. Here is what I did after
creating
the publisher/distributor and request suggestions what else I need to do
to
make this work

First I create the test table - tbl1 in the publisher DB - DB1. tbl1 has a
primary key field and one varchar field. I insert 4 rows of test data.
Then
I create a new "Transactional" publication using the wizard. In the
article
section of the wizard I select tbl1 as my article. I click on the elipse
button and name the owner of the destination table as the name of the dB
that
I want to subscribe to this publication, DB2. Then I follow the wizard
and
click finish. I get the snapshot, the log and the agent. Then on the
agent
I click on "Push new publication". I select DB2 as the subscriber DB.
Afterwards, the snapshot says "Never Started" even though I clicked start.
Then I look at the Distribution Agents folder and see an error message
that
says:

"Specified owner name 'DB2' either does not exist or you do not have
permission to use it."

Well, DB2 does exist and I am administrator of everything. Could someone
tell me what I need to do/change/re-do to make this work?

Thanks,
Rich

#4

Yes, this is correct.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Rich" <Rich (AT) discussions (DOT) microsoft.com> wrote

Quote:

I changed my test replication to a snapshop, and that seems to be working
fine. From what little understanding I have about sql serve replication,
I
believe snapshot replication rewrites the entire table based on the
currently
set schedule. And Transactional replication only writes inserted rows and
updates. Is this correct?

Either way, I am still having a problem setting up transactional
replication. Any suggestions appreciated.

"Rich" wrote:

Hello,

I am just starting out in the replicatin scene. I am reading a manual on
the topic but still in the early chapters. What I did for practice was
to
create a publisher/distributor on my dev server using the wizard, but it
is
not working. I did get a message that the location of the repdata/log
was
restricted or something like that. It is on my local server. I want to
replicate a test table from the publishing DB to another DB on the server
in
the same directory structure as RepData. Here is what I did after
creating
the publisher/distributor and request suggestions what else I need to do
to
make this work

First I create the test table - tbl1 in the publisher DB - DB1. tbl1 has
a
primary key field and one varchar field. I insert 4 rows of test data.
Then
I create a new "Transactional" publication using the wizard. In the
article
section of the wizard I select tbl1 as my article. I click on the elipse
button and name the owner of the destination table as the name of the dB
that
I want to subscribe to this publication, DB2. Then I follow the wizard
and
click finish. I get the snapshot, the log and the agent. Then on the
agent
I click on "Push new publication". I select DB2 as the subscriber DB.
Afterwards, the snapshot says "Never Started" even though I clicked
start.
Then I look at the Distribution Agents folder and see an error message
that
says:

"Specified owner name 'DB2' either does not exist or you do not have
permission to use it."

Well, DB2 does exist and I am administrator of everything. Could someone
tell me what I need to do/change/re-do to make this work?

Thanks,
Rich

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Push failed on New publication - error says owner may not exist or

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication

Push failed on New publication - error says owner may not exist or - 05-11-2006 , 04:08 PM

RE: Push failed on New publication - error says owner may not exist or - 05-11-2006 , 05:50 PM

Re: Push failed on New publication - error says owner may not exist or - 05-11-2006 , 08:25 PM

Re: Push failed on New publication - error says owner may not exist or - 05-11-2006 , 08:25 PM