June 5, 2006 at 2:16 am
A SQL Server box being restated, when the box up the 'Domain controller" for the SQL Server Service account not available, resulted the SQL Server services are failed to start.
Error Message:
No Windows NT or Windows 2000 Domain Controller is available for domain DOMAINSRVR. The following error occurred:
There are currently no logon servers available to service the logon request.
After sometime Domain Controller are available. But still SQL Server services not started automatically. Later manually started the service.
Is there any configuration can be done so SQL Server Services would try some attept some time later?
June 6, 2006 at 2:52 am
You could play with the Services.msc settings for Recovery to attempt to start the service, however this will not account for the DC being offline for a long time as you do have limitions for 3 failures.
The best approach is to not restart any dependant servers while DC is offline.
Andy
June 6, 2006 at 7:38 am
Is there any reason to have the Service use a Domain account. Have the service use a local adminstrator account.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply