Showing posts with label errorsql. Show all posts
Showing posts with label errorsql. Show all posts

Friday, March 9, 2012

Error 5 when creating a subscription

Hi,
After pushing a subscription I get an error:
SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server '***'.
5 - (Access is denied)
How can I fix that?
Thanks in advance,
MikeSounds like the account on the publisher needs rights on the subscriber...

just a shot in the dark...|||How do I set these rights? I am not sure where I need to look for that information. I have admin rights on both servers.

Friday, February 17, 2012

Error 21060 w/Rep. Between Access and SQL Server

I am trying to establish transactional replication
between a SQL Server DB and an Access database. I keep
getting the following error:
SQL Server Enterprise Manager encountered errors creating
push subscriptions for the following Subscribers:
ACCESS1: Error 21060: Could not subscribe because non-
SQL Server Subscriber 'ACCESS1' does not support
parameterized statements.
What am I doing wrong? Any ideas?
Glenn,
please can you script out your publication and the articles (just schema)
and I'll take a look.
My guess is it is to do with filters, but we'll see.
Regards,
Paul Ibison
|||Right click on your publication, select publication properties, click on the
articles tab. Click on the browse button (the three ellipses to the right of
the article), in the article properties tab, click on commands, all the
commands should read SQL. The send parameters in binary format and the
create the stored procedures... options should be cleared.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Glenn Cadodret" <gcadoret@.lycos.com> wrote in message
news:2d0d501c469fd$7ea8ca90$a401280a@.phx.gbl...
> I am trying to establish transactional replication
> between a SQL Server DB and an Access database. I keep
> getting the following error:
> SQL Server Enterprise Manager encountered errors creating
> push subscriptions for the following Subscribers:
> ACCESS1: Error 21060: Could not subscribe because non-
> SQL Server Subscriber 'ACCESS1' does not support
> parameterized statements.
> What am I doing wrong? Any ideas?