Problems with SQL base connecting

[GeorgeFrolov]

Hello, I have a geoportal with Tomcat 6.0, SQL Server 2008, Arcgis Server 10.

In one theme in this topic was discussed the same problem with connecting to SQL Server. I try all things, that was suggested there, but the problem was not resolved.

Geoportal.xml is

<!-- Context configuration file for the Geoportal Web App -->

<Context docBase="geoportal" path="/geoportal" debug="0" reloadable="true" crossContext="true">
    <Resource name="jdbc/gpt" auth="Container" type="javax.sql.DataSource"
              driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:sqlserver://ROSSTAT:1455;databaseName=geoportal"
              username="gptadmin"
              password="11111"
              maxActive="20"
              maxIdle="10"
              maxWait="-1" />
</Context>

My SQL tcp/ip parameters is
[ATTACH=CONFIG]11865[/ATTACH]
[ATTACH=CONFIG]11866[/ATTACH]

Please help me solve this problem.

[Anonymous User]

Original User: jhaodo

Have you added the sqljdbc4.jar file to the tomcat lib folder?

Try testing the connection using ArcCatalog via Add OLE DB connection.

[CliveReece]

Good suggestion on the jdbc driver jar file.  May I also cross-reference you to this link on the Geoportal Server forum:  http://sourceforge.net/projects/geoportal/forums/forum/1096644/topic/5008622