google for sql server JDBC connection strings. thats all you need

Please your help with the connection with sql server 2008 .. this is my configuration

type=OLAP name=smartbiz driver=mondrian.olap4j.MondrianOlap4jDriver location=jdbc:mondrian:Jdbc=jtds:sqlserver://192.168.1.2:1433/pentaho;Catalog=res:smartbiz/Facturas.xml;JdbcDrivers=net.sourceforge.jtds.jdbc.Driver; username=sa password=

The principal question is about driver and location: 1. driver is it mssql driver ? 2. location: what is the composition of this line ... 3. i create a folder named smartbiz in this path C:saiku-servertomcatwebappssaikuWEB-INFclasses 4. The string driver is correct, i'm using this file jtds-1.2.5.jar in the lib folder

Thanks

I don't know if I can help you but I used this connection string and it works :

type=OLAP name=sales driver=mondrian.olap4j.MondrianOlap4jDriver location=jdbc:mondrian:Jdbc=jdbc:sqlserver://guyintra;database=reporting;Catalog=C:/sales.xml;JdbcDrivers=com.microsoft.sqlserver.jdbc.SQLServerDriver username=sa password=*

Alexis.

Don't work for me .. Please can you help me with the next questions:

1. where can i see the error that i have, because, the log don't told nothing, and when i try to execute debug-start-saiku.bat, this have a line: Listenig for transport dt_socket at address : 8044 and nothing else .
2. i 'm using this file sqljdbc4.jar in spanish
3. the schema file works in pentaho, but i don't if this file works in saiku ...
4. Where can i place the file for use the plugin, because if i can't work with serveralone i like to use the plugin

Please your help, thanks in advance ...

without a log report i cant really tell you anything.

is there something in the latest catalina log file in tomcat/logs/catalina* ? is there something in tomcat/bin/saiku.log?

can you post both files to something like http://pastebin.com and post me the link? if nothing shows up in there, there might be something in the tomcat window that pops up when you start saiku. can you make a screenshot of that after saiku finishes starting?

-Paul

This is the saiku.log http://pastebin.com/PFXJUeT2 and this is the catalina.log http://pastebin.com/4J0U2bGd

thanks for your help ...

can you paste me your datasource file? there seems to be something wrong in there...

Hi

i try with sqljdbc.jar after that i have a error and try again with this file sqljdbc4.jar

this is the catalina log http://pastebin.com/NYh7fvRe this is the localhost log http://pastebin.com/BH5mLhtA

this is the file of the datasource http://pastebin.com/ebhnkdEL this is the path where the file in D:cubosaiku-servertomcatwebappssaikuWEB-INFclassessaiku-datasources

this is the path where is the schema D:cubosaiku-servertomcatwebappssaikuWEB-INFclasseswarehouses

this is the java version java version "1.6.0_29" Java(TM) SE Runtime Environment (build 1.6.0_29-b11) Java HotSpot(TM) 64-Bit Server VM (build 20.4-b02, mixed mode)

Thanks for your help

i dont see any error in your log

can you paste me the tomcat/bin/saiku.log (or maybe its already in tomcat/logs/saiku.log)

-paul

hi ....

This is my saiku.log

2012-03-20 11:36:50,372 DEBUG [org.saiku.web.service.SessionService] Logging in with [org.springframework.security.core.userdetails.User@586034f: Username: admin; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_USER]

Can you help me ... please ... thanks