question

RafaelAguilar-4841 avatar image
0 Votes"
RafaelAguilar-4841 asked saldana-msft edited

Error 80004005 Task Sequence and multiple SQL errors

Good afternoon Team.

When I run the sequence of tasks to clone a computer I am getting the error 80004005. I know and understand that this error code is very generic so I am sending you the log smsts.log extracted from the client machine.

106716-image.png

106669-image.png

Additionally all visible devices within MECM appear offline, my client tells me that most of the devices are powered on and within the organization's network.

I have the impression that the server has no communication with the devices and this leads to the failure with the TS.

What other records can I validate?

Greetings.

106670-image.png


mem-cm-generalmem-cm-osd
image.png (1.3 MiB)
image.png (61.6 KiB)
image.png (243.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ColinFord-6663 avatar image
0 Votes"
ColinFord-6663 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RafaelAguilar-4841 avatar image
0 Votes"
RafaelAguilar-4841 answered

Good afternoon Colin.

I found these errors in the mpcontrol and smsdbmon logs

108731-image.png

108649-image.png

108663-image.png



image.png (42.8 KiB)
image.png (44.3 KiB)
image.png (39.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ColinFord-6663 avatar image
0 Votes"
ColinFord-6663 answered

Take a look at smsdbmon.log, mpcontrol.log and SMSProv.log on the primary and see if there are any clues there.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RafaelAguilar-4841 avatar image
0 Votes"
RafaelAguilar-4841 answered

Here are the properties of the MP, use the system account

108403-image.png



image.png (32.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RafaelAguilar-4841 avatar image
0 Votes"
RafaelAguilar-4841 answered

I did 2 tests from the mp sitep server to the sql server telnet and ODBC test and these were the results:

108389-image.png

108451-image.png

108357-image.png

What other options do I have?



image.png (3.5 KiB)
image.png (4.3 KiB)
image.png (12.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ColinFord-6663 avatar image
0 Votes"
ColinFord-6663 answered

Here are a few ways https://systemcenterguru.wordpress.com/2014/02/20/simple-ways-to-test-sql-connectivity/

Under the Management Point properties, check which account is used to connect from the MP to the DB and test with that account.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RafaelAguilar-4841 avatar image
0 Votes"
RafaelAguilar-4841 answered

There is enough space and the services are started, what connectivity tests can I do to determine why it is not communicating correctly?

Best regards

108340-image.png

108421-image.png



image.png (31.7 KiB)
image.png (15.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ColinFord-6663 avatar image
0 Votes"
ColinFord-6663 answered

What is the state of the SQL server and disk space on server 3 (DB)? It seems like your other servers are having trouble communicating with it.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RafaelAguilar-4841 avatar image
0 Votes"
RafaelAguilar-4841 answered

Hi Colin Thanks for replying.

I have the following:

Server as main site and MP.
2. Server as DP.
3. Server as DB.

I remain attentive.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ColinFord-6663 avatar image
0 Votes"
ColinFord-6663 answered

What's the state of your CM DB SQL server?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.