Frx login problems after Dynamics Upgrade
Justin Jones
I just applied the Frx Service pack 9 and 10. We just upgraded over the
weekend from Microsoft Dynamics SL 6.5 to Microsoft Dynamics SL 7.0.
I also tried to apply the suggestions from KB article 941591 no luck.
The problem is that we are unable to login to our Frx company. We are using
the new feature from Dynamics where we use the Windows Authentication on
Dynamics and I'm not sure if I need to do anything in the FRx to allow us to
get in.
The error I receive when we try the old way we used to login is
"The login failed for the [company ID] company. Make sure the login ID and
password are correct and verify the settings on the System Specific
Information page in Company Information"
under Detail we get
"FRX32.OFSIMain.CheckOFSIConnection
5: Unable to create RDO Environment. Please verify DSN information."
Any help would be great.
Thanks,
Justin Jones
Stephanie Hagan
Did you print preview a report in Dynamics SL to setup the ODBC drivers?
Thanks,
Stephanie
Kelly Bjella
I believe you have another thread open for this topic and I have replied to
that one. As Stephanie mentioned, it may be worthwhile to delete the
current ODBC's FRx is using and then do a Print Preview of a Trial Balance
report in SL which will automatically recreate these ODBC's.
Thank you,
Kelly Bjella
Microsoft Online Partner Support
======================================================
PLEASE NOTE:
The newsgroup SECURE CODE and PASSWORD will be updated on
August 20, 2007. Please complete a re-registration process by
entering the secure code mmpng2007 when prompted. Once you
have entered the secure code mmpng2007, you will be able to update
your profile and access the partner newsgroups.
======================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
--------------------
Thread-Topic: Frx login problems after Dynamics Upgrade
thread-index: AcjKeNCG22J+wjtpQEyUn8emJGD6eA==
X-WBNR-Posting-Host: 207.46.193.207
From: =?Utf-8?B?U3RlcGhhbmllIEhhZ2Fu?=
<Stephan...@discussions.microsoft.com>
References: <1956FF7C-6B79-4733...@microsoft.com>
Subject: RE: Frx login problems after Dynamics Upgrade
Date: Mon, 9 Jun 2008 14:36:02 -0700
Lines: 37
Message-ID: <44114A66-4C8A-43D4...@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.solomon
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.solomon:3752
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.solomon
Justin Jones
preview? I can't look at actual reaports b/c I can't login to the company.
Thanks
Justin Jones
Stephanie Hagan
Actually, if you log-in to Dynamics SL and print preview any report, it will
automatically setup the ODBC connections for you. You should then be able to
log-in to FRx and avoid the OFSI error. Here are my Cliff's notes version of
what I do in an FRx install/upgrade. There is a knowledge base on FRx for
Dynamics SL 7.0, but if I remember correctly, you may need to add the
Master60sp user to the database and/or reset the password in SQL. In 7.0
(prior to the SP), I know the synchronize ownership and security caused the
password to be inconsistent. Once I reset the password in SQL, some of my
errors went way. So, you might try that as well.
1. Print report to establish ODBC.
2. Run GL Index scripts.
3. You must set the Master Password in FRx. To do so…open company
information and click on the second tab. If you don’t see the field for the
Master password. Close the screen, open Admin – Organization screen and
close it. This sets FRx to “Admin” mode, then re-open the company
maintenance screen. The Master password should now be available. This needs
to be set equal to the Mater60sp user password for Solomon/SQL NOT the mater
password of the database.
Tons of information. Hopefully I wasn't too confusing.
Let me know what you find.
Stephanie
Daniel Sly
For the "FRX32.OFSIMain.CheckOFSIConnection 5: Unable to create RDO
Environment. Please verify DSN information." Please verify that the
Master60SP password is correct in both SQL and FRx Company | Information |
System Specific. After you have verified that the Master password is
correct, please re-run the SL script(s) which came with your Service Pack
of FRx. This should clear up any problems with this error
Thanks!
Dan Sly
Microsoft Online Partner Support
======================================================
PLEASE NOTE:
The newsgroup SECURE CODE and PASSWORD will be updated on
August 20, 2007. Please complete a re-registration process by
entering the secure code mmpng2007 when prompted. Once you
have entered the secure code mmpng2007, you will be able to update
your profile and access the partner newsgroups.
======================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
--------------------
Thread-Topic: Frx login problems after Dynamics Upgrade
thread-index: AcjLCfZx/IFEKWRgRX2FiAsyzgFg1A==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U3RlcGhhbmllIEhhZ2Fu?=
<Stephan...@discussions.microsoft.com>
References: <1956FF7C-6B79-4733...@microsoft.com>
<44114A66-4C8A-43D4...@microsoft.com>
<Ko6xwVqy...@TK2MSFTNGHUB02.phx.gbl>
<0ABB6AE2-40C3-4E95...@microsoft.com>
Subject: RE: Frx login problems after Dynamics Upgrade
Date: Tue, 10 Jun 2008 07:55:02 -0700
Lines: 132
Message-ID: <66B1277A-08DE-4F11...@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.solomon
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.solomon:3758