Hi Guys, I have 3 virtual servers setup.
www - Windows 2003 WebServer + OpenBD 1.3 (tomcat) DB01 - Windows 2003 Standard + SQL 2008 (new) DB02 - Windows 2003 Standard + SQL 2000 (old DB01) I have MS SQL 2000 databases I am trying to get moved over to SQL 2008. I was able to simply copy over the database files (data/log) to the new server and attach them. From within SQL 2008 Management Studio, I can run t-qsl statements on the databases, etc. My problem is connecting remotely to SQL 2008 from the www server. I am running OpenBD 1.3 on Windows 2003 Server. SQL 2000, which works fine, is configured for Windows Authentication only, and I have a windows user account called "open_bd". This windows account is tied to an Instance wide SQL 2000 login, and this login is granted user/ db_owner priveledges to each database in the SQL 2000 instance. Within OpenBD I have datasources configured to connect to DB02 (sql 2000) using JDBC. Here is an example of a datasource config from the bluedragon.xml file that works for connecting to the SQL 2000 server (db02). <datasource name="members"> <displayname>members</displayname> <password>E5SRlRuPgdEV27KbQs/E</password> <connectionretries>0</connectionretries> <sqldelete>true</sqldelete> <sqlupdate>true</sqlupdate> <username>open_bd</username> <drivername>net.sourceforge.jtds.jdbc.Driver</drivername> <sqlstoredprocedures>true</sqlstoredprocedures> <perrequestconnections>false</perrequestconnections> <sqlinsert>true</sqlinsert> <sqlselect>true</sqlselect> <connectiontimeout>120</connectiontimeout> <port>1433</port> <server>192.168.111.242</server> <databasename>members</databasename> <description></description> <connectstring></connectstring> <initstring></initstring> <logintimeout>120</logintimeout> <hoststring>jdbc:jtds:sqlserver://192.168.111.242:1433/members</ hoststring> <maxconnections>24</maxconnections> <name>members</name> </datasource> I've created the same user and login on SQL 2008, but I keep getting a login failed error when I point the datasource to the IP of the SQL 2008 box. Can someone post their functioning datasource configs for 2008? I can even telnet from the WWW server to the SQL 2008 ip on port 1433, so I know SQL 2008 is listening. I just can't get the login to work, or my datasource isn't configured correctly. Do I need to add a JDBC driver to the SQL 2008 box? Or is there a specific JDBC driver for 2008 that I need to install on the OpenBD install? -- 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
