ESM SER Enterprise Reporting and MS SQL 2005
Created: 07 Dec 2007 | Updated: 22 May 2010 | 6 comments
Is there any definitive guide on how to set up ESM 6.5.3 (and subsequently sp1 and sp2) with Enterprise Reporting 6.1.1 using SQL server 2005?
The sp1 and sp2 release notes make reference that it is supported and I know that it can work, but having difficulty in implementing.
First off, for the database foundations installation I needed to modify the database creation and set up scripts and run them manually in order to get them to complete successfully - note that you should be choosing complex passwords for all phases of the setup or will run in to problems! then run the installer and use the import data option, which looked like it worked, but i got a fatal error message. "
Now when i tried to do the initial install using the 6.5.3sp1 media, the install worked fine without having to go custom (it appeared) but then I got the same fatal error towards the end... ?
Looking at the DB, all the tables are created, logins, etc. so looks pretty good, but there is no info in any of the tables.
so moving along..... i'm working on setting up the RDL and the install works marvelous and shows as successful. yet i am not getting any replication and upon further inspection of the database_link.log i see a SQL java connection error (or several) that looks like:
"WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] unable to fill pool
org.jboss.resouce.JBossResourceException: could not create connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): Data type 0x38 is unknown.)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Paramter 1 (""): Data type 0x38 is unknown."
I know this is the SQL2000 jdbc driver from Microsoft. I tried the SQL2005 version, but the install would not complete. it complained about it. but i have it and it is installed that I can use.
Any ideas, or thoughts on how to proceed are appreciated. And if there is some documentation outlining the specific requirements and steps required to install Enterprise Reproting using SQL2005 that would be MOST helpful.