Error message when you try to log on to Microsoft Dynamics GP: "A get/change first operation on table 'SY_Users_MSTR' (45)"

When you try to log on to Microsoft Dynamics GP or to Microsoft Business Solutions - Great Plains, you receive the following error message:If you click More Info in the dialog box that contains the error message, the following error information is displayed:

This problem occurs if the DYNAMICS database is set to restrict access to only one user.

To resolve this problem, use one of the following methods, depending on which version of Microsoft SQL Server you are running:

Method 1: For Microsoft SQL Server 2000

1. On the computer that is running SQL Server 2000, start the SQL Server Enterprise Manager tool.
2. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the instance of SQL Server on which the DYNAMICS database is stored.
3. Expand Databases, right-click DYNAMICS, and then click Properties.
4. Click the Options tab.
5. Click to clear the Restrict access check box, and then click OK.
6. To make sure that the company database is not set to restrict access, repeat steps 3 through 5 for the CompanyDatabase.
7. Exit the SQL Server Enterprise Manager tool.

Method 2: For Microsoft SQL Server 2005 or Microsoft SQL Server 2008

1. On the computer that is running SQL Server 2005 or Microsoft SQL Server 2008, start Microsoft SQL Server Management Studio.
2. Connect to the instance of SQL Server on which the DYNAMICS database is stored.
3. Expand Databases, right-click DYNAMICS, and then click Properties.
4. In the Database Properties dialog box, click Options.
5. In the State area, click Multiple in the Restrict Access list.
6. Click OK.
7. To make sure that the company database is not set to restrict access, repeat steps 3 through 6 for the CompanyDatabase.
8. Exit Microsoft SQL Server Management Studio.

Method 3: For Microsoft SQL Server Desktop Engine (also known as MSDE 2000)

1. On the computer that is running MSDE 2000, start the Support Administrator Console.
   
   Note To install the Support Administrator Console, run the Setup program from Microsoft Dynamics GP installation disc 2. In the Setup program, click Install Support Administrator Console. You can also download the Support Administrator Console. To download the Support Administrator Console, visit the following Microsoft Web site:
   https://mbs.microsoft.com/customersource/support/downloads/servicepacks/sa_console.htm?printpage=false
2. Connect to the instance of MSDE on which the DYNAMICS database is stored.
3. In the list on the toolbar, select master.
4. Copy the following script to the New Query box.

   ALTER DATABASE DYNAMICS SET MULTI_USER

5. On the toolbar, click the green arrow button. Or, press F5.
6. Copy the following script to the New Query box.

   ALTER DATABASE <Company_database> SET MULTI_USER

   Note In this script, replace the Company_database placeholder with the name of the company database.
7. Run the script.
8. Exit Support Administrator Console.