Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Unable to establish connection
msp
<p>Hi</p>
<p> </p>
<p>I am facing issue while connecting to database in MS SQL SERVER.</p>
<p>Its showing me error as <strong>Login Failed for user</strong>.</p>
<p>Above mentioned database of <strong>SAP</strong> and vendor has provided us access on MS SQL SERVER connection.</p>
<p>I guess this might be the problem for the same.</p>
<p>I entered correct credentials still i am facing this issue.</p>
<p>Any suggestions or help is welcome.</p>
<p>Thanx</p>
Find more posts tagged with
Comments
msp
<p>Hi,</p>
<p> </p>
<p>Can anyone tell me how to generate BIRT reports using SAP B1 database?</p>
<p>Thanx. </p>
msp
<div>Following is the error i am getting (with reference to error posted on 27-AUG):</div>
<div> </div>
<div> </div>
<div>org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Login failed for user 'XXXXX'. </div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:304)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:206)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:782)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:703)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:175)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:156)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:715)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$7(JDBCSelectionPageHelper.java:683)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$7.widgetSelected(JDBCSelectionPageHelper.java:606)</div>
<div>at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:240)</div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)</div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)</div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)</div>
<div>at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)</div>
<div>at org.eclipse.jface.window.Window.open(Window.java:801)</div>
<div>at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:111)</div>
<div>at org.eclipse.birt.report.designer.data.ui.actions.EditDataSourceAction.doAction(EditDataSourceAction.java:69)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)</div>
<div>at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)</div>
<div>at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)</div>
<div>at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)</div>
<div>at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)</div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)</div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3588)</div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3209)</div>
<div>at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)</div>
<div>at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)</div>
<div>at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)</div>
<div>at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)</div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)</div>
<div>at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)</div>
<div>at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)</div>
<div>at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)</div>
<div>at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)</div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)</div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)</div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)</div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div>at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)</div>
<div>at org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)</div>
<div>at org.eclipse.equinox.launcher.Main.run(Main.java:1410)</div>
<div> </div>
<div>Any help is welcome</div>