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.
- Execute SQL Server Configuration Manager
- Network Configuration > TCP/IP Port configuration
- Set "Enabled" for Named Pipes
- Restart Service
Set MS-SQL path in config.properties of MagicINFO Server
- 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]]
- Restart the MagicINFO Server service
Exception Handling
How to handle the error "Can't find MSSQL DB"
- Check whether default name of MS-SQL initial installation is changed
- 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.
- If you already installed using another name, please install again using default name or add registry key.