- VMware vSphere 5.1 Cookbook
- Abhilash GB
- 350字
- 2021-08-13 16:56:23
Creating a table space for SSO on a SQL instance
During the installation of Single Sign On, if you choose to use an existing supported database then you would have to manually create a table space for the SSO server's database.
By creating a table space, we are not creating a database schema (logical structure of the database). Instead, we are just creating storage locations of the database's primary and secondary data files and its transaction logfile.
In this recipe, I will show you the steps required to create a table space on an existing SQL Server database instance.
How to do it...
The following procedure will help you create a table space for the SSO server's database:
- Copy the
rsaIMSLiteMSSQLSetupTablespaces.sqlscript from the vCenter installation DVD to the database server. The location of the file is as follows:CD/DVD ROM :\Single Sign On\DBScripts\SSOServer\schema\mssql - At the database server machine, start the Microsoft SQL Server Management Studio and make sure that you are connected to the correct database server instance.
- Drag-and-drop the
rsaIMSLiteMSSQLSetupTablespaces.sqlfile to the SQL Server Management Studio. - Enter the hard disk location(s) for the database's primary data file (
RSA_DATA.mdf), secondary data file (RSA_INDEX.ndf), and the transaction logfile (translog.ldf).
Although the location(s) you specify is in a local location format, the files are created on the actual database server machine and not on the machine running the SQL Server Management Studio. In this example, I have used the location
C:\SSO; you need to make sure that theSSOfolder is already created on the database server'sC:\.Here is how the script would look after specifying the location for the files:
- Click on Execute to run the script on the database server instance.
How it works...
Once the query has executed successfully, there will be a database RSA listed under databases in the SQL Server Management Studio's inventory.
On the database server you will see three files created under the specified directory:
If you see three files (RSA_DATA.mdf, RSA_INDEX.mdf, and translog.ldf) at the specified location on the database server, then you have successfully created the table space for SSO.
- Puppet實戰
- 大學計算機應用基礎實踐教程（Windows 7+Office 2013）
- WordPress Mobile Web Development：Beginner's Guide
- Linux自動化運維：Shell與Ansible（微課版）
- Windows Server 2012網絡操作系統項目教程（第4版）
- iOS 8開發指南
- Windows 10從新手到高手
- Windows 7實戰從入門到精通（超值版）
- 從零開始學安裝與重裝系統
- 鴻蒙HarmonyOS手機應用開發實戰
- Java EE 7 Developer Handbook
- 15分鐘！畫出我的漫畫角色：賣萌篇
- Docker for Developers
- Selenium Framework Design in Data-Driven Testing
- Drupal 7 Mobile Web Development Beginner’s Guide