https://connect.hyland.com/t5/alfresco-archive/database-connection-problem/m-p/100339#M69509 <HTML><HEAD></HEAD><BODY><SPAN>Hi, i´m using JBoss to deploy alfresco, and a SQL Server 2005 database..</SPAN><BR /><BR /><SPAN>1) i have already a database with name alfresco in SQL Server</SPAN><BR /><SPAN>2) i have copy the sqljdbc.jar to /Jboss/server/default/lib</SPAN><BR /><SPAN>3) i change my repository.properties to:</SPAN><BR /><BR /><SPAN># Database configuration</SPAN><BR /><SPAN>db.schema.update=true</SPAN><BR /><SPAN>db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver</SPAN><BR /><SPAN>db.name=alfresco</SPAN><BR /><SPAN>db.url=jdbc:sqlserver://localhost:1433;databaseName=${db.name}</SPAN><BR /><SPAN>db.username=alfresco</SPAN><BR /><SPAN>db.password=alfresco</SPAN><BR /><SPAN>db.pool.initial=10</SPAN><BR /><SPAN>db.pool.max=20</SPAN><BR /><BR /><SPAN>4) i change file hibernate-cfg.properties to:</SPAN><BR /><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.SQLServerDialect</SPAN><BR /><BR /><SPAN>but when i try to deploy the war…i get this error….</SPAN><BR /><BR /><SPAN>ERROR [JDBCExceptionReporter] Cannot create PoolableConnectionFactory (The TCP/IP connection to host has failed. java.net.ConnectException: Connection refused: connect)</SPAN><BR /><BR /><BR /><SPAN>what is wrong? can you help me? its really urgent….</SPAN><BR /><BR /><SPAN>thanks</SPAN></BODY></HTML> Thu, 31 May 2007 14:36:59 GMT sgomes 2007-05-31T14:36:59Z https://connect.hyland.com/t5/alfresco-archive/database-connection-problem/m-p/100339#M69509 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 Server2) i have copy the sqljdbc.jar to /Jboss/server/default/lib3) i change my repository.properties to:# Database configurationdb.schema.update=truedb.driver=com.microsof Thu, 31 May 2007 14:36:59 GMT https://connect.hyland.com/t5/alfresco-archive/database-connection-problem/m-p/100339#M69509 sgomes 2007-05-31T14:36:59Z https://connect.hyland.com/t5/alfresco-archive/database-connection-problem/m-p/100340#M69510 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Please see this post </SPAN><A href="http://forums.alfresco.com/viewtopic.php?t=5828" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=5828</A><BR /><BR /><PRE class="language-none line-numbers"><CODE>#<BR /># SQLServer dialect<BR />#<BR />#hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Mike</SPAN></BODY></HTML> Thu, 31 May 2007 15:23:47 GMT https://connect.hyland.com/t5/alfresco-archive/database-connection-problem/m-p/100340#M69510 mikeh 2007-05-31T15:23:47Z https://connect.hyland.com/t5/alfresco-archive/database-connection-problem/m-p/100341#M69511 <HTML><HEAD></HEAD><BODY><SPAN>I solve the problem thanks!</SPAN></BODY></HTML> Thu, 31 May 2007 15:29:36 GMT https://connect.hyland.com/t5/alfresco-archive/database-connection-problem/m-p/100341#M69511 sgomes 2007-05-31T15:29:36Z