Microsoft SQL Server 2008, 2012, 2014

Owned by Former user (Deleted)
Last updated: Dec 14, 2015 by Manasi Erande (Unlicensed)
2 min read

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: 

  1. Open the SQL Server Management Studio.
  2. Right click the Database node and click New Database...
  3. Enter the same database name as specified in your license request.
  4. Select celoxis as the owner.
  5. Choose SQL_Latin1_General_CP1_CI_AS as the Collation (available from the Options page on the left)
  6. Click OK.

You should ONLY use SQL authentication mode for accessing the database; Windows authentication will not work.


To create a database user:

  1. Right click on the Security node of the database created and click New > Login.
  2. Enter login name as celoxis.
  3. Choose SQL server authentication.
  4. Enter a password. Note the user name and password down as you will be asked for this later during installation.
  5. Uncheck the Enforce password policy.
  6. Click OK.
     

If you face issues connecting to the SQL Server, check the following :

  1. You have specified the correct details like the DB port number, instance name, etc when making the license request.
  2. 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.
    1. In the SQL Server Configuration Manager select the node SQL Server Network Configuration > Protocols for MSSQLSERVER
    2. Right-click on the TCP/IP node and select Enable
    3. Restart the SQL Server (SQLEXPRESS) service (In Control Panel > Adminstrative Tools > Services, right-click on the SQL Server (SQLEXPRESS) service and select Restart)
    4. Also Turn off the firewall/ check the firewall settings.
    5. 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.
       

If you still face issues, use our debugging tool.