cancel
Showing results for 
Search instead for 
Did you mean: 

Database Connection Problem

sgomes
Champ in-the-making
Champ in-the-making
Hi, i´m using JBoss to deploy alfresco, and a SQL Server 2005 database..

1) i have already a database with name alfresco in SQL Server
2) i have copy the sqljdbc.jar to /Jboss/server/default/lib
3) i change my repository.properties to:

# Database configuration
db.schema.update=true
db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
db.name=alfresco
db.url=jdbc:sqlserver://localhost:1433;databaseName=${db.name}
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

4) i change file hibernate-cfg.properties to:

hibernate.dialect=org.hibernate.dialect.SQLServerDialect

but when i try to deploy the war…i get this error….

ERROR [JDBCExceptionReporter] Cannot create PoolableConnectionFactory (The TCP/IP connection to host has failed. java.net.ConnectException: Connection refused: connect)


what is wrong? can you help me? its really urgent….

thanks
2 REPLIES 2

mikeh
Star Contributor
Star Contributor
Hi

Please see this post http://forums.alfresco.com/viewtopic.php?t=5828

#
# SQLServer dialect
#
#hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect
‍‍‍‍‍

Thanks,
Mike

sgomes
Champ in-the-making
Champ in-the-making
I solve the problem thanks!