Problem:

After installing StarTeam Datamart 2005, errors occurred when tried to run the Datamart Extractor

Resolution:

• Product Name: StarTeam
• Product Version: 2005
• Product Component: Datamart Extractor
• Platform/OS Version: Windows (MS SQL Server database)

Description:

After installing StarTeam Datamart 2005, following errors occurred when tried to run the
Datamart Extractor.

Error 1: "java.lang.ClassNotFoundException: com/microsoft/jdbc/sqlserver/SQLServerDriver"

Error 2: "Getting connection SQL Exception: [Microsoft][SQLServer 2000 Driver
for JDBC]Error establishing socket.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
establishing socket."

Answer/Solution:

Error 1: "java.lang.ClassNotFoundException: com/microsoft/jdbc/sqlserver/SQLServerDriver"

If the drivers are not listed in your CLASSPATH variable, you receive the
above error message when you try to load the driver:

Workaround:
Set your system CLASSPATH variable to include the following entries:

? \Your installation path\Lib\Msbase.jar (For ex. C:\Program Files\Microsoft SQL
Server 2000 Driver for JDBC\Lib\Msbase.jar)

? \Your installation path\Lib\Msutil.jar

? \Your installation path\Lib\Mssqlserver.jar

Error 2: "Getting connection SQL Exception: [Microsoft][SQLServer 2000 Driver
for JDBC]Error establishing socket.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
establishing socket."

The error message above typically indicates that either the host name or port is
specified incorrectly. By default SQLServer listens on port 1433.

Workaround:
Change the TCP port number to "1433" in system registration of StarTeam application under
MS SQL Server.

Run regedit -> HKEY_LOCAL_MACHINE -> SOFTWARE -> Microsoft -> Microsoft SQL
Server -> STARTEAM -> SuperSocketNetLib -> Tcp -> Change both "TcpDynamicPorts"
and "TcpPort" to 1433.

Note: To check if the default port number of MS SQL Server is 1433,

Run regedit -> HKEY_LOCAL_MACHINE -> SOFTWARE -> Microsoft -> MSSQLSERVER ->
Client -> SuperSocketNetLib -> Tcp -> "DefaultPort" to 1433.

Author: Rajini Billahalli