I want to start my SQL Server Express instance in single user mode to do some troubleshooting such as restoring the Master database.
I am unable to find the "Startup Parameter" options in SQL Server Configuration Manager.
I have found some blogs such as http://mssqlfun.com/2014/09/04/how-to-start-sql-server-in-single-user-mode/, however I am unable to add the
-m parameter to the 'Startup Parameters'.
See below for screenshots of my SQL Server Configuration Manager:
My working environment is:
- MS SQL Server 2012 Express 11.1.3000.0
- Windows Server 2012 R2
- SQL server 2012 Express is installed in a Domain
- OS is running under VMware
Is there any possible way to connect through the console? Any idea or suggestion would be appreciated.
I am able to see startup parameters from this T-SQL: 'select * from sys.dm_server_registry;', however I am unable to see the settings in SQL Server Configuration Manager.