HI ,
while trying to connect the view to event db , I am experiencing a weird issue where in getting "unable to connect " error message.
also in the error log I am getting below errors can you pls help.
TP-Processor1> [ConfigurationManagerBean] ADAM Error code: 2,128 com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:181)
com.vmware.vdi.adamwrapper.exceptions.ADAMServerException: database initialization failed, SQL exception when connecting to database: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
at com.vmware.vdi.admin.be.ConfigurationManager.a(SourceFile:1703)
at com.vmware.vdi.admin.be.ConfigurationManager.updateDatabaseConfiguration(SourceFile:1580)
at com.vmware.vdi.admin.ui.ConfigurationManagerBean.updateDatabaseConfiguration(SourceFile:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.vmware.vdi.admin.ui.common.ViewFlexFactory$ViewProxy.invoke(SourceFile:113)
at com.sun.proxy.$Proxy56.updateDatabaseConfiguration(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:418)
at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1400)
at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:1011)
at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:103)
at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:166)
at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:291)
at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:353)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at com.vmware.vdi.admin.ui.servlet.AMFProxyServlet.a(SourceFile:90)
at com.vmware.vdi.admin.ui.servlet.AMFProxyServlet.doPost(SourceFile:57)
Hi James ,
It is an SQL API based connection to event database , there is no need of a ODBC connection , view will do for you.
Just wanted to know which OS you are using for the connection server and have you done Windows Update on this machine ? , If not done please do that .
reboot the machine try connecting the event database . if not working please verify the things mentioned in the below KB
http://kb.vmware.com/KB/1029537
You can do one more thing before checking the KB , if the connection server OS is windows 2012 and the SQL is Windows 2012 , take a snapshot of the conection server VM and go to
below location
C:\Program Files\VMware\VMware View\Server\broker\shared\lib\sqljdbc-1.2.jar
stop all view service in connection server.
rename sqljdbc-1.2.jar to sqljdbc-1.2.jar.backup.
download SQL JDBC 3.0 Driver http://www.microsoft.com/en-us/download/details.aspx?id=21599
extract the download file and copy the sqljdbc4.jar to location (C:\Program Files\VMware\VMware View\Server\broker\shared\lib\)
also copy same file once more and rename the file to sqljdbc-1.2.jar
restart all the connection server services and wait for 10 minutes , then check the view admin page.
Hi James ,
It is an SQL API based connection to event database , there is no need of a ODBC connection , view will do for you.
Just wanted to know which OS you are using for the connection server and have you done Windows Update on this machine ? , If not done please do that .
reboot the machine try connecting the event database . if not working please verify the things mentioned in the below KB
http://kb.vmware.com/KB/1029537
You can do one more thing before checking the KB , if the connection server OS is windows 2012 and the SQL is Windows 2012 , take a snapshot of the conection server VM and go to
below location
C:\Program Files\VMware\VMware View\Server\broker\shared\lib\sqljdbc-1.2.jar
stop all view service in connection server.
rename sqljdbc-1.2.jar to sqljdbc-1.2.jar.backup.
download SQL JDBC 3.0 Driver http://www.microsoft.com/en-us/download/details.aspx?id=21599
extract the download file and copy the sqljdbc4.jar to location (C:\Program Files\VMware\VMware View\Server\broker\shared\lib\)
also copy same file once more and rename the file to sqljdbc-1.2.jar
restart all the connection server services and wait for 10 minutes , then check the view admin page.
Thanks , I just said the way you said after downloading the JDBC and restart the connection server , then tried to connect the db and it starts working.
I tried this fix, but it still didn't work for me