Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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 for Microsoft SQL Server 2008 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 login as sa (the database administrator user).

To create a database user:

  1. Right click the Security node 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.

To create a database: 

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

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

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

  • Go to Microsoft SQL Server 2008 or 2005 > Configuration Tools > 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.
  • No labels