FRx 6.7 is asking for Database credentials when set up on Win 7 Pro, 64 bit machines.
Hi. We have an existing AX 2009 implementation, using FRx 6.7. FRx is working fine with all our existing workstations, which are Win7 32bit.
However, we have two new laptops running Win7 64bit OS. FRx is exhibiting the same problem on both. When we go to run Report Designer, after configuring the odbcad32 connections to the SQL server (prompting for Windows Authentication), upon selecting the company to run the report in, we are prompted with a 'Database Login for XYZ Company'.
I have verified that this isn't a user setup issue by logging onto a working workstation with the new user's credentials -- FRx runs fine. I can also log into the new user's 64bit system with my credentials, and FRx fails with the same database login error.
Does anyone have any insight as to why this is happening? It seems like FRx isn't passing the user credentials to the AX/SQL systems, but I cannot figure out why the issue seems to be limited to the new 64bit systems.
Scott
However, we have two new laptops running Win7 64bit OS. FRx is exhibiting the same problem on both. When we go to run Report Designer, after configuring the odbcad32 connections to the SQL server (prompting for Windows Authentication), upon selecting the company to run the report in, we are prompted with a 'Database Login for XYZ Company'.
I have verified that this isn't a user setup issue by logging onto a working workstation with the new user's credentials -- FRx runs fine. I can also log into the new user's 64bit system with my credentials, and FRx fails with the same database login error.
Does anyone have any insight as to why this is happening? It seems like FRx isn't passing the user credentials to the AX/SQL systems, but I cannot figure out why the issue seems to be limited to the new 64bit systems.
Scott
ASKER
Sorry if this isn't exactly what you are looking for (I am new to FRx), but we are running Release 6.7.11027.
The service pack file is labeled FRx6711027.exe.
It may be R11? (I see R11 Release notes in teh zip file the SP came in)...
The user trying to run FRx has standard domain user privileges, but the problem is the same on the new machines whether I run FRx with her user account, a working user account, or the domain admin.
The service pack file is labeled FRx6711027.exe.
It may be R11? (I see R11 Release notes in teh zip file the SP came in)...
The user trying to run FRx has standard domain user privileges, but the problem is the same on the new machines whether I run FRx with her user account, a working user account, or the domain admin.
Please try executing Report Designer as Administrator; Right-click it and select "Run as Administrator".
ASKER
sorry for the delay in replying...
running as administrator doesn't change the symptoms.
I have checked the dynamics blogs, and found that FRx 6.7 isn't supported on 64 bit clients. There are many who say that they have managed to make them work, but no information on the workarounds.
Any thoughts?
running as administrator doesn't change the symptoms.
I have checked the dynamics blogs, and found that FRx 6.7 isn't supported on 64 bit clients. There are many who say that they have managed to make them work, but no information on the workarounds.
Any thoughts?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry.. no... FRx newbie.
I will uninstall and reinstall using the directions you sent. The only main change would be to run the odbcad32 connector as administrator, but honestly, that seems to be where the issue lies, so that may be what I need.
I will post the results back tomorrow.
Thanks!
I will uninstall and reinstall using the directions you sent. The only main change would be to run the odbcad32 connector as administrator, but honestly, that seems to be where the issue lies, so that may be what I need.
I will post the results back tomorrow.
Thanks!
Did you run FRx installation file using "Run as Administrator" before?
ASKER
I did... I didn't install the odbcad32 connector running as administrator though. I am going to go through, uninstall everything, and attempt it once more using the document you linked to above.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry to everyone for the delay in my response.
Thanks for the added comments, victoria. I still haven't sorted out what is going wrong with our installations.
Your comment on using the 32-bit ODBC connector got me interested, but I can confirm that I am using odbcad32.exe to build the connections to SQL. What is odd though is that when I run odbcad32 from the 32bit Win7 workstations, there are a TON of options available when I click 'Add' under the SystemDSN tab--however, when I do the same thing using odbcad32.exe on the 64bit win7 workstations, I am only presented with SQL Server...
Regardless, time wasn't on my side to resolve the issue, so instead we installed Management Reporter, and have migrated our reports to it.
I thank you both for your assistance!
Thanks for the added comments, victoria. I still haven't sorted out what is going wrong with our installations.
Your comment on using the 32-bit ODBC connector got me interested, but I can confirm that I am using odbcad32.exe to build the connections to SQL. What is odd though is that when I run odbcad32 from the 32bit Win7 workstations, there are a TON of options available when I click 'Add' under the SystemDSN tab--however, when I do the same thing using odbcad32.exe on the 64bit win7 workstations, I am only presented with SQL Server...
Regardless, time wasn't on my side to resolve the issue, so instead we installed Management Reporter, and have migrated our reports to it.
I thank you both for your assistance!
ASKER
problem not resolved, but through no fault on the part of the responders. am closing the question and moving on... thank you for your responses!
What're the privileges of the Windows user running the FRx Designer? Can you try it with Administrator?