Error message when you try to start Microsoft Dynamics GP: "You are attempting to log in from a data source using a trusted connection"

Resolution 1

Method 1: If you use MSDE 2000

1. Click Start, click Run, type cmd, and then click OK.
2. Type the following command at the command prompt:
   osql –S server_name –E
   Note In this command, Server_Name represents the actual name of the server.
3. MSDE 2000 requires Windows Authentication. To determine the authentication mode that was installed, type the following commands at the command prompt. Press ENTER after you type each command.
   SELECT
   case
   when serverproperty('IsIntegratedSecurityOnly') = 1 then 'Windows Only'
   when serverproperty('IsIntegratedSecurityOnly') = 0 then 'SQL and Windows'
   end
4. If the returned value is Windows Authentication only, change the authentication mode to both Windows Authentication and SQL Server Authentication by changing the LoginMode registry value. To do this, use one of the following methods.
   Note Instead of performing all of step 4, you can reinstall MSDE 2000, and then select both Windows Authentication and SQL Server Authentication during the installation.
   • Use registry editor
     
     Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
     1. Click Start, click Run, type regedit, and then click OK.
     2. Locate and then click the following registry subkey:
        
        
        HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\INSTANCE\MSSQLServer
     3. In the details pane, double-click LoginMode.
     4. In the Value data box, type 2, and then click OK.
   • Use the osql command
     1. Click Start, click Run, type cmd, and then click OK.
     2. At the command prompt, Type the following command. Then press ENTER.
        
        
        osql –S Servername –E
     3. After you log in, type the following command at the command prompt, and then press ENTER:
        xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', 'LoginMode', N'REG_DWORD', 2
        
        
        If you have multiple instances of MSDE 2000 running, type the following command instead:
        
        
        xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\Microsoft SQL Server\INSTANCE\MSSQLServer', 'LoginMode', N'REG_DWORD', 2
        Notes
        • In these commands, INSTANCE represents the actual name of the instance of SQL Server.
        • In the registry, the LoginMode registry subkey can have the following values:
          • 1: Windows Authentication
          • 2: mixed mode (Windows Authentication and SQL Server Authentication)
     Notes
     • You must restart the computer for the changes to take effect.
     • These steps can be done more easily by modifying the registry instead of using the osql command.

Method 2: If you use SQL Server 2000, SQL Server 2005, or SQL Server 2008

1. Follow the steps for your version of SQL Server:
   • For SQL Server 2005 or SQL Server 2008
     
     Start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005 or to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
   • For SQL Server 2000
     
     Start SQL Server Enterprise Manager. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager
2. Right-click the server name, and then click Properties.
3. Click the Security tab.
4. Determine Check whether this instance of SQL Server uses only Windows Authentication or instead uses both SQL Server Authentication and Windows Authentication.

Resolution 2

1. Open the ODBC Data Source Administrator window. To do this, click Start, click Run, type odbcad32.exe, and then click OK.
2. Click the System DSN tab.
   
   
3. Click to select the System DSN that is used to access Microsoft Dynamics GP, and then click Configure.
4. Click Next.
5. Make sure that the With SQL Server authentication using a login ID and password entered by the user option is selected.
6. In the Login ID field, Type sa. In the Password field, type the password. Then, click Next.

Resolution 3

1. Open the User Setup window. To do this, follow these steps:
   • In Microsoft Dynamics GP 10.0
     
     On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click User.
   • In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0
     
     On the Tools menu, point to Setup, point to System, and then click User.
2. In the User ID field, click the lookup button, click to select the user who is experiencing the problem, and then click Select.
3. In the Password field, type the password. Then, click Save.