My SQL Server 2008 R2 doesn't work after changing the
MAXDOP parameter on instances.
I have 6 instances located on the same physical server and I changed
MAXDOP from 1 to 2 on 5 instances. After that all these 5 instances don't work. After restart of the server any services don't start and I just see the error
The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details
In Event Viewer I didn't find anything useful, also error log wasn't updated when I tried to run instance.
Also I noticed a strange thing. When I open the Configuration Manager and open properties of instance, I don't see the fonts of parameter's name in Advanced tab. In another tabs everything is fine. The screen is attached. Does anybody faced the same problem?
I don't have any idea how repair this...
upd: By the way, i tried start sql server manually from command line with -f or -m parameter but nothing.. I just see empty error window