Is it even possible to make this connection with 2008? My connection summary is below. Do I need to do a driver update or do I have something incorrect in my data server connector?
Name Value
Connector IDBC
ConnectorType SQL
DatePrefix '
DateSuffix '
Description MSSQL Database
Enabled true
InitCommand
InternalDateFormat yyyy-MM-dd HH:mm:ss
JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver
Name sandbox
PoolMax 100
PoolSize 1
ServerPackage com.lighthammer.Illuminator.connectors.IDBC
ServerURL jdbc:sqlserver://MII\SQLEXPRESS:1433;database=sandbox
Timeout 30
UseCount 256
UserName sa
ValidationQuery SELECT GETDATE()
WaitTime 30