Dynamics GP 10 FRx 6.7 sp 9, 12 - FRx32.OFSIMain.CheckOFSIConnection

Error:
You try to login with a password, and no matter what you try, you get this error.
However, you can log in as sa with no issues.

FRx32.OFSIMain.CheckOFSIConnection
8900: FRx is unable to open a connection to the general ledger database because the login or password is incorrect. Verify your login and password, and then try again.

http://support.microsoft.com/kb/858323

Solution:
The login account must be an sql account with access to the company database and dynamics databases.
GP user accounts will not work.
You must create an SQL account, and give it access to the DYNAMICS and company databases manually.


When you first setup FRx, you must go into Admin>Organization>Admin password
and change the password from the blank default to a real password.
Once this is done, you can log in using this FRx Administrator account.
This does not give access to the companies, only to Administration options in FRx.
The only accounts that will work with the companies are SQL accounts that have access to DYNAMICS and the company database.

These must be set up manually.

Login to SQL Management Studio as sa
Expand Security>Logins>Right Click>New Login
Choose SQL server or windows, enter account name and password, disable policy, expiration and pw change.
On left, Select User Mapping. Tick Dynamics, in bottom pane tick DYNGRP, enter dbo for  default schema
Tick Company, in bottom pane tick DYNGRP, enter dbo for default schema
click OK
Restart FRx.
You can now login to FRx using this account.

Other Related Errors:

"Error getting Dynamics version number from table DYNAMICS..db_upgrade"

http://support.microsoft.com/kb/925651

Solution:
Once you have created an SQL user with access to the Dynamics and company databases, restart FRx.
This error should go away.