Ok what am I doing wrong now.

The database is in place and I can see all the tables users etc in
enterprise manager.

I have a login called WebUserDSN. All of the permissions et etc are set as
per the development server.

Everything look sthe same ....

When I try to connect to the database via CFMX administrator to set the
ODBC connection I get the

                                                                            
       Connection verification failed for data source: WebUserDSN           
       []java.sql.SQLException: [Macromedia][SQLServer JDBC                 
       Driver][SQLServer]Login failed for user 'webuserdsn'. Reason: Not    
       associated with a trusted SQL Server connection.                     
       The root cause was that: java.sql.SQLException:                      
       [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user  
       'webuserdsn'. Reason: Not associated with a trusted SQL Server       
       connection.                                                          
                                                                            




error message. Now I used to get this all the time and fixed it on my
development server but can't remember what I did....
(See what being off sick does ...)

Regards - Paul




*************************************************************************************************
The information contained within this e-mail (and any attachment) sent by Birmingham 
City Council is confidential and may be legally privileged. It is intended only for 
the named recipient or entity to whom it is addressed. If you are not the intended 
recipient please accept our apologies and notify the sender immediately, or telephone 
+(44) 121 303 6666. Unauthorised access, use, disclosure, storage or copying is not 
permitted and may be unlawful. Any e-mail including its content may be monitored and 
used by Birmingham City Council for reasons of security and for monitoring internal 
compliance with the office policy on staff use. E-mail blocking software may also be 
used. Any views or opinions presented are solely those of the originator and do not 
necessarily represent those of Birmingham City Council. We cannot guarantee that this 
message or any attachment is virus free or has not been intercepted and amended.

*************************************************************************************************


-- 
These lists are syncronised with the CFDeveloper forum at 
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
 
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by 
activepdf.com*
      *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
           *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*

To unsubscribe, e-mail: [EMAIL PROTECTED]

Reply via email to