Hi Guys, My guess was that the JDBC driver was current in OpenBD. I was able to use the JDBC connection with OpenBD 1.3 out of the box, at least, connecting to SQL 2000. Since I'm able to connect to SQL 2008, and am only getting a "login failed" error, I'm pretty sure this is an authentication issue. If I change the IP to an invalid IP, I actually get a "failed to connect/connection timed out" error versus just a failed login error.
On SQL 2000, I'm using Windows Authentication only. The 'openbd' login I am using is the Windows User account. I have it mapped to a login in SQL 2000, and that login added as a user to each database. From what I've read, you almost always want to avoid SQL Server authentication if possible, and use Windows Authentication only. This is what I'm doing. I'm trying to create a Windows Account for OpenBD, and creating a login in SQL server for that account. So I need to figure this out using Windows Authentication..... It already works for me with SQL 2000 Server.. Does anybody have a SQL 2008 datasource config they could post? -Jason -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon online manual: http://www.openbluedragon.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
