Before starting with the installation process, the blank database for Celoxis must be created. The following are instructions can be followed for Microsoft SQL Server 2008/2012/2014 Express Edition.
To create a database, and database user, you need to login as sa (the database administrator user).
To create a database:
- Open the SQL Server Management Studio.
- Right click the Database node and click New Database...
- Enter the same database name as specified in your license request.
- Select celoxis as the owner.
- Choose SQL_Latin1_General_CP1_CI_AS as the Collation (available from the Options page on the left)
- Click OK.
You should ONLY use SQL authentication mode for accessing the database; Windows authentication will not work.
To create a database user:
- Right click on the Security node of the database created and click New > Login.
- Enter login name as celoxis.
- Choose SQL server authentication.
- Enter a password. Note the user name and password down as you will be asked for this later during installation.
- Uncheck the Enforce password policy.
- Click OK.
If you face issues connecting to the SQL Server, check the following :
- Go to Microsoft SQL Server 2008/2012/2014 from your Start programs menu and point to Configuration Tools and then click on SQL Server Configuration Manager.
- In the SQL Server Configuration Manager select the node SQL Server Network Configuration > Protocols for MSSQLSERVER
- Right-click on the TCP/IP node and select Enable
- Restart the SQL Server (SQLEXPRESS) service (In Control Panel > Adminstrative Tools > Services, right-click on the SQL Server (SQLEXPRESS) service and select Restart)
- Also Turn off the firewall/ check the firewall settings.
- In SQL Server Configuration Manager in the TCP/IP settings, clear the "TCP Dynamic Ports" field in "IP All" section and set the TCP Ports to 1433 for IP/ALL and the other IPs, restart the server again.