APPENDIX

This section offers tips and information that is useful to the process of migrating the system or databases to the new server.

 

 

 

 

HOW TO CREATE A USER_LOGIN ACCOUNT (IDPRODUCER DATABASE )

This topic covers creating a new user_login account for the idProducer database.

 

REQUIREMENT ...

• In SQL Server Management Studio (SSMS), you must log-in to the ‘GCSSQLEXPRESS’ instance.

 

1. Open SQL Management Studio software using the Windows Search field on the taskbar.

2. Log in to Galaxy’s GCSSQLEXPRESS instance using SQL Authentication and the Dealer’s default SA Login.

   1. Select Database Engine for Server Type.

   2. Select the correct Server Name

      (machine_name\instance_name)

   3. Select SQL Server Authentication type.

   4. Enter the “sa” login and the password.

   5. Click Connect to connect to the GCSSQLEXPRESS instance and its databases.

      

        SSMS: SQL Server Login window

       

3. Expand the Security branch under the GCSSQLEXPRESS instance.

4. Right-click on Logins branch and select New Login from the shortcut menu.

   

   SMSS: Object Explorer Security > New Login menu option

    

5. Create the idProducer User Account as follows ...

6. Enter the User Name you wish to use (the username in the screenshot is just an example)

7. Select SQL Server Authentication button.

8. Enter a password in the Password field.

9. Re-enter the password in the Confirm Password field.

    

   

   SMSS: General screen > Creating SQL Login

    

10. Select the User Mapping screen.

11. Enable (check) the idProducer database in the list at the top of the screen.

12. Enter the same Login Name in the User column that entered in the General screen (if needed).

13. Enter “dbo” in the Default Schema column.

14. Enable (check) the following roles in the Membership Roll list

    • db_backupoperator

    • db_datareader

    • db_datawriter

    • public

       

15. Click OK to create the user account.

    

     

16. The user login account is added to both Engine Logins branch and Database Users branch …

    • the GCSSQLEXPRESS > Security > Logins branch.

    • the GCSSQLEXPRESS > Databases > idProducer Security>Users branch.

      

      SMSS: Object Explorer > idProducer database Users branch shown

       

 

 

VIEW ‘IIS_IUSERS’ FOLDER PERMISSIONS ON THE NEW SERVER

If you are having problems with performance in the Badging Client, verify the IIS_IUSERS permissions are set for Full Control on the new server.

 

1. Insert the System Galaxy Install Media (USB/ISO) splash screen by clicking SGSetup.

2. Click the Install idProducer option to open the Install Configuration Helper (shown below).

3. Click the [ View Folder Permissions ] button on the GCS idProducer Install Helper window.

   

    

4. Select the Security tab, in the Properties window.

5. Scroll down and select (highlight) the IIS_IUSRS name in the Group listview.

6. Verify that the Permissions listview shows “Full Control” is allowed (is checked); and all permissions under it are also checked.

7. (if needed) You can click the Edit button and enable the permissions as appropriate, and click Apply to save.

   

8. Click OK to close the WebClient Properties window.

 

 

HOW TO VERIFY GCS USER LOGINS ARE DELETED AND RECREATED

If user logins are not created or the permissions are not enabled, you can manually create and enable them.

If the GCS User Logins and permissions are not correctly added, the symptoms will be problems getting services to run and unable to start System Galaxy.

 

1. Verify the GCS User Logins are deleted as follows …

   1. Select (highlight) the Databases branch and click Refresh button.

   2. Navigate to the Security>Users branch of the SysGal database.

   3. Verify that the gcs_client and gcs_web_client are deleted (not present).

   4. Repeat these steps for the SysGalArc database.

       

2. Create gcs_client logins as follows …

   1. Expand the Instance level and navigate to Security > Logins branch.

   2. Double-click on the gcs_client to open it in the Properties window.

   3. In the User Mappings screen, select (“check”) the SysGal database and type “dbo” into the Schema field.

   4. On the bottom half of the screen, enable (“check”) the permissions (i.e., db_reader, db_writer, db_backupoperator). And public should be already checked.

   5. Click OK to save and add this user and permissions to the database level.

   6. Repeat these steps to add gcs_client user to the SysGalArc database.

       

3. Create gcs_web_client logins as follows …

   1. Expand the Instance level and navigate to Security > Logins branch.

   2. Double-click on the gcs_web_client to open it in the Properties window.

   3. In the User Mappings screen, select (“check”) the SysGal database and type “dbo” into the Schema field.

   4. On the bottom half of the screen, enable (“check”) the permissions (i.e., db_reader, db_writer, db_backupoperator). And public should be already checked.

   5. Click OK to save and add this user and permissions to the database level.

   6. Repeat these steps to add gcs_web_client user to the SysGalArc database.

       

4. Verify the client logins were correctly added to both databases as follows ...

   1. Refresh the Databases branch and navigate to the Security>Users branch of the SysGal database.

   2. Double-click the gcs_client login to open the Properties window; then verify that the correct permissions are enabled(checked) in the Membership Roles screen (i.e., db_reader, db_writer, db_backupoperator, and public should be checked).

   3. Double-click the gcs_web_client login to open the Properties window and verify that the correct permissions are enabled(checked) in the Membership Roles screen(i.e., db_reader, db_writer, db_backupoperator, and public should be checked).

   4. Repeat these steps for the SysGalArc database for both the gcs_client and gcs_web_client logins.

 

 

HOW TO DOWNLOAD & INSTALL VISUAL C++ FILES

This section is required only if you need to install the newer version of VC++ Redistributable files before publishing the idProducer database.

 

1. Open your web browser and go to the Galaxy Dealer Support web page www.galaxysys.com/support  (dealer login needed).

2. Scroll down to the “Miscellaneous” section of the Support page.

3. Click on “Microsoft Visual C++ Redistributable for Visual Studio v14.3X”.  The zip file should download to your Download folder.

   

   Galaxy website > Support page > Miscellaneous links (scroll down to find)

    

4. Open your Download folder and extract the VC++redist.exe files from the zip folder.

   1. Double-click on VC_redistx86.exe to run the x86 install.  Close when finished.

   2. Double-click on VC_redistx64.exe to run the x64 install. Close when finished.

       

5. Restart the computer to initialize the newly installed C++ modules.

6. Return to the section for publishing the idProducer database. The database should be able to upgrade and or publish without errors.