Walkthrough: Setting up a SQL Server database
This topic walks you through the process of using Microsoft SQL Server to set up a database that will be used when installing TrueSight Server Automation on Microsoft Windows.
These tasks should be performed by a database administrator (DBA). Perform the steps in the exact order in which they are described.
This topic includes the following sections:
This topic is intended for system and database administrators preparing to install TrueSight Server Automation. The goal of this topic is to demonstrate how to use SQL Server to set up a database and login ID for that database. Access to a database is a prerequisite to running the TrueSight Server Automation unified product installer or when manually installing TrueSight Server Automation.
What does this walkthrough show?
In this walk through, we set up a database and a user login that can access the database.
When installing TrueSight Server Automation using the unified product installer, the installation program automatically populates a database schema. The installer accesses that database using connection information that is defined in this walkthrough.
If you are installing TrueSight Server Automation and its database manually (rather than by using the unified product installer), you can use this procedure to set up a database and then later run the script that populates the database schema for TrueSight Server Automation.
What do I need to do before I get started?
For this walkthrough, you must have SQL Server installed and you must have credentials to access SQL Server.
- 2008 (EE, SE)
- 2008 Cluster (EE, SE)
- 2008 R2 (EE, SE)
- 2008 R2 Cluster (EE, SE)
- 2012 (EE, SE)
- 2012 Cluster (EE,SE)
- 2012 R2 (EE, SE)
- 2014 (EE, SE)
- 2016 (EE, SE)
For SQL Server to support TLS 1.2, certain client components and driver updates are required, as discussed in the following Microsoft article: https://support.microsoft.com/en-us/kb/3135244
How to set up a SQL Server database and user account
Start the Microsoft SQL Server Management Studio application and connect to the Microsoft SQL database server.
|2||Expand the database server.Right-click the Databases folder and select New Database.|
Provide a name for the database you are setting up and click OK to exit the New Database wizard.
Click here to see best practices for naming.
Create the login credentials for the database.
Right-click the Security folder and select New > Login.
|5||Create log in credentials for the database.|
If you are setting up your database with a default language other than English, click here for collation information.
If you are setting up TrueSight Server Automation to support a language other than English, on the Database properties > Options page, select the Collation for your language that is case-insensitive, accent-sensitive, and (where appropriate) kana-sensitive. For example, if you are setting up TrueSight Server Automation for French, use French_Cl_AS. If you are setting up TrueSight Server Automation for Japanese, use Japanese_Cl_AS_KS. The new database appears under the Databases folder. You can set other options at this time too, but they are not required.
For a case-insensitive collation to be effective for your new user database, ensure that the master database is set to case-insensitive collation, as well.
Assign roles to the login name.
|8||To reduce the likelihood of database deadlocks, execute the following steps:|
Wrapping it up
Congratulations. You have successfully set up a database and user in SQL Server. You are now ready to run the unified product installer.