Some products install a hidden SQL server instance (usually express edition). If you check in Sql Server Configuration Manager, you can see SQL instance name like ‘MICROSOFT##SSEE’. But if you want to connect to it using SSMS (SQL Server Management Studio), you won’t be able to connect to it because the instance is set to hidden. Sometime, we have to connect to it to do some maintenance work as a DBA. So here is the way to unhide it. In SQL Server Configuration Manager, expand SQL Server Network Configuration, right click on “Protocols for MICROSOFT##SSEE”, choose Properties from the context menu. In the Flags tab of the Properties dialog, you can see the Hide Instance flag is “Yes”, just set it to “No”. Please see the following screen shot.

image

You have to restart the SQL server service for this instance to make this flag effective. You will be able to connect to it in SSMS successfully now. Cheers!

扫一扫，分享到微信

微信分享二维码

tag:

    缺失模块。
    1、请确保node版本大于6.2
    2、在博客根目录（注意不是yilia根目录）执行以下命令：
    npm i hexo-generator-json-content --save

    3、在根目录_config.yml里添加配置： 

      jsonContent:
    meta: false
    pages: false
    posts:
      title: true
      date: true
      path: true
      text: false
      raw: false
      content: false
      slug: false
      updated: false
      comments: false
      link: false
      permalink: false
      excerpt: false
      categories: false
      tags: true

Improve daily life using IT techs.