Replication error....

We try to perform replication. We configured our server for
replication. Steps that we followed:
1) Create Publishing and distribution wizard
2) Create Publication wizard
3) Create Pull subscription wizard
We did not meet any errors until while doing them. But at the end of
the process in the replication monitor red cross signs (As seen in
http://stx.cs.deu.edu.tr/~zbektas/er.JPG ) on the publishers and
subscribers and their status seem as "failed". Why?
We can not start the SQL agent because of "the service did not start
due to a logon failure" error. Is this error related with our
replication failure?
Zafer,
SQL Server Replication infrastructure involves many things including a series of jobs which are scheduled and run by the SQL Server Agent. So, if your agent is stopped, replication won't work. Try changing the SQL Server Agent service to use the same doma
in account as your SQL Server Service and then restart it, and then run the Replication Agents.
Regards,
Paul Ibison
|||This is likely your problem. Locate your SQL Server agent and ensure it is
running with a valid account and password.
"zafer" <zaferbektas2000@.yahoo.com> wrote in message
news:c71dc7b.0404020741.2519351e@.posting.google.co m...
> We try to perform replication. We configured our server for
> replication. Steps that we followed:
> 1) Create Publishing and distribution wizard
> 2) Create Publication wizard
> 3) Create Pull subscription wizard
> We did not meet any errors until while doing them. But at the end of
> the process in the replication monitor red cross signs (As seen in
> http://stx.cs.deu.edu.tr/~zbektas/er.JPG ) on the publishers and
> subscribers and their status seem as "failed". Why?
> We can not start the SQL agent because of "the service did not start
> due to a logon failure" error. Is this error related with our
> replication failure?

Replication and BDE (Borland Database Engine)

Hi,
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
Leila
Hi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:

> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returned
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>
|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:

> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>

Replication and BDE (Borland Database Engine)

Hi,
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
Leila
Hi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:

> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returned
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>
|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:

> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>

Replication and BDE (Borland Database Engine)

Hi,
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
LeilaHi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:

> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returne
d
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
>|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:

> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem
.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>