I am trying to get replication to work on my system and keep getting the
following problem trying to start up the Push to my servers.
All the schemas seem to be generated on all the servers, but not the tables.
After telling it to initialize the subscriptions I get the following
message:
***********************************************************************
Subscriptions were created successfully at the following Subscribers:
PTERADON
SQL Server Enterprise Manager could not start the service
'SQLServerAgent' on server 'DINO'.
5 - (Access is denied)
The subscription at Subscriber 'PTERADON' cannot be initialized
immediately because the snapshot for this publication is not yet
available. To initialize the subscription, start the Distribution Agent
after the snapshot is available.
***************************************************************************
SQLServerAgent is running on the Server "Dino", so I don't know why I am
getting that message.
Also, in the Replication Monitor, almost all the folders have a red
circle with an X in it.
In the "Snapshot agent" folder I have an item "northwind" (which is what
I am trying to publish), with the following message:
The process could not bulk copy out of table
'[dbo].[syncobj_0x4630333239354338]'.
In the "log reader agents", I get the following:
The license for this installation of SQL Server does not permit Log
Reader Agent to run at the Publisher.
Could not get license information correctly.
I also get the License message for the distribution agents.
What License are they talking about?
Thanks,
Tom.Is your sql service running as user with administrative rights or is it
running as local system. Try to use user with admin rights.
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:3FC462B7.6080805@.deltanet.com...
> I am trying to get replication to work on my system and keep getting the
> following problem trying to start up the Push to my servers.
> All the schemas seem to be generated on all the servers, but not the
tables.
> After telling it to initialize the subscriptions I get the following
> message:
> ***********************************************************************
> Subscriptions were created successfully at the following Subscribers:
> PTERADON
> SQL Server Enterprise Manager could not start the service
> 'SQLServerAgent' on server 'DINO'.
> 5 - (Access is denied)
> The subscription at Subscriber 'PTERADON' cannot be initialized
> immediately because the snapshot for this publication is not yet
> available. To initialize the subscription, start the Distribution Agent
> after the snapshot is available.
>
***************************************************************************
> SQLServerAgent is running on the Server "Dino", so I don't know why I am
> getting that message.
> Also, in the Replication Monitor, almost all the folders have a red
> circle with an X in it.
> In the "Snapshot agent" folder I have an item "northwind" (which is what
> I am trying to publish), with the following message:
> The process could not bulk copy out of table
> '[dbo].[syncobj_0x4630333239354338]'.
> In the "log reader agents", I get the following:
> The license for this installation of SQL Server does not permit Log
> Reader Agent to run at the Publisher.
> Could not get license information correctly.
> I also get the License message for the distribution agents.
> What License are they talking about?
> Thanks,
> Tom.
>|||Dalibor Cvijetinovic wrote:
> Is your sql service running as user with administrative rights or is it
> running as local system. Try to use user with admin rights.
>
No. I have both set up as SqlAgentCmdExec and it has executive priviledges.
All the tasks have these license errors as shown below and may be why I
can't get this to work correctly.
Where do they come from and why am I getting them. Did I not load
something correctly when I set up Sql Server 7'
Thanks,
Tom.
>
> "Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
> news:3FC462B7.6080805@.deltanet.com...
>>I am trying to get replication to work on my system and keep getting the
>>following problem trying to start up the Push to my servers.
>>All the schemas seem to be generated on all the servers, but not the
> tables.
>>After telling it to initialize the subscriptions I get the following
>>message:
>>***********************************************************************
>>Subscriptions were created successfully at the following Subscribers:
>>PTERADON
>>SQL Server Enterprise Manager could not start the service
>>'SQLServerAgent' on server 'DINO'.
>>5 - (Access is denied)
>>The subscription at Subscriber 'PTERADON' cannot be initialized
>>immediately because the snapshot for this publication is not yet
>>available. To initialize the subscription, start the Distribution Agent
>>after the snapshot is available.
>>
> ***************************************************************************
>>SQLServerAgent is running on the Server "Dino", so I don't know why I am
>>getting that message.
>>Also, in the Replication Monitor, almost all the folders have a red
>>circle with an X in it.
>>In the "Snapshot agent" folder I have an item "northwind" (which is what
>>I am trying to publish), with the following message:
>>The process could not bulk copy out of table
>>'[dbo].[syncobj_0x4630333239354338]'.
>>In the "log reader agents", I get the following:
>>The license for this installation of SQL Server does not permit Log
>>Reader Agent to run at the Publisher.
>>Could not get license information correctly.
>>I also get the License message for the distribution agents.
>>What License are they talking about?
>>Thanks,
>>Tom.
>>
>
No comments:
Post a Comment