Have u A) created a separate DSN poitning to the new server B) created the same user/password on the new SQL server C) assigned that user to the database
Russ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 04 May 2004 15:04 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL 2k Database Transfer > > > 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] > -- 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]
