When you log on to Microsoft Dynamics GP after you have migrated to Microsoft SQL Server 2005 from Microsoft SQL Server 2000 with a different server name you receive the following error message:
A Get/Change First Operation on Table coProcess failed Accessing SQL Data
Additionally, if you click the More Info button, you receive the following message:
[Microsoft][SQL Native Client][SQL Server] The server principal “XXXX” is not able to access the database “XXXX” under the current security context Microsoft ODBC XXXX is not valid user.
The passwords for Microsoft Dynamics GP are encrypted based on the server name used in the ODBC connection. If the server name is different, the passwords will be encrypted differently. Because of this, if you move to a server with a different name you passwords will no longer be valid. This will cause these errors.
In order to resolve this error, you will need to change your user’s passwords. You may do this by manually changing the user’s passwords through method 1 or by allowing them to set up a new password upon login through method 2.
Log in to Microsoft Dynamics GP as sa user.
On the Tools menu, click
Setup, and then click User.
Click the Lookup button next to User ID and select the appropriate user.
In the password fields, enter a new password.
Log into SQL Management Studio and expand the Security folder in ‘Object Explorer’
Expand the Logins folder.
Right click on the appropriate Login and go to ‘Properties’
Remove the passwords from both password fields.
In SQL, click on DATABASES | COMPANY |SECURITY | USERS and right-click on the user and click DELETE. Then one folder up in SQL, click on SECURITY | LOGINS |right-click on the user and selct PROPERTIES | USER MAPPING. Give them access to the Company database and the DYNGRP role. This will insert them back into the company users folder again with permissions so they can sign in successfully now.