|
Home > Archive > microsoft.public.cert.mcdba > September 2003 > Exam 70-228 Book - MultiServer Job Problem in Exercise
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Exam 70-228 Book - MultiServer Job Problem in Exercise
|
|
| NEW_TO_SQL 2003-09-02, 12:24 am |
| I'm currently a newbie to SQL 2000. I'm trying to study
for it by following along the blue Microsoft SQL Server
2000 System Administration Exam 70-228 book.
For anyone that has or follows this book, chapter 13,
Lesson 5 talks about creating a multiserver job. I'm
following along the practice exercises and I now run into
a problem. I'm trying to create a master server using the
MSX Wizard. All the steps work fine according to the
directions in the book until the end where it asks
for "Specifying a MSX account". This step is entirely
missed out in the book.
I tried Windows Authenication and SQL Server
authentication. When I try Windows Authentication, I get
the following error message: "The account
SelfpacedSQL\sqlservice is not a valid MSX account.
Contact the MSX administrator to get the MSX account
information."
Since this failed, I decided to try SQL Server
Authentication with a new created account named:
multiserver. This gets me to the next step where I see the
summary page from the wizard. It shows three steps. The
first two steps succeed (starts). They are "Create MSX
Operator" and "Create MSX Account". The final step fails
to start, "Enlist Server SelfpacedCPU\MyNamedInstance". I
get the following error message for this last one: The
wizard could not make this server a MSX, because none of
the servers selected could be enlisted".
Then I double click on the failure to get more detailed
information about this error: "Error 22022: SQLServerAgent
Error. Use Windows Authentication for the MSX account if
SQL server is not running as a Windows NT administrator".
I have double checked my settings and I am logged on as
the domain admin as used throughout the book. I have also
made sure that both instances on SQL server has the
SQLServerAgent started and running.
I have check the errata for this book with no help.
Microsoft support site doesn't seem to have much
information on this error.
The only difference I have from the book is the
installation of Service pack 3a.
I would appreciate any help on this matter. Thanks in
advance!
| |
| Vlodron 2003-09-09, 4:26 pm |
| Have you checked that the SQLAgent is running under an Admin. account (it
needs to)?
"NEW_TO_SQL" <noemail@thisplace.com> wrote:
>I'm currently a newbie to SQL 2000. I'm trying to study
>for it by following along the blue Microsoft SQL Server
>2000 System Administration Exam 70-228 book.
>
>For anyone that has or follows this book, chapter 13,
>Lesson 5 talks about creating a multiserver job. I'm
>following along the practice exercises and I now run into
>a problem. I'm trying to create a master server using the
>MSX Wizard. All the steps work fine according to the
>directions in the book until the end where it asks
>for "Specifying a MSX account". This step is entirely
>missed out in the book.
>
>I tried Windows Authenication and SQL Server
>authentication. When I try Windows Authentication, I get
>the following error message: "The account
>SelfpacedSQL\sqlservice is not a valid MSX account.
>Contact the MSX administrator to get the MSX account
>information."
>
>Since this failed, I decided to try SQL Server
>Authentication with a new created account named:
>multiserver. This gets me to the next step where I see the
>summary page from the wizard. It shows three steps. The
>first two steps succeed (starts). They are "Create MSX
>Operator" and "Create MSX Account". The final step fails
>to start, "Enlist Server SelfpacedCPU\MyNamedInstance". I
>get the following error message for this last one: The
>wizard could not make this server a MSX, because none of
>the servers selected could be enlisted".
>
>Then I double click on the failure to get more detailed
>information about this error: "Error 22022: SQLServerAgent
>Error. Use Windows Authentication for the MSX account if
>SQL server is not running as a Windows NT administrator".
>
>I have double checked my settings and I am logged on as
>the domain admin as used throughout the book. I have also
>made sure that both instances on SQL server has the
>SQLServerAgent started and running.
>
>I have check the errata for this book with no help.
>Microsoft support site doesn't seem to have much
>information on this error.
>
>The only difference I have from the book is the
>installation of Service pack 3a.
>
>I would appreciate any help on this matter. Thanks in
>advance!
| |
| JBandi 2003-09-16, 2:25 pm |
|
HI
MSX Account is the same as the SQL Server Agent service account.
Verify first that SQL Server Agent service account local admin or have
Proxy account access.
Verify that SQL Server Agent service account member of the
TargetServersRole in msdb (must manually add to role)
JBandi
--
Posted via http://dbforums.com
|
|
|
|
|