Installing Server - SQL

eCandidus™ can make use of all versions of Microsoft SQL Server. With the introduction of SQL Server 2008 Express, which is available free here from Microsoft and provides for 10GB of data storage, you can take advantage of a superb top-of-the-class data storage system easily.

In all versions of SQL Server you use the SQL Server Management Studio to manage the database:

Note the Server Name value, as you will use it when installing the eCandidus™ Server.

Once you login, a screen similar to this one should be displayed:

Click on the New Query button, the following screen should appear:

Paste the following text in the query screen:

 

USE [master]
GO
CREATE DATABASE [eCandidus]
GO
CREATE LOGIN [eCandidus] WITH PASSWORD='ćeCandidus', DEFAULT_DATABASE=[eCandidus], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [eCandidus]
GO
EXEC sp_addrolemember @rolename='db_owner', @membername='eCandidus'
GO

 

And then click on the Execute button:

The command will execute and a Message area will display when completed:

 

Verifying that the proper Authentication Mode is in place

Right mouse click on the server line and select Properties:

Enter eCandidus as the database name, and click on OK to create the database.

Create the eCandidus user by right clicking on the Logins entry under the Security entry:

Select the Security entry and make sure that Mixed Mode is selected. Click on OK to save.

You are done with the SQL Server setup.

 

Next: Installing the Server