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

MS-SQL

Configuration

Execute the SQL Server Configuration Manager를 실행하여 아래와 같이 설정한다Manager to configure it as follows.

1. Execute SQL Server Configuration Manager 진입 Manager 
   
   
   
2. 네트워크 설정 > TCP 포트 설정 Network Configuration > TCP/IP Port configuration
   
   
   
   
   
3. Named Pipes 항목을 Enable로 설정 Set "Enabled" for Named Pipes
   
   
   
4. 서비스 재시작 Restart Service
   

매직인포 서버의 config.properties 파일에서 Set MS-SQL 경로를 설정한다.

path in config.properties of MagicINFO Server

1. Set MSSQL 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]]
   
2. 매직인포 서버의 서비스 재시작

예외 상황 대처

1. Restart Service of MagicINFO Server

Exception Handling

How to handle the error "Can't find MSSQL DB 에러 발생시 대처 요령
Image Removed

Image Removed

"
Image Added

1. Check whether default name of MS-SQL initial installation is changed Image Added
   
   
2. The name of initial installation must be same with Named instance specified in(in) the(ðǝ) default.(difɔ́ːlt).