Configuring using SQL Server Management Studio
Prev | Chapter 32. Prepare the MS SQL Server Database for the Tigase Server | Next

## Configuring using SQL Server Management Studio

In order to prepare database one can use either Wizards or execute queries directly in the Query Editor. First of all you need to establish connection to the SQL Server instance thus from Object Explorer select Connect and in the Connect to Server dialog enter administrator credentials.

### Using Wizards

- Create Login

  In the left-hand side panel select Security → Logins and from context menu choose New Login, in the Wizard window enter desired Login name, select SQL Server authentication and enter desired password subsequently confirming action with OK

- Create Database

  From the Object Explorer select Databases node and from context menu select New Database; in the Wizard window enter desired Database name and enter previously created Login name into Owner field; subsequently confirming action with OK.

### Using Queries

From the Object Explorer root node’s context menu select New Query. In the Query windows execute following statements adjusting details to your liking:

    USE [master]
    GO

    CREATE DATABASE [tigasedb];
    GO

    CREATE LOGIN [tigase] WITH PASSWORD=N'tigase12', DEFAULT_DATABASE=[tigasedb]
    GO

    ALTER AUTHORIZATION ON DATABASE::tigasedb TO tigase;
    GO

Prev | Up | Next
Preparing SQL Server Instance | Home | Import Schema