|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Friday, November 19, 2010 8:59 AM
Points: 17,
Visits: 49
|
|
Hi all,
I have a single node cluster with 1 x sql instance. I amended the start up parameters, incorrectly, via sql config manager so SQL would not start.
I went in & changed the parameters to be correct, but the change won't persist. Every time I try to start SQL again, the incorrect change is automatically written back to the start up parameters (& the reg)
I have tried the following:
Amending via the registry
Amending via SQL config manager
starting via cmd line sqlserver.exe ...
net start & net stop
I can start SQL with the cmd line options but cannot get the parameter changes to stay in place and I cannot start SQL via the cluster or service.
I read this, which sounds like the problem, but the solution does not work for me.
http://www.jimmcleod.net/blog/index.php/2008/12/15/cluster-wont-start-due-to-incorrect-startup-parameters/
Any ideas?
SQL 25K
Thanks in advance!!
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Friday, November 19, 2010 8:59 AM
Points: 17,
Visits: 49
|
|
Aha, this DOES work:
amend params via registry
net start mssqlserver
start sql via cluadmin.exe
stop via cluadmin.exe & start again
changes will persist.
sorry to bother, hope this helps someone.
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: 2 days ago @ 1:28 AM
Points: 734,
Visits: 614
|
|
This pretty much worked for me though i had to reset the registry entry again before stopping and starting SQL in cluadmin.exe.
Nuke the site from orbit, its the only way to be sure... 
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, January 09, 2012 2:08 PM
Points: 2,
Visits: 96
|
|
|
|
|
