If you logon to Great Plains 8.0 or 9.0 and get this message:
"You're attempting to log in from a data source using a trusted connection. Update the SQL Server settings for this data source to disable trusted connections and try logging in again"
This turns out to be a known Great Plains issue. If the account name is all lower case: jsmith and you attempt to logon with JSmith you will get the above mis-leading message.
The following Microsoft Dynamics Knowledge Base article may of interest to you.
ArticleID: 913339.
Error message when you log in to Microsoft Dynamics GP after you update from an earlier version or service pack: 'You're attempting to log in from a data source using a trusted connection. Update the SQL Server settings for this data source'
SYMPTOMS
When you log in to Microsoft Dynamics GP 9.0 or to Microsoft Business Solutions - Great Plains 8.0 with Service Pack 4a for the first time after you update from an earlier version or after you install a service pack, you are prompted to change the password. When you change the password, you receive the following error message:
You're attempting to log in from a data source using a trusted connection. Update the SQL Server settings for this data source to disable trusted connections appears
CAUSE
This problem occurs because the user ID contains uppercase letters. However, you entered all lowercase letters.
RESOLUTION
To resolve this problem, use one of the following methods.
Method 1
To resolve this problem, follow these steps:
1. Start Microsoft Dynamics GP 9.0 as the sa user.
2. On the Tools menu, point to Setup, point to System, and then click User.
3. In the User ID box, click the lookup, highlight the user who is experiencing this problem, and then click Select.
4. In the Password box, re-type a password, and then click Save.
Method 2
To resolve this problem, follow these steps:
1. Start Microsoft Business Solutions - Great Plains 8.0 as the sa user.
2. On the Tools menu, point to Setup, point to System, and then click User.
3. In the User ID box, click the lookup button, highlight the user who is experiencing this problem, and then click Select.
4. Verify that the correct user ID is being used to login. Then re-enter the user password.
5. Click Save.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
________________________________________
APPLIES TO
• System Manager, when used with:
Microsoft Dynamics GP 9.0
Microsoft Business Solutions–Great Plains 8.0
Keywords: kbmbsupgrade kbmbspartner kberrmsg kbbug kbmbsmigrate kbprb KB913339