Installation Note 37794: Post-migration steps required for SAS® Strategy Management
The permissions for the "SAS Demo User" (sasdemo) account must be modified in the
following manner for that user to be able to access SAS Strategy Management content after a migration from release 2.4 to release 5.1 OR to release 5.2:
- Log on to the tier that is running MySQL.
- Open a command window.
- Change directories to the MySQL bin directory (typically <c:\mysql\bin>).
- Start the MySQL command-line:
mysql -h{HOST} -u{USERID} -p{PASSWORD}
where:
{HOST} = the host on which MySQL is running
{USERID} = the user name used to administer MySQL (the default userid is sqladmin)
{PASSWORD} = the password associated with the above USERID
- List the records where SAS Demo User is the USER_IDENTIFIER:
SELECT * FROM `sassdm`.`sas_user_actions` where USER_IDENTIFIER='SAS Demo User';
If NO rows/records are returned, no further steps are required in this section. Continue to the next section in the Migration documents; that is, you do not need to perform any of the following steps in this SAS Note.
If there are rows/records returned, continue to Step 6.
- Enter the following line into the command-window:
UPDATE sassdm.sas_user_actions SET USER_IDENTIFIER = 'sasdemo' where USER_IDENTIFIER='SAS Demo User';
- Verify that the update has been done by running the SQL code in Step 5:
SELECT * FROM `sassdm`.`sas_user_actions` where USER_IDENTIFIER='SAS Demo User';
The above query should return "Empty set". If it does not, please contact SAS Technical Support.
- Type "quit <RETURN>" to exit the MySQL command-line
- Close the Command Window
Operating System and Release Information
| SAS System | SAS Strategy Management | Microsoft® Windows® for x64 | 5.1 | | 9.2 TS2M2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 5.2 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 5.2 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Standard Edition | 5.2 | | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 for x64 | 5.2 | | 9.2 TS2M3 | |
| 64-bit Enabled AIX | 5.2 | | 9.2 TS2M3 | |
| 64-bit Enabled Solaris | 5.2 | | 9.2 TS2M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The SAS Demo User account must be modified in the SASSDM for that user to be able to access SAS Strategy Management content after migrating from release 2.4 to 5.1 OR from release 2.4 to 5.2.
| Type: | Installation Note |
| Priority: | high |
| Date Modified: | 2010-09-13 14:01:24 |
| Date Created: | 2009-11-11 11:14:30 |
