Instance of SQL Server 2012 and here is what we would in the configuration manager.
Now, I would go ahead and stop SQL Service by selecting SQL Server (MSSQLServer) > Right Click > Stop. There are multiple ways to start SQL with startup parameter.
Use Net Start Command from command prompt
Net Start MSSQLServer /mSQLCMD
The above command is the simplest way to add startup parameter to SQL. This parameter would be cleared once we stop and start SQL.
Start SQL Service via command line
SQLServr.exe –mSQLCMD –s<InstanceName>
If we want only management studio query windows to connect then we need to give
-m” Microsoft SQL Server Management Studio – Query” as startup parameter.
Discover more from mycodetips
Subscribe to get the latest posts sent to your email.
