Ernie, The best success in changing the SMPOLICY database is to play with the SMCONSOLE.
Here are few things we have checked to get spectra work using a different SMPOLICY. The TCP Port number for the database to match the one on your source you are connecting. I am assuming you change the DSN through the windows control panel. And the user name password can still be different through the SMCONSOLE. I have had few troubles with this one before. If your TEST ODBC (ODBC TAB) from the SMCONSOLE doesn't work, then use the DEBUG tab and make more logs. The other could be that use IP address rather than a DNS/WINS name for the database when you create the DSN. GOOD LUCK. -----Original Message----- From: Ernie Pena [mailto:epena@;mdaisd1.mdacc.tmc.edu] Sent: Thursday, October 24, 2002 9:36 AM To: Spectra-Talk Subject: Re: WHY! Chris, Well here is the deal with the logs, I did turn them on and just didn't really reveal much other that is was listening for the response. No real indication of any problems other than its waiting for a response from the server. However if I change the DSN for the smpolicy and point it to the one that it created it works fine. But I need it to work with the other smpolicy that the main server is using. Let me explain what I want to do, I want to use a centralized userdirectory and smpolicy for all my spectra servers. We create a development box and a box that is viewed by the public. Is their a way to do this? EP! ----- Original Message ----- From: "Chris Hiester" <[EMAIL PROTECTED]> To: "Spectra-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 2:13 PM Subject: RE: WHY! Hi Ernie, What errors are you getting connecting from the servers that don't work? Can you turn on Siteminder's logging capabilities (via smconsole.exe) and post the logs? They will usually reveal where it is breaking. --Chris --Christopher Hiester Sr. Product Support Engineer Certified ColdFusion MX Developer Macromedia, Inc. [EMAIL PROTECTED] http://www.macromedia.com/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at: http://www.macromedia.com/go/devcon2002 -----Original Message----- From: Ernie Pena [mailto:epena@;mdaisd1.mdacc.tmc.edu] Sent: Tuesday, October 22, 2002 2:43 PM To: Spectra-Talk Subject: WHY! Ok here is what I've done and is working on two other servers quit simular. Server Hardware Config Info: Compaq 380's 1 gig or ram 80 gig's of storage Server Software Config Info: Windows 2000 Server Coldfusion 4.5 migrated to Coldfusion 5 Spectra 1.0 migrated to 1.01 All the Updated associated with the migration. Now here is the problem, I have 4 boxes with this very config, 2 of which talk to the same userdirectory and smpolicy tables on the same database (SQL Server 7). Now here is my problem I have two other boxes configured the same way however, these boxes will not talk to the same userdirectory and smpolicy tables. How can I have a centeral place for the users and smpolicies? I want all four boxes reading from one userdirectory and smpolicy tables, is this possable? if how. Thanks in advanced Ernie Pena U.T. M. D. Anderson Cancer Center. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ 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.
