Is the new data base being served from the same host URL and port that served the original one?
In case not, have you checked JDBC connectivity to that target destination host from the desired source host using another JDBC tool (not Apereo CAS) like a CLI client (the SQL*plus like alternative Microsoft provides for connecting to the data base they license) or the lovely SchemaSpy tool? Hope that helped, Sent from my iPhone > On 03 Jan 2017, at 17:59, carlos maddaleno cuellar > <iamcarlosmaddal...@gmail.com> wrote: > > Hi i need some help im trying to configure my audit to sql server data base > on my orale is working fine but when i change the cas.properties to my sql > server the log says > > org.springframework.beans.factory.BeanCreationException: Error creating bean > with name 'inspektrAuditEntityManagerFactory' defined in class path resource > [inspektr-jdbc-audit-config.xml]: Invocation of init method failed; nested > exception is javax.persistence.PersistenceException: [PersistenceUnit: > default] Unable to build Hibernate SessionFactory > > Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] > Unable to build Hibernate SessionFactory > > > Caused by: org.hibernate.exception.GenericJDBCException: Unable to obtain > JDBC Connection > > the params on my cas.properties are this: > > #cas.audit.max.agedays= > #cas.audit.database.dialect= > #cas.audit.database.batchSize= > cas.audit.database.ddl.auto=validate > cas.audit.database.gen.ddl=false > cas.audit.database.show.sql=true > cas.audit.database.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver > cas.audit.database.url=jdbc:sqlserver://172.18.141.81\DESA;databaseName=SEGURIDAD_BOLSA_EMPLEO > cas.audit.database.user=sa_desarrollo > cas.audit.database.password=EPXV5AA9BQ > #cas.audit.database.pool.minSize= > #cas.audit.database.pool.minSize= > #cas.audit.database.pool.maxSize= > #cas.audit.database.pool.maxIdleTime= > #cas.audit.database.pool.maxWait= > #cas.audit.database.pool.acquireIncrement= > #cas.audit.database.pool.acquireRetryAttempts= > #cas.audit.database.pool.acquireRetryDelay= > #cas.audit.database.pool.idleConnectionTestPeriod= > #cas.audit.database.pool.connectionHealthQuery= > > > cas.audit.database.dialect=org.hibernate.dialect.SQLServerDialect > > > > -- > - CAS gitter chatroom: https://gitter.im/apereo/cas > - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html > - CAS documentation website: https://apereo.github.io/cas > - CAS project website: https://github.com/apereo/cas > --- > You received this message because you are subscribed to the Google Groups > "CAS Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to cas-user+unsubscr...@apereo.org. > To view this discussion on the web visit > https://groups.google.com/a/apereo.org/d/msgid/cas-user/CANEG9%2BcvcYkq1hay-2mZcpia1y%2BOaYBuOLKLMVNWEfvE9knYbw%40mail.gmail.com. -- - CAS gitter chatroom: https://gitter.im/apereo/cas - CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html - CAS documentation website: https://apereo.github.io/cas - CAS project website: https://github.com/apereo/cas --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+unsubscr...@apereo.org. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/8FB8614F-05FC-43D8-A56B-EFC868671998%40madiva.com.
