Adobe Connect User Community
Menu

#1 2019-05-14 11:19:40

bobbeers

i have a trial ver of adobe connect 9 get a sql server connect error

i have a trial ver of adobe connect 9 get a sql server connect error when i connect to a extrnal sql server here is the error hope someone here can help me with this



05-14 11:34:33: Connection string =jdbc:macromedia:sqlserver://localhost:1433;databaseName=breeze;ConnectionRetryCount=0;ConnectionRetryDelay=0;EncryptionMethod=noEncryption;ValidateServerCertificate=false
05-14 11:34:33: User =sa
05-14 11:34:35:
com.adobe.connectpro.config.utils.ConfigException[ACON-CONF-200-004]: Failed to connection to database jdbc:macromedia:sqlserver://localhost:1433;databaseName=breeze;ConnectionRetryCount=0;ConnectionRetryDelay=0;EncryptionMethod=noEncryption;ValidateServerCertificate=false
    at com.adobe.connectpro.config.processing.DBConnection.loadConnection(DBConnection.java:388)
    at com.adobe.connectpro.config.processing.DBConnection.loadConnection(DBConnection.java:162)
    at com.adobe.connectpro.install.gui.panel.DatabasePanel.testConnect(DatabasePanel.java:237)
    at com.adobe.connectpro.install.gui.panel.DatabasePanel.validateData(DatabasePanel.java:288)
    at com.adobe.connectpro.install.gui.panel.DatabasePanel.okToContinue(DatabasePanel.java:101)
    at com.zerog.ia.installer.AAMgr.g(DashoA10*..)
    at com.zerog.ia.installer.AAMgr.actionPerformed(DashoA10*..)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
    at java.awt.Component.processMouseEvent(Component.java:6288)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
    at java.awt.Component.processEvent(Component.java:6053)
    at java.awt.Container.processEvent(Container.java:2041)
    at java.awt.Component.dispatchEventImpl(Component.java:4651)
    at java.awt.Container.dispatchEventImpl(Container.java:2099)
    at java.awt.Component.dispatchEvent(Component.java:4481)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
    at java.awt.Container.dispatchEventImpl(Container.java:2085)
    at java.awt.Window.dispatchEventImpl(Window.java:2478)
    at java.awt.Component.dispatchEvent(Component.java:4481)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
    at java.awt.EventQueue.access$000(EventQueue.java:84)
    at java.awt.EventQueue$1.run(EventQueue.java:602)
    at java.awt.EventQueue$1.run(EventQueue.java:600)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
    at java.awt.EventQueue$2.run(EventQueue.java:616)
    at java.awt.EventQueue$2.run(EventQueue.java:614)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect
    at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
    at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
    at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
    at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source)
    at macromedia.jdbc.sqlserver.tds.ddc.<init>(Unknown Source)
    at macromedia.jdbc.sqlserver.SQLServerImplConnection.f(Unknown Source)
    at macromedia.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
    at macromedia.jdbc.sqlserverbase.BaseConnection.i(Unknown Source)
    at macromedia.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
    at macromedia.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)
    at macromedia.jdbc.sqlserverbase.BaseDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(DriverManager.java:582)
    at java.sql.DriverManager.getConnection(DriverManager.java:185)
    at com.adobe.connectpro.config.processing.DBConnection.loadConnection(DBConnection.java:377)
    ... 42 more

Offline

#2 2019-05-16 16:07:51

Jorma_at_CoSo

Re: i have a trial ver of adobe connect 9 get a sql server connect error

It looks to me like the Connect server is still trying to connect to a local DB. Verify that you have configured your external DB in the server management page.

Offline

#3 2019-05-17 21:45:59

bobbeers

Re: i have a trial ver of adobe connect 9 get a sql server connect error

this error came up in the adobe installer where you put all the sql info in when you tell it to use external sql server is there any other setup i have to do on the sql server side or install any other sql server tools like sql server agent or other tools

Offline

#4 2019-05-20 11:29:20

Jorma_at_CoSo

Re: i have a trial ver of adobe connect 9 get a sql server connect error

Just make sure your SQ credentials are correct. It is recommended that you use a login with SA rights, which it appears you did. Also make sure there is no encryption required on the communication between Connect and the SQL server.

Offline

#5 2019-05-20 12:45:08

bobbeers

Re: i have a trial ver of adobe connect 9 get a sql server connect error

i looked and the the encryption is off another ? dose adobe connect 9 work with sql server 2012 express and in the installer  it uses localhost not like this {cputername/sqlserver} that sql server uses to connect

Offline

#6 2019-05-22 11:19:52

Jorma_at_CoSo

Re: i have a trial ver of adobe connect 9 get a sql server connect error

Ah, did you provide the host mapping for your DB server? localhost should only be used if you are using the embedded DB. This is explained on step 17 here: https://helpx.adobe.com/adobe-connect/i … aller.html

This is most commonly a IP address of the DB server.

Offline

Board footer