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:

1. Log on to the tier that is running MySQL.


2. Open a command window.


3. Change directories to the MySQL bin directory (typically <c:\mysql\bin>).


4. 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
   

5. 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.



6. Enter the following line into the command-window:

   UPDATE sassdm.sas_user_actions SET USER_IDENTIFIER = 'sasdemo' where USER_IDENTIFIER='SAS Demo User';

7. 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.


8. Type "quit <RETURN>" to exit the MySQL command-line


9. Close the Command Window




Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
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