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.

10.02.png

10.03.png

MGAL_0-1626553661193.png

IMG_20210313_132946.jpg

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.