Results 1 to 6 of 6

Thread: MSX/TSX on SQL 2005 failed

  1. 09-26-2006, 10:42 AM #1
    happy888
    happy888 is offline Registered User
    Join Date
    Apr 2005
    Posts
    11

    MSX/TSX on SQL 2005 failed

    I have a problem to setup the master and target servers for SQL 2005. I got the error:
    The enlist operation failed (reason:SQLServerAgent Error" Unable to connect to MSX 'Servername'.)

    Any idea?
    Reply With Quote Reply With Quote
  2. 09-26-2006, 12:52 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What's sql agent service account?
    Reply With Quote Reply With Quote
  3. 09-26-2006, 01:02 PM #3
    happy888
    happy888 is offline Registered User
    Join Date
    Apr 2005
    Posts
    11
    Both server have the same sql agent account.
    Reply With Quote Reply With Quote
  4. 09-27-2006, 07:52 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Domain or local account?
    Reply With Quote Reply With Quote
  5. 09-27-2006, 07:58 AM #5
    happy888
    happy888 is offline Registered User
    Join Date
    Apr 2005
    Posts
    11
    Domain, system admin account. It worked fine when they are on sql 2000.
    Reply With Quote Reply With Quote
  6. 09-27-2006, 08:17 AM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Is sql browser service running on both servers?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules