May 6, 2010 at 10:43 am
Hello all,
Had a problem come up that I have never seen and wanted to get some people's take on what I need to do...
The situation:
We have 3 servers that are supposed to replicate amongst them! We set two servers up yesterday and when we tried setting up the 3 server...We get an error as soon as we started! It is a VM server...And we are using Transactional Replication...When I right clicked on Replication folder and selected Configure Publishing, Distribution, and etc...The first step for us to make that server its own distributor...However when we click Next to go on, we get the following message:
SQL Server Agent on 'VM Server name' currently uses the system account, which causes replication between servers to fail.
I do not have physical access to that VM server, our server administrator set it up...What do I need to do? Is it something that I can change or do I need to talk to him to get him to change something?
Any suggestions/questions/comments are greatly appreciated!
Thanks
DBA
May 6, 2010 at 10:51 am
Adam.Massey (5/6/2010)
Hello all,Had a problem come up that I have never seen and wanted to get some people's take on what I need to do...
The situation:
We have 3 servers that are supposed to replicate amongst them! We set two servers up yesterday and when we tried setting up the 3 server...We get an error as soon as we started! It is a VM server...And we are using Transactional Replication...When I right clicked on Replication folder and selected Configure Publishing, Distribution, and etc...The first step for us to make that server its own distributor...However when we click Next to go on, we get the following message:
SQL Server Agent on 'VM Server name' currently uses the system account, which causes replication between servers to fail.
I do not have physical access to that VM server, our server administrator set it up...What do I need to do? Is it something that I can change or do I need to talk to him to get him to change something?
Any suggestions/questions/comments are greatly appreciated!
Thanks
DBA
Sounds like the SQL Server Agent is configured to use the local system instead of a domain account. This is a SQL configuration, not a VM configuration. Who set up SQL Server on the VM, that is who you need to talk with.
May 10, 2010 at 7:40 am
Ok we got past that problem...We ran into this problem...We created publication and was setting up a push subscription...After going thru the wizard, we got the following message...
Subscriptions were created successfully at the following Subscribers: 'Server Name'
SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server 'Server Name'
5 - Access is denied
Recall that we dont have physical access to this machine...What can I tell the server administrator to see where/what the problem is?
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply