[INUG-Users] Impact MS-SQL DSA problem

[Mateusz Kalisiak]

Unfortunately...It didn't help in this case. I've set up other Impact
installation on RedHat (in the same subnet) and DSA was able to connect to
MS-SQL. So, I think the problem has to do something with Solaris9 and MS-SQL
Server cooperation. Any ideas? Thanks for any advice.

Regards, Mateusz

2008/5/16 Ravi Malghan <rmalghan at yahoo.com>:

> I have seen this. Deleting the datasource, datatype and recreating them
> works for me. It seems to happen ocasionally.
>
> ----- Original Message ----
> From: Mateusz Kalisiak <mateusz.kalisiak at gmail.com>
> To: users at netcoolusers.org
> Sent: Friday, May 16, 2008 8:45:32 AM
> Subject: [INUG-Users] Impact MS-SQL DSA problem
>
> Hello All,
>
> I have installed Impact 4.0.2 and 4.0.2.0-TIV-NCI-IF0001-Solaris fix pack.
> System platform is Solaris 9 with latest patches.
> There is a problem connecting MS-SQL server from Impact. There is
> connectivity betweeen Impact server and MS-SQL server,
> I can telnet on port 1433 from Impact server. I have even replaced Impact
> server with my laptop (with MS-SQL client on it
> and I have set the same address as Impact server had) and I could access
> MS-SQL database.
>
> When I try to test DSA connection for MS-SQL, I can see the following
> message in /opt/netcool/log/netcool.log:
>
> 11:47:40,967 DEBUG [Debug] JDBC Connection Pool will try to connect to
> netcool at jdbc:JSQLConnect://192.168.0.16:1433/netcool
> 11:47:40,968 DEBUG [Debug] Ping to 192.168.0.16 : 1433
> 11:48:10,970 DEBUG [Debug] TimedExecutor: TransBlock Connecting to SQL
> database: jdbc:JSQLConnect://192.168.0.16:1433/netcool timed out.
> 11:48:10,970 DEBUG [Debug] JDBC Connection Pool recieved error trying to
> connect to data source at : jdbc:JSQLConnect://192.168.0.16:1433/netcool
> 11:48:10,970 ERROR [Debug]
> com.micromuse.common.util.NetcoolTimeoutException: Operation timed out
> after
> 30000 ms. Connecting to SQL database: jdbc:JSQLConnect://
> 192.168.0.16:1433/netcool
>        at
> com.micromuse.common.util.TimedExecutor.execute(TimedExecutor.java:182)
>
> Has anyone faced such problem?
> Other DSA's work properly (ObjectServer, Oracle).
>
> Regards,
> Mateusz
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search: http://netcoolusers.org/Search
>
>
>
>
>
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search: http://netcoolusers.org/Search
>