Jorgen,
Did you have the username/password set under ODBC tab in smconsole.exe?
The connection will verify OK, but the authorization will fail if the un/pw
is not set. This is just like the ODBC control panel unfortunately - the
best way to verify a connection is to do it from the CF admin odbc page
because it requires the password. smconsole and odbc manager just basically
ping the database, they don't actually try to connect.
Let me know if this was the case or not and we'll work through it. I have
been able to get CF 5.0 working with both spectra 1.5 and 1.5.1 on NT, 2000
and solaris so stick with it!!
regards,
peter watson
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 7:42 PM
To: Spectra-Talk
Subject: RE: CF5 install - can't login to Webtop
On Wed, 02 May 2001, "Raymond Camden" wrote:
> ********************** Macromedia Representative **********************
> Check the docs. I _believe_ there is a doc on migrating 4.x security
policy
> crap.
>
> Or just make a new security context for SC1, Userdirectory, etc. Shouldn't
> take more than a few seconds.
>
> While your there, don't forget to upsize the security policy db.
Myself I did all that - created a new smpolicy db, set up siteminder to work
with it, verified connection, reimported users, synchronized the password.
With Win2Ksp1 workstation, SQL7.0, I got the following siteminder error
message. Even though I could verify the connection to the UDs through the
ODBC interface, for some reason SM didn't want to send along username and
password.
My Siteminder experience being quite limited, I guess I must have been
missing something quite obvious ... soI found myself having to reinstall
4.5.1sp2 to get back to work.
------------
[01/May/2001:19:34:12 1000][980-SmServAuth-Authenticate] Username 'jorgen'
in realm 'Security'
[01/May/2001:19:34:12 1000][980-SmDs] Directory 'jorgen_UserDirectory'
[01/May/2001:19:34:12 1000][980-E] Failed to connect to an ODBC data source
'jorgen_userdirectory'. [Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user '\'.. Error code -1
[01/May/2001:19:34:12 1000][980-E] Failed to connect to any of the following
data sources: 'jorgen_userdirectory'.
[01/May/2001:19:34:12 1000][980-SmAuthUser] Directory 'jorgen_UserDirectory'
can not be contacted
------------
I guess it's more of a CF5RC thing than a Spectra one, but my primary reason
for trying the CFAS5RC was to see if I could get current Spectra apps to
work and then to get a feeling for the performance improvements. I've also
incurred some massive memory leaks in CF4.5.1sp2 parsing a set of biggie
biggie text files (45 MB each, total set of 150 MB), so there was that too
.... and the sweet promise of CF scripting functions. :)
Regards,
J�rgen
--
Temporary Australian Funkdancer. Mobile: 0409 012 484.
212 million years of CF coding experience in 98 dimensions.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.