Great Plains - You're attempting to log in from a data source using a trusted connection

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

Unable to copy files to Vista, Win7, Win2008

I have a VM running on a VMWare 2.0 host. The VM is running Windows 2008 SP2 x86. If I am logged on the VM and I try to copy a file/files to it, I receive the following error:

"Network Error: There is a problem accessing [insert name of file you are copying]. Make sure you are connected to the network and try again"

This is a frustrating one because if you try to resolve it by doing what most people do and that is to search "Bing, Google, Yahoo" for such phrases as : "Network Error: There is a problem accessing" or "Make sure you are connected to the network and try again" you will get led down many wrong paths; i.e. UAC, anti-virus client, firewall issue, domain credentials, etc. (But hopefully you will get this blog first).

I remember I ran into this issue on a Windows 2003 server previously and the fix was to go into Add Remove programs and make sure that IE ESC was cleared for Administrators.

So, from experience, the first thing I checked was that this was not turned on for Administrators on this Windows 2008 server:

So I tried copying over the file again and got the same error message: "Network Error: There is a problem accessing [insert name of file you are copying]. Make sure you are connected to the network and try again".

Hmm, I'm quite sure that this was the fix, but then I noticed that when I opened IE 8 I could see that IE ESC was not really turned off.  I guess that a group policy has been applied to lock this down.

I had to go to the next step and open IE Options: go to Internet Options, click on the "Security" tab and click on the "Local Intranet" icon and then click the "Sites" button, and then click "Advanced". Add the file server name to the list with this format:

\\servername or file://servername/ or domain-wide file://*.domain.com/

Try your copy now and it will work.

For security reasons you should probably re-enable IE ESC.