• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Moving E812 to Windows 2008 and SQL 2008

We are trying to move a customer to Win 2008 and SQL 2008.

I had everything working pretty well including the web servers. I am now installing a new OAS server on Win 2008 and just about have everything running. In the midst of doing this they swapped the environment Datasources to SQl 2008 database, but left all the system databases on SQL 2005.

now my Jas and Webdev clients are not able to sign on. I get this error on the jas client:

Sign In Error: An unknown JAS sign in error occurred. Please contact the System Administrator

and this is in my jas logs on the web server.

18 Sep 2015 22:45:08,337 [Line -1] [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812. java.sql.SQLException: No suitable driver
18 Sep 2015 22:45:08,337 [Line -1] [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.
18 Sep 2015 22:45:08,353 [Line -1] [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.) com.jdedwards.services.objectlookup.DataSourceNotFoundException: Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.)
18 Sep 2015 22:45:08,353 [Line -1] [SEVERE] - [BASE] com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.) com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.)
18 Sep 2015 22:45:08,353 [Line -1] [SEVERE] - [JAS] Exception occured in the JDESignon.jdeSignon() :BuildUserSession Failed. com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 812.)


we are using the SQL 2005 JDBC. Any guidance would be helpful. I am not the best with web and jas issues. And of course I am on a big fast deadline.

Many Thanks
 

altquark

Legendary Poster
Can you provide a little more detail - like what Service Pack are you running (Tools Release ?).
 

glen7x

Active Member
You are trying to connect to 2 different SQL databases. 2005 and 2008 uses 2 different types of JDBC drivers AFAIK.

The error says that the driver to connect to SQL server not found. Did you change the jdbc connect string to match the driver incase you changed the driver?
Also, check if your tools release supports the mentioned databases and Java server. As Jon mentioned, you havent given specifics of your configuration.
 
Top