Dynamics Community Forum Thread Details

I can't use FRX with replicated database

Hi,

I use Dynamics GP 10.0 and SQL Server 2005, i need to use SQL replication to Reporting Services, but I need to use FRX on the replicated database, I can access the replicated database from Dynamics and from Reporting Services, but on FRX asks meUser / Password over and over again.

Thank you

Hi Otto,

I'm not sure how the encrypted GP passwords will handle the replication. Is it possible to try one of the following?

1. Log into the replicated GP database with the username and password you are trying to use and confirm everything works there.

2. Try logging into FRx using SA which does not have an encrypted password and check functionality.

3. Reset the password for the individual user via SQL then check FRx. It should work. Then log into GP and reset the password there when prompted. Verify the ODBC for GP is something like gpserver, and the ODBC for FRx is in the same format and not different like gpserver.domain.com as this different format will cause decrypting of passwords to fail.

If all else fails you will have to run a SQL Profile when logging in to confirm it is a user password error and not something else that appears as a login error.

Quick Links

Leaderboard