3 Replies Latest reply on Sep 15, 2014 11:45 AM by thatJeffSmith-Oracle

    Trying to connect to a hosted Sql Server database.

    2741087

      I am connected with MS Mgt Studio but want to use SD. I have JTDS 1.2 and 1.3.1 drivers installed and credentials setup but always get "DB server closed connection" message, even though I am connected with MS tool.  Any suggestions what to do next?

        • 1. Re: Trying to connect to a hosted Sql Server database.
          thatJeffSmith-Oracle

          Check the sql server logs and find out why the server is closing the connections.

          • 2. Re: Trying to connect to a hosted Sql Server database.
            2741087

            The datamodeler.log file all I find and don't know if this is wha you are requesting.

            This is the latest content after logging in, trying to access the database and logging out.

             

            2014-09-14 14:52:28,030 [main] INFO  DataModelerAddin - Oracle SQL Developer Data Modeler 4.0.1.836

            2014-09-14 14:52:57,525 [AWT-EventQueue-0] ERROR SavedSearchPersistence - Unable to save searches:

            java.io.FileNotFoundException: C:\Program Files\SqlDeveloper\sqldeveloper-4.0.2.15.21-x64\sqldeveloper\sqldeveloper\extensions\oracle.datamodeler\types\saved_search.xml (Access is denied)

              at java.io.FileOutputStream.open(Native Method)

              at java.io.FileOutputStream.<init>(FileOutputStream.java:221)

              at java.io.FileOutputStream.<init>(FileOutputStream.java:171)

              at oracle.dbtools.crest.swingui.search.SavedSearchPersistence.saveData(SavedSearchPersistence.java:117)

              at oracle.dbtools.crest.swingui.search.SavedSearchPersistence.saveSearches(SavedSearchPersistence.java:107)

              at oracle.dbtools.crest.swingui.ApplicationView.closeApplication(ApplicationView.java:1238)

              at oracle.dbtools.crest.swingui.ApplicationView.exitApplication(ApplicationView.java:1916)

              at oracle.dbtools.crest.fcp.DataModelerAddin.canShutdown(DataModelerAddin.java:2656)

              at oracle.ide.cmd.ExitCommand.canShutdown(ExitCommand.java:252)

              at oracle.ide.cmd.ExitCommand.doit(ExitCommand.java:509)

              at oracle.ide.controller.CommandProcessor.invoke(CommandProcessor.java:377)

              at oracle.ide.IdeCore.quit(IdeCore.java:835)

              at oracle.ide.Ide.quit(Ide.java:650)

              at com.oracle.jdeveloper.nbwindowsystem.Installer.closing(Installer.java:90)

              at org.netbeans.core.startup.NbInstaller.closing(NbInstaller.java:702)

              at org.netbeans.ModuleManager.shutDownAsync(ModuleManager.java:1968)

              at org.netbeans.core.startup.ModuleSystem.shutDownAsync(ModuleSystem.java:349)

              at org.netbeans.core.NbLifeExit.doExit(NbLifeExit.java:134)

              at org.netbeans.core.NbLifeExit.run(NbLifeExit.java:94)

              at org.openide.util.Mutex.doEvent(Mutex.java:1343)

              at org.openide.util.Mutex.readAccess(Mutex.java:350)

              at org.netbeans.core.NbLifecycleManager.exit(NbLifecycleManager.java:210)

              at org.netbeans.core.NbLifecycleManager.exit(NbLifecycleManager.java:119)

              at org.netbeans.core.windows.view.ui.MainWindow$6.windowClosing(MainWindow.java:479)

              at java.awt.AWTEventMulticaster.windowClosing(AWTEventMulticaster.java:350)

              at java.awt.AWTEventMulticaster.windowClosing(AWTEventMulticaster.java:349)

              at java.awt.Window.processWindowEvent(Window.java:2051)

              at javax.swing.JFrame.processWindowEvent(JFrame.java:296)

              at java.awt.Window.processEvent(Window.java:2009)

              at java.awt.Component.dispatchEventImpl(Component.java:4861)

              at java.awt.Container.dispatchEventImpl(Container.java:2287)

              at java.awt.Window.dispatchEventImpl(Window.java:2719)

              at java.awt.Component.dispatchEvent(Component.java:4687)

              at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)

              at java.awt.EventQueue.access$200(EventQueue.java:103)

              at java.awt.EventQueue$3.run(EventQueue.java:694)

              at java.awt.EventQueue$3.run(EventQueue.java:692)

              at java.security.AccessController.doPrivileged(Native Method)

              at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

              at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)

              at java.awt.EventQueue$4.run(EventQueue.java:708)

              at java.awt.EventQueue$4.run(EventQueue.java:706)

              at java.security.AccessController.doPrivileged(Native Method)

              at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

              at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)

              at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

              at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

              at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

              at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

              at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)

              at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

              at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

              at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

            • 3. Re: Trying to connect to a hosted Sql Server database.
              thatJeffSmith-Oracle

              No, SQL Server keeps a server log of failed logins and abnormal occurrences. Ask your DBA.