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_JASweep_MSNHotm2
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
