EV Dashboard 0.21 available for download.

Hi Guys,

Sorry I have only just come back to this thread. Unfortunately I have not had anyone test out SQL 2008. The connect strings I use are from SQL 2000/2005 (I am currently using SQL 2005 SP3 with no problems).

I wish I could be more help in this area.

Please let me know if you manage to get this working. I will see if 2008 does use newer connection strings or methods and post back if I find anything.

Jeremy.

Hi all,

Has anyone out there managed to get SQL 2008 and EV Dashboard running together?

If you do please post here, so we know it can be done.

Thanks,

Jeremy.

i'll test it for you mate in a bit, i'm absolutely sure that we need to add "Network Library=DBMSSOCN"
This will force a TCP/IP connection and not named pipes

Thanks JW.

It will certainly be useful to have this future proofing.

Jeremy.

Ok so I have SQL 2005 SP3 and EV 9 , installed and configured everything per the document (the only thing I didnt understand was the reference to the 'trigger' file ? )

When i go to evserver/evdashboard some information comes up but not much.  If i run any of the reports like Enabled Mailboxes it comes back blank.

Yet I used the EVD_User and EVRO_User, i've double checked their mappings.  Run i run the .cmd to gather data it seems to process normally no errors in the log file. 

What am I missing ? Thank you !

Followup info, there is an error in the log and i get the same thing with test sql

2010.11.01 05:55:27: Processing Organisation Archiving History.
2010.11.01 05:55:27: Processing Organisation Archiving History - EnterpriseVaultDirectory.
2010.11.01 05:55:27: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Saveset'.
2010.11.01 05:55:28: Error creating connection to database server miasql / evdashboard.  Check your connection string or database server name/IP and try again.
 

which seems to be a similar error gentleman above is getting but i am using sql 2005 not 2008. 

One more followup, i created an ODBC connection from the IIS server where evdashboard is installed to my sql server, and it tests fine using the ebd_user account.

Microsoft SQL Server ODBC Driver Version 06.01.7600

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!

well jp is getting login failed

yours is because its trying to query a table that doesnt exist or doesnt have access to the database (most likely a vault store database)

Ok ... well none of my reports are retrieving any data, and running the process command even with the server time set to < 8:30am it runs in 1 second.  Something isn't right ..

So here is my whole processing log, it just doesnt seem to be processing anything of significance ?

******************************************************
*
*  EVDashboard Data Collector - v1.2.11
*
******************************************************

2010.11.01 05:30:05: Successfully opened config.xml.
2010.11.01 05:30:05: Running in pre-online day mode.
2010.11.01 05:30:05: Loading data from config.xml.
2010.11.01 05:30:05: Creating multi-dimentional array.

*************************************************************************

2010.11.01 05:30:05: Processing Usage Report By Archive.

*************************************************************************

2010.11.01 05:30:05: Processing Disabled Users.

*************************************************************************

2010.11.01 05:30:05: Processing Over Send Limit.

*************************************************************************

2010.11.01 05:30:05: Processing Over Warning Limit.

*************************************************************************

2010.11.01 05:30:05: Processing Over Receive Limit.

*************************************************************************

2010.11.01 05:30:05: Processing SQL info.

*************************************************************************

2010.11.01 05:30:05: Processing EV Site Name.

*************************************************************************

2010.11.01 05:30:05: Processing Hourly Archiving Rates.

*************************************************************************

2010.11.01 05:30:05: Processing Organisation Archiving History.
2010.11.01 05:30:05: Processing Organisation Archiving History - EVVSExpressVaultStore_1.
2010.11.01 05:30:05: Processing Service Alerts.
2010.11.01 05:30:05: (Service Alerts) - Inserted 0 new row(s) into database.

*************************************************************************

2010.11.01 05:30:05: Processing EV Disk Info.
2010.11.01 05:30:05: (EV Disk Info) - miaev01

*************************************************************************

2010.11.01 05:30:06: Processing Exchange Disk Info.

*************************************************************************

2010.11.01 05:30:06: Processing Exchange Mailboxes.

*************************************************************************

2010.11.01 05:30:06: Processing Domain Name.
2010.11.01 05:30:07: Processing EV Server EventLogs.
2010.11.01 05:30:07: (EV Server Event Logs) miaev01

*************************************************************************

2010.11.01 05:30:15: Processing SIS Report.

*************************************************************************

2010.11.01 05:30:16: Processing Enabled Mailboxes.

*************************************************************************

2010.11.01 05:30:16: Processing Enabled Mailboxes Databases.
2010.11.01 05:30:16: Processing MSMQ Message Count Alerts.
2010.11.01 05:30:16: Finished.
2010.11.01 05:30:16: Written StartTime as 2010.11.01 05:30:05
2010.11.01 05:30:16: Written FinishTime as 2010.11.01 05:30:16