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 
   
   
   
2. Network Configuration > TCP/IP Port configuration
   
   
   
   
   
3. Set "Enabled" for Named Pipes
   
   
   
4. Restart Service
   

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]]
   
2. Restart the MagicINFO Server service

Exception Handling

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

1. Check whether default name of MS-SQL initial installation is changed 
   
   
   
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. 
   
   
   
3. If you already installed using another name, please install again using default name or add registry key.