×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Backups in a multiserver environment while using Central Management Server and Server Groups

Backups in a multiserver environment while using Central Management Server and Server Groups

Backups in a multiserver environment while using Central Management Server and Server Groups

(OP)
Hello All,
I am trying to set up backups of multiple databases a multi-server environment while using Central Management Server and Server Groups.
After I made IT-D-ADMIN2\SRVCEMNGR as my Master, in a Multi-server Administration from the SQL Server Agent, I was successful in adding and connecting 3 instances.
However, the Enlist TXS progress operation listed the following steps that the installation will take:
Create MSXOperator
Make sure the Agent service for 'IT-D-ADMIN2\SRVCEMNGR' is running
Ensure the agent startup account for 'AGV1DB' has rights to login as a target server
Enlist 'AGV1DB' into 'IT-D-ADMIN2\SRVCEMNGR'
Ensure the agent startup account for 'CMPDB' has rights to login as a target server
Enlist 'CMPDB' into 'IT-D-ADMIN2\SRVCEMNGR'
Ensure the agent startup account for 'EATECDB' has rights to login as a target server
Enlist 'EATECDB' into 'IT-D-ADMIN2\SRVCEMNGR'.

However some pass some fail with the following error. Upon Googling the error, the URL is broken:
Enlist TSX Progress
- Create MSXOperator (Success)
* Checking for an existing MSXOperator.
* Updating existing MSXOperator.
* Successfully updated MSXOperator.
- Make sure the Agent service for 'IT-D-ADMIN2\SRVCEMNGR' is running (Success)
* The service 'SQLAgent$SRVCEMNGR' is running.
- Ensure the agent startup account for 'AGV1DB' has rights to login as a target server (Error)
* Checking to see if the startup account for 'AGV1DB' already exists.
* Login 'NT Service\SQLSERVERAGENT' does not exist on server 'IT-D-ADMIN2\SRVCEMNGR'. Creating.
Messages
* Create failed for Login 'NT Service\SQLSERVERAGENT'. (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft...
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Windows NT user or group 'NT Service\SQLSERVERAGENT' not found. Check the name again. (Microsoft SQL Server, Error: 15401)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%...
- Enlist 'AGV1DB' into 'IT-D-ADMIN2\SRVCEMNGR' (Error)
* Enlisting target server 'AGV1DB' with master server 'IT-D-ADMIN2\SRVCEMNGR'.
* Using new enlistment method.
Messages
* MSX enlist failed for JobServer 'AGV1DB'. (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft...
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The enlist operation failed (reason: The time-out was exceeded while the server waited for a response from SQL Server Agent. Make sure that the SQL Server Agent service is running) (Microsoft SQL Server, Error: 22026)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%...
- Ensure the agent startup account for 'CMPDB' has rights to login as a target server (Success)
* Checking to see if the startup account for 'CMPDB' already exists.
* Login exists on server.
* Checking to see if login has rights to msdb.
* Login has rights to msdb.
* Checking to see if user is a member of the TargetServersRole.
* User is a member of the TargetServersRole.
- Enlist 'CMPDB' into 'IT-D-ADMIN2\SRVCEMNGR' (Error)
* Enlisting target server 'CMPDB' with master server 'IT-D-ADMIN2\SRVCEMNGR'.
* Using new enlistment method.
Messages
* MSX enlist failed for JobServer 'CMPDB'. (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft...
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The enlist operation failed (reason: The time-out was exceeded while the server waited for a response from SQL Server Agent. Make sure that the SQL Server Agent service is running) (Microsoft SQL Server, Error: 22026)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%...
- Ensure the agent startup account for 'EATECDB' has rights to login as a target server (Success)
* Checking to see if the startup account for 'EATECDB' already exists.
* Login exists on server.
* Checking to see if login has rights to msdb.
* Login has rights to msdb.
* Checking to see if user is a member of the TargetServersRole.
* User is a member of the TargetServersRole.
- Enlist 'EATECDB' into 'IT-D-ADMIN2\SRVCEMNGR' (Error)
* Enlisting target server 'EATECDB' with master server 'IT-D-ADMIN2\SRVCEMNGR'.
* Using new enlistment method.
Messages
* MSX enlist failed for JobServer 'EATECDB'. (Microsoft.SqlServer.Smo)
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft...
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The enlist operation failed (reason: The time-out was exceeded while the server waited for a response from SQL Server Agent. Make sure that the SQL Server Agent service is running) (Microsoft SQL Server, Error: 22026)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%...

Please help, and thank you for your advice.
Regards,
Tayo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close