Can anyone shed any light on this one?
Our fusion install cannot seem to make a connection to the SP DB. Here is the error:
Event Type: Error
Event Source: ISS
Event Category: Security Fusion Module
Event ID: 1
Date: 2/4/2004
Time: 11:24:14 AM
User: N/A
Computer: <Fusion server name>
Description:
net.iss.sma.fusion.FusionException: Error creating connection pool (connectString=jdbc:ids://<our SPDB ip here>:12/conn?dsn='DRIVER={SQL Server};SERVER=<our SPDB ip here>;database=RealSecureDB', userName=SecurityFusionModule_<Fusion server name>): [08001][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
net.iss.sma.fusion.dbutilities.SqlServer.createConnectionPool(Unknown Source)
net.iss.sma.fusion.dbutilities.SqlServer.<init>(Unknown Source)
net.iss.sma.fusion.dbutilities.DbManager.registerSqlServer(Unknown Source)
net.iss.sma.fusion.dbutilities.DbManager.initServerConfigs(Unknown Source)
net.iss.sma.fusion.dbutilities.DbManager.initOptionsFromCurrentPolicy(Unknown Source)
net.iss.sma.fusion.FusionEngine.initOptionsFromCurrentPolicy(Unknown Source)
net.iss.sma.fusion.FusionEngine.initFromPolicyAndCommandLine(Unknown Source)
net.iss.sma.fusion.FusionEngine.startEngine(Unknown Source)
Things to note:
1. Named pipes not running on SPDB server
2. SPDB server is not listening on the default 1433 port.
Is there a way to "tweak" the jdbc connection string?
Regards,
---------------------
Jared Bergeron
