There are many different editions of the Microsoft SQL Server 2005 and 2008 database servers including their Express editions which are free to use. The following are instructions 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. Settings for other editions will be similar. Please contact your database administrator in case you have any questions. But in essence, we have to create a database and a database user who has all rights on that database.
To create a database user , and database , open SQL Server Management Studio and user, you need to login as sa (the database administrator user).
To create a database
...
:
- Right click the Security node 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.
To create a database:
- Right click the Database node and click 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 Choose SQL_Latin1_General_CP1_CI_AS as as the Collation (available from the Options page on the left)
- Click Click OK.
| Info |
|---|
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 or 2005 > Configuration Tools > /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.