How To Open Sql Server Installation Center

ane. Overview

SQL Server authentication is recommended for connecting Dundas BI to its application and warehouse databases for security reasons. This article explains how to enable SQL Server authentication, and how to utilise information technology with your Dundas BI example.

This applies when installing or upgrading Dundas BI when information technology uses Microsoft SQL Server to store its own data. Within Dundas BI, users tin then connect, analyze, and visualize data from a diverseness of other data sources or use other authentication methods.

Important

Before reading this article, you should have a basic understanding of using SQL Server Direction Studio.

2. Enabling SQL Server Authentication through SQL Management Studio

To enable SQL Server Authentication for your example:

Open up SQL Server Management Studio.
Connect to the SQL Server instance you would like to utilise for Dundas BI.

Connecting to a database server (due east.thousand., localhost)
In the Object Explorer, right-click the server and click Properties.

Server properties
On the Security page under Server authentication, select SQL Server and Windows Authentication mode and then click OK.

Plough on SQL Server authentication mode
In the Object Explorer, correct-click your server and click Restart. If the SQL Server Agent is running, it must too exist restarted.

Restart SQL Server

iii. Using SQL Server Authentication in Dundas BI

Certain database permissions are needed for the user Dundas BI connects every bit while deploying a Dundas BI example, which tin can be reduced when deploying is finished.

3.1. Earlier deploying an instance

3.1.1. Creating a SQL Server authentication user

During the deployment of an instance with new databases, the user must have the SysAdmin role, or else all of the following: DbCreator, DiskAdmin, ProcessAdmin, and SecurityAdmin.

Create a user like this in SQL Management Studio:

Open SQL Server Direction Studio.
Connect to the SQL Server instance y'all would similar to use for Dundas BI.
Expand the Security binder, correct-click on the Logins binder and choose New Login....

Create SQL Server authentication login from context menu
Enter the login name as DundasBIUser, select SQL Server hallmark, and enter the Password.

Create SQL Server hallmark login
Click the Server Roles page and enable the SysAdmin role, or a combination of DbCreator, DiskAdmin, ProcessAdmin, and SecurityAdmin roles.

Add SysAdmin role to login

3.one.2. Specifying the SQL Server hallmark user

At present that the SQL Server authentication user has been created, use these credentials when you lot deploy Dundas BI and gear up upwardly the application database connection.

Specifying credentials for SQL Server authentication

3.ii. Afterwards deploying an instance

Subsequently deploying, it is possible to remove the SysAdmin role from this user. For regular functioning, the user will simply require the dbo default schema and the db_owner office membership.

The SysAdmin role will be required once again when attempting to upgrade an instance.

four. Irresolute an existing instance to use SQL Server authentication

Follow the steps below to change an existing instance to employ SQL Server authentication for its application and warehouse databases.

4.1. Application database

Open up a text editor such as Notepad every bit an administrator, by right-clicking its shortcut and choosing Run as administrator.

Open the Dundas BI configuration file, located at [InstanceRoot]\www\BIWebsite\App_Data\dbi.config.

Edit the connexion string to utilize SQL Server authentication past specifying the User ID and Password. Afterward saving, recycle the application pool in IIS or restart the Linux service for Dundas BI'southward website.

Updated application database connection string

Note

To change the credentials when the connection cord is encrypted, kickoff decrypt the connectedness string using the dt control line tool, then update the credentials. To resume the secure state, encrypt the connection cord when yous have updated the credentials.

4.2. Warehouse database

The warehouse database connectedness is defined in Dundas BI's configuration settings:

Log into Dundas BI as an administrator, and click the Admin icon in the main menu on the left.

Click to aggrandizeSetup so click Config.

Find or search for the Data Warehouse Connection Cord setting, located in the General category, and edit it to also use SQL Server authentication.