Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- How to find privilege changes with SQL Server Default Trace
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
SQL Server Configuration Manager from Command Line
12 May,2015 by Tom Collins
Question: How can I start SQL Server Configuration Manager from Command Line?
Answer: To start SQL Server Configuration Manager from Command line is a slightly different reference for every SQL Server Version.
You can access information normally obtained therough SQL Server Configuration Manager in alternative ways such as SQL Server – Find SQL Server tcp port with Powershell . But SQL Server Configuration Manager remains my primary method to manager configurations
For 2005 - SQLServerManager.msc
For 2008/R2 - SQLServerManager10.msc
For 2012 - SQLServerManager11.msc
For 2014 - SQLServerManager12.msc
For 2016 - SQLServerManager13.msc
For 2017 - SQLServerManager14.msc
Read more on command line access through SSMS and other SSMS topics
SQL Server - Open SSMS on the Command Line - SQL Server DBA
Clear list of server names on SQL Server Management Studio
SQL Server – Open SSMS without the splash screen graphic - SQL ...
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |