Book Image

VMware vSphere 5.1 Cookbook

By : Abhilash G B
Book Image

VMware vSphere 5.1 Cookbook

By: Abhilash G B

Overview of this book

Amidst all the recent competition from Citrix and Microsoft, VMware's vSphere product line is still the most feature rich and futuristic product in the virtualization industry. Knowing how to install and configure vSphere components is important to give yourself a head start towards virtualization using VMware. If you want to quickly grasp the installation and configuration procedures, especially by using the new vSphere 5.1 web client, this book is for you.VMware vSphere 5.1 Cookbook will take you through all the steps required to accomplish a task with minimal reading required. Most of the tasks are accompanied with relevant screenshots with an intention to provide a visual guidance as well.The book has many useful recipes that will help you progress through the installation of VMware ESXi 5.1 and vCenter Server 5.1. You will learn to use Auto Deploy and Image Profiles to deploy stateless/stateful ESXi servers, configure failover protection for virtual machines using vSphere HA, configure automated load balancing using vSphere DRS and DPM. Finally, the book guides you through upgrading or patching ESXi servers using VMware Update Manager and also deploying and configuring vSphere Management Assistant (VMA) to be able to run scripts to manage the ESXi servers.
Table of Contents (20 chapters)
VMware vSphere 5.1 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating DB users for the SSO database


During the installation of the Single Sign On component, once the table space has been created, the installer would need a database username and password to generate a JDBC connection URL.

This user has to be manually created using the SQL script, rsaIMSLiteMSSQLSetupUsers.sql, available on the vCenter's installation DVD.

How to do it...

The following steps will help you create a DB user using the SQL script rsaIMSLiteMSSQLSetupUsers.sql:

  1. Copy the rsaIMSLiteMSSQLSetupUsers.sql script from the vCenter's installation DVD to the database server. The location of the file is as follows:

    CD/DVD ROM :\Single Sign On\DBScripts\SSOServer\schema\mssql

  2. On the database server machine, start the Microsoft SQL Server Management Studio and make sure that you are connected to the correct database server instance.

  3. Drag-and-drop the rsaIMSLiteMSSQLSetupUsers.sql file to the SQL Server Management Studio.

  4. Enter new passwords for the RSA_DBA and RSA_USER users.

    Here is how the script would look after the passwords have been supplied:

  5. Click on Execute to run the script on the database server instance.

How it works...

On a successful execution of the query, it creates two security login accounts, RSA_DBA and RSA_USER. It also creates two security users, dbo and RSA_USER, for the RSA database. The dbo user is mapped to the RSA_DBA login and RSA_USER will be mapped to the RSA_USER login.