TS 7.2.1 install fails

Hi all,

Trying to install 7.2.1.
But when we try to install CommonServices it fails with that the tables etc. could not be created!.

I have logged onto the MSSQL server using the userinfo provided to the installation wizard. Whe logged on I can create tables etc. without any problems.

The only think I can think of that in the DB enviroment we are running on instances eg. xxxxx\i01. The database/server is listening on port 14331 which was also specified during the installation.

Below a dump from the installaer.log. The only think that I can see is that the database host (xxxxxi01 - where xxxxx is the db servername) is missing a backslash (\). I have created a test udl file on the server to check the connection and there are no problems there.

Does anyone have a clue of what is going wrong?

2011-02-01 00:27:49,922 DEBUG org.hibernate.util.JDBCExceptionReporter - Cannot open connection [???]
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host xxxxxi01, port 14331 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1033)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
at com.interwoven.wcm.ir.service.install.PopulateDBInfo.runTask(PopulateDBInfo.java:162)
at com.interwoven.wcm.install.api.CompositeTask.runTask(CompositeTask.java:134)
at com.interwoven.wcm.install.api.CompositeTask.runTask(CompositeTask.java:134)
at com.interwoven.wcm.install.framework.MultiComponentCompositeTask.runTask(MultiComponentCompositeTask.java:111)
at com.interwoven.wcm.install.framework.ia.Driver.install(Driver.java:429)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGaei.run(DashoA10*..)
2011-02-01 00:27:49,922 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08S01

/Vaqa

Find more posts tagged with

Comments

nipper

And why would you be using port 14331 for SQL server ?

Hi all,

Does anyone have a clue of what is going wrong?

2011-02-01 00:27:49,922 DEBUG org.hibernate.util.JDBCExceptionReporter - Cannot open connection [???]
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host xxxxxi01, port 14331 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

Migrateduser

As Nipper indicated, why 14331? We're assuming that's a typo in your post as 1433, not 14331 is the default port for MSSQL.

nipper

As Nipper indicated, why 14331? We're assuming that's a typo in your post as 1433, not 14331 is the default port for MSSQL.

Actually since that is from the install error, I assume the type when he entered it into the installer, causing it to use 14331 and fail. Now why he could not read the error and see that for himself I do not know......

mart2001

It is known that not using the default ports for Interwoven products can cause a lot of issues....

Victor2

Ok people, sorry for asking :-).

First to start with there is nothing wrong in using 14331 for mssql.
I actually also understood the error from the log :-).

Here some info about the platform:
Windows 2008 standard Edition (IIS 7)
TeamSite 7.2.1
And obviously MSSQL

Aparantly when running database INSTANCES like 'xxxxx\ins1' then during th install one has to type this as 'xxxxx\\ins1'. It is/was the single '\', causing the connection to fail, and that is probable something to do with escaping of the backslash.

Also IW documentation states that for MSSQL 2005 one has to use sqljdbc.jar file but infact it is sqljdbc4.jar file that will work.

Above steps got the installation going succesfully.

Thank you all for your valuable inputs:-).

/Saya

Kevin Butcher

We're having an issue setting up the database for Common Services. We're using SQL Server 2008 R2, installing TeamSite 7.2.1 on Windows 2008 R2.

For some reason I can connec to the database using any other tool, but not when using the installer it says "Login failed for DOMAIN\account"

We're using a domain account so it would be integrated security. Not sure if that is an issue for the installer, but it's not mentioned in any documentation I can find.

We are using a separate instance SERVER\Instance, but I've tried both single and double "\" and it still didn't work. The problem didn't seem to be connecting, it was authenticating, based on the error.

Anyone run into this issue before?

Kevin Butcher

We're using a domain account so it would be integrated security. Not sure if that is an issue for the installer, but it's not mentioned in any documentation I can find.

Truns out you must use SQL Server Authentication and give it DBO role. None of which i could find in the install documentation.