이 문서는 MS-SQL 설치 후 매직인포 서버를 위해 설정해야 하는 내용들을 다룹니다. 

MS-SQL 설정

SQL Server Configuration Manager를 실행하여 아래와 같이 설정합니다. 

1. SQL Server Configuration Manager 진입
   

This document covers how to configure MS-SQL for MagicINFO Server. 

MS-SQL Configuration

Execute the SQL Server Configuration Manager to configure it as follows.

1. Execute SQL Server Configuration Manager 
   Image Added
   
   
2. Network Configuration > TCP/IP Port configuration
   Image Added
   
   Image Added
   
   
3. Set "Enabled" for Named Pipes
   Image Added
   
   
4. Restart Service
   Image Added

Set MS-SQL path in config.properties of MagicINFO Server

1. Set MS-SQL path (https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver15)
   Basic Format:  jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
   Image Added
2. Restart the MagicINFO Server service

Exception Handling

How to handle the error "Can't find MSSQL DB"
Image Added

1. Check whether default name of MS-SQL initial installation is changed 
   Image Added
   
   
2. You can check default instance name in registry editor. Execute regedit, find   Microsoft SQL Server > Instance Names > SQL. 
   Please check whether there is MSSQLSERVER or SQLEXPRESS key. 
   Image Added
   
   
3. If you already installed using another name, please install again using default name or add registry key.