WDS service stopped after restart (SCCM)
While working on a case we came across an issue where WDS service was getting stopped the moment we restart the server.
We found that WDS service was no automatically starting after restarting the server.WDS service Startup type was set to Automatic.
But we were able to start the service manually, that concluded us that there is not the issue with WDS service.
We checked smspxe.log and found following error:
*inside GetPxeCert
MPDB ERROR - CONNECTION PARAMETERS
SQL Server Name : BLGSCCM01
SQL Database Name : SMS_BLG
Integrated Auth : True
MPDB ERROR - EXTENDED INFORMATION
MPDB Method : Init()MPDB Method HRESULT : 0x80004005
Error Description : Cannot open database "SMS_BLG" requested by the login. The login failed.OLEDB IID : {0C733A8B-2A1C-11CE-ADE5-00AA0044773D}ProgID : Microsoft OLE DB Provider for SQL Server MPDB ERROR - INFORMATION FROM DRIVERSQL Server Name : BLGSCCM01Native Error no. : 4060Error State : 1Class (Severity) : 11Line number in SP : 1
*We specifically found the error related to connectivity with SQL database.
It seems that we were not able to connect to SQL database while initializing the server. The moment all services looks stable, we are able to Start WDS Service (Manually).
There is connecting issue with SQL Database to get PXE certificate when restarting the server. Once all services are running fine, there is not connecting error (that is the reason we are manually able to start the service without failure).
To delay the connectivity of SQL database for WDS server, we changed sms_executive & WDS server to automatic delayed start. We followed this step just to make sure that all services should be running fine before sms_executive service comes into the picture. This service (sms_executive) is responsible to start pxe service point role, which in returns startsthe WDS service. After making changes, we restarted the server, and this method worked, sms_executive service started initially, within few minutes (1-2 min.) WDS service also started. We also replicated customer boot images to smspxeshare. We restarted the server 3-4 times, but we didn't face any issue. Did pxe on one of the machine, we were able to do PXE & get into Windows PE. http://c.statcounter.com/9828573/0/55b9a039/0/