Monday, September 21, 2015

SQL Server Configuration Manager

How to open sql server configuration manager in Windows Server 2012 or 2012 R2 ?

1. RUN--type 
SQLServerManager12.msc  for sql server 2014 
SQLServerManager10.msc  for sql server 2008


2. From Search options type above as required 



Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager not does not appear as an application when running Windows 8. To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager12.msc for SQL Server 2014 (SQLServerManager11.msc for SQL Server 2012 or SQLServerManager10.msc for SQL Server 2008), and then press Enter.

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...