Another note - SQL 2000 running on Windows XP: As far as I've experienced, integrated login doesn't work under Windows XP pro. I had to set up mixed authentication and a separate SQL account in order to get Coldfusion to connect.
Just my little experience, Micky -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Kelly Sent: Monday, March 08, 2004 12:51 PM To: [EMAIL PROTECTED] Subject: Re: SQL Server connection Thanks Matt! Set SQL Server to mixed authentication, used "sa" as username in CF Admin DSN, and that which did not work before, does now! Still can't get the JDBC option to work, but the issue is moot now. Good check list! Thanks for the help Matt & Isaac! Take notes fellow MS SQL Server Admin rookies! Joe Kelly ----- Original Message ----- From: "Matthew Woodward" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 08, 2004 7:38 AM Subject: Re: SQL Server connection > Hopefully I'm not restating things you've already tried, but here are some > things to check: > > 1. Make sure SQL Server is set to use either SQL Server authentication only > or mixed authentication > > 2. They fixed this in 6.1, but in 6.0 there was an issue with password > length--I think the limit is 16 characters. The administrator would let you > enter a password longer than 16 characters but it would truncate it and not > tell you, so if your password was longer than 16 characters it would just > create a login failure with no other explanation. > > 3. Make sure your ports are correct. If you use instances in SQL Server > 2000, SQL Server more or less randomly assigns ports for instances other > than the default instance. > > 4. If you have the SQL Server driver still in its jar file, make sure the > full path to the jar file *including the name of the jar file itself* (e.g. > "X:\path\to\jar\mssqlserver.jar") is in your classpath. Just putting the > name of the directory in which the jar file resides won't cut it. > > 5. There are multiple jar files distributed with the SQL Server JDBC driver > (3 to be exact). Make sure they are all in your classpath as indicated > above. > > 6. Try creating another database and explicitly setting a user name and > password; then at least you'll know if there's just something messed up with > your Northwind database if another database works. > > HTH, > Matt > > ------------------------- > Matthew P. Woodward > [EMAIL PROTECTED] > > ----Original Message Follows---- > From: "Joe Kelly" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: <[EMAIL PROTECTED]> > Subject: Re: SQL Server connection > Date: Sun, 7 Mar 2004 23:34:11 -0600 > > The "Class Path" for the driver is set on "Java and JVM" page in > Administrator. Choosing "other" for driver in "Data Sources" and using the > JDBC driver, produces this: > > Connection verification failed for data source: NorthWind > []java.sql.SQLException: No suitable driver available for NorthWind, please > check the driver setting in resources file, error: > com.microsoft.jdbc.SQLServerDriver > The root cause was that: java.sql.SQLException: No suitable driver available > for NorthWind, please check the driver setting in resources file, error: > com.microsoft.jdbc.SQLServerDriver > ----- > SQL Server driver produces this: > > Connection verification failed for data source: NorthWind > []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login > failed for user '(null)'. 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 '(null)'. Reason: Not associated > with a trusted SQL Server connection. > > same error above for an Administrator as a user too. > > Thanks, > Joe Kelly > > > ----- Original Message ----- > From: "S.Isaac Dealey" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, March 07, 2004 11:11 PM > Subject: Re: SQL Server connection > > > > I use the SQL Server Driver ... although I've had problems with them > > in the past... They seem to have had more problems with JDBC drivers > > than with almost anything else since moving to J2EE from CF5. The ODBC > > Socket, while it works, isn't very desirable because even on the Sun > > website they say that the ODBC Socket drivers are a "workaround" and > > shouldn't be used except as a last resort. Iirc the ODBC Socket also > > doesn't allow you to use some of the metadata features of JDBC (which > > are included in the onTap framework). > > > > Though lately I've been able to get the JDBC drivers that came with > > Red Sky to work fine. > > > > What kind of issues are you having with the JDBC drivers for SQL > > Server anyhow? > > > > > > > In CF Administrator > Data Sources > > > Does anybody use the "Microsoft SQL Server" driver? > > > I can't connect w/ this driver. I have to set up an ODBC > > > connection the SQL Server db and then use the "ODBC > > > Socket" driver. All the tech notes say to use this > > > workaround. Any ideas? This doesn't seem very efficient > > > to me. > > > > > Here's what I'm running all on the same box: > > > cfmx 6.1 > > > windows 2000 adv server > > > MS SQL Server 2000 > > > SQL Server 2000 Driver for JDBC Service Pack 2 > > > > > Thanks, > > > Joe Kelly > > > > > > > > s. isaac dealey 214.823.9345 > > > > new epoch : isn't it time for a change? > > > > add features without fixtures with > > the onTap open source framework > > http://www.turnkey.to/ontap > > > > > > ----------------------------------------------- > > To post, send email to [EMAIL PROTECTED] > > To unsubscribe: > > Send UNSUBSCRIBE to [EMAIL PROTECTED] > > To subscribe / unsubscribe: http://www.dfwcfug.org > > > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > Send UNSUBSCRIBE to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org > > _________________________________________________________________ > Create a Job Alert on MSN Careers and enter for a chance to win $1000! > http://msn.careerbuilder.com/promo/kaday.htm?siteid=CBMSN_1K&sc_extcmp=JS_JA Sweep_MSNHotm2 > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > Send UNSUBSCRIBE to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org > ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
