Database Creation

Follow the steps below to setup the initial database and service account access.

Open SQL Server Management Studio from the start menu.

Connect to your database instance where the database will be stored.

From the Object Explorer, right click on ‘Databases’ and select ‘New Database…’.

step 16

Enter EnterpriseBIPortal or a name of your choosing under ‘Database name’.

Click ‘OK’.

step 17

From the ‘Object Explorer’, expand ‘Security’ and then right click on ‘Logins’ and select ‘New Login…’.

step 18

Click on ‘Search’.

Change the ‘From this location’ to ‘Entire Directory’.

Find the service account that will run the BI Portal IIS site.

Click ‘OK’.

step 19

Click on the ‘User Mapping’ section.

Tick the box for the newly created database.

Change the ‘Default Schema’ to ‘dbo’.

Under ‘Database role membership for database’ select ‘db_owner’.

Click ‘OK’.

step 20