ENGLISH (US)
Page 16 of 28
OTH-SEM250-0356 Rev D
8.
SQL Server Set-Up and Connection
8.1.
Identify IP address and port
1.
Navigate to the SQL Server and identify the IP address and the inbound port
associated with the SQL Server (1443) to be used in later steps.
8.2.
Open SQL Management Studio
1.
Connect to the desired SQL Server Database Engine via Client Credentials.
2.
Right-click the database engine server and select “Properties”.
3.
Select the “Security” page.
4.
If “SQL Server and Windows Authentication mode” is not already selected, select this
mode to proceed.
5.
Select “OK” to continue and close this window.
6.
At this time, if changes were made, restart the database engine server by right clicking
the database engine and selecting “Restart”.
7.
Once the restart is complete, expand the “Security” folder in the database engine,
right-click the “Logins” folder and select “New Login…”.
8.
Select the “SQL Server authentication” option.
9.
De-select the “enforce password expiration” and “User must change password at
next login” options.
10.
Enter a login name and password. Record this information for later use, hereby to be
referenced as the “BBI SQL username and password”.
11.
Select the “Server Roles” page.
12.
Set the “Server Roles” such that only the following roles are checked:
a.
dbcreator
b.
public
c.
serveradmin
13.
Select “OK” to save and close the window.
8.3.
Verification of Set-Up
To verify the success of the above steps, run the following steps:
2.
Select the “Connect” button in the left pane tool bar and select the “Database
Engine…” option.
