Wrong user/password message in DatabaseStudio

[Former Member]

Hi all,

I am using DatabaseStudio 7.7.07.11 Build: 011-123-224-075 with jre1.5.0_18.

After a crash of DatabaseStudio I lost all "My Objects" and I had to install DatabaseStudio again.

Now when I connect to an "Administration Session" I get the following error:

Component: Catalog Plugin

Plugin: com.sap.sdb.tools.resources.catalog

Location: com.sap.sdb.tools.resources.catalog.CatalogResourcesPlugin.logErrorMessage(CatalogResourcesPlugin.java:130)

in the Event Log viewer. I do not want to connect to a SQL session ...

com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4008]: Unknown user name/password combination

at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:65)

at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:1061)

at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:689)

at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:563)

at com.sap.dbtech.jdbc.ConnectionSapDB.doConnect(ConnectionSapDB.java:510)

at com.sap.dbtech.jdbc.ConnectionSapDB.<init>(ConnectionSapDB.java:136)

at com.sap.dbtech.jdbc.DriverSapDB.connect(DriverSapDB.java:246)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.sap.sdb.tools.usermanagement.UM_Storage.getSessionSQLWithConnectionKey(UM_Storage.java:8573)

at com.sap.sdb.tools.usermanagement.UM_Storage.getSessionSQL(UM_Storage.java:1691)

at com.sap.sdb.tools.usermanagement.UM_DatabaseMaxDB.getSessionSQL(UM_DatabaseMaxDB.java:137)

at com.sap.sdb.tools.usermanagement.UM_DatabaseSession.getSessionSQL(UM_DatabaseSession.java:64)

at com.sap.sdb.tools.resources.catalog.internal.CatalogFolder.getSQLSession(CatalogFolder.java:142)

at com.sap.sdb.tools.resources.catalog.internal.Schemas.validate(Schemas.java:126)

at com.sap.sdb.tools.resources.base.internal.extensions.ExtensionManager.loadResourceExtensions(ExtensionManager.java:79)

at com.sap.sdb.tools.resources.base.Resource.loadExtensions(Resource.java:617)

at com.sap.sdb.tools.ui.dbm.util.ResourceUtil.addConnectionKey(ResourceUtil.java:110)

at com.sap.sdb.tools.ui.dbm.actions.OpenAdministrationAction.run(OpenAdministrationAction.java:115)

at org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:256)

at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)

at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)

at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:443)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)

at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)

at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)

at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:153)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:504)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:443)

at org.eclipse.equinox.launcher.Main.run(Main.java:1169)

The connection to the "Administration Session" is ok, but why do I get the error? Still anything wrong with my DatabaseStudio?

Thanks

Christian

[former_member229109 · Accepted solution]

Hello Christian,

1. Did you run uninstall the DatabaseStudio before you had to install DatabaseStudio again?

Did you delete any database software manualy?

2. Please update with output of the commands:

sdbregview u2013l

dbmcli db_enum u2013s

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hello Natalia,

first I did an upgrade to 7.7.07.11 to get my "lost objects" back...

Than I run an uninstall and a reinstallation.

I did not remove the databade software manually.

The command show the following:

C:\>sdbregview -l

SAP Utilities c:/programme/sdb/programs 7.7.07.11 32 bit valid

Server Utilities c:/programme/sdb/programs 7.7.07.11 32 bit valid

Database Studio Utilities c:/programme/sdb/programs/databasestudio/utilities 7.7.07.11 valid

Database Studio c:/programme/sdb/programs 7.7.07.11 valid

Base c:/programme/sdb/programs 7.7.07.11 32 bit valid

C:\>dbmcli db_enum -s

OK

.UMDB C:\Programme\SDB\programs\DatabaseStudio\utilities 7.7.07.11 fast running

.M770711 C:\Programme\SDB\programs\DatabaseStudio\utilities 7.7.07.11 fast offline

For me this looks ok.

I would not have any problems if I would close the "event log viewer" tab in database studio, but I don't like unnecessary error messages.

Thank you.

Best regards

Christian

[former_member229109 · Accepted solution]

Hello Christian,

Could you please uninstall the database studio.

Check that the software was uninstalled successfully.

Is the directory c:/programme/sdb empty?

Also check C:\Documents and Settings\<your OS user>\sdb directory.

Is it empty?

Reboot your PC. Run the database studio installation after that & post the results.

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hello Natalia,

I uninstalled Database Studio as requested, removed the still existing entries in the directories

C:\Documents and Settings\<your OS user>\sdb

and

C:\Documents and Settings\All Users\sdb

rebooted and reinstalled Database Studio. But I still get the same message.

I added a database (Server/Database add) using the correct password, because test it successful. When I do a doubleclick on the "control" user (expanding the view to "Database Server" and "Diagnosis Files") the message appears or when I do open an administration session (left click on user -> left click on "open administration").

I tested it with different servers and database, always the same message.

Maybe this is a feature and I did not recognized it before ...

Best regards

Christian

[former_member229109 · Accepted solution]

Hello Christian,

According the posted log:

u201CCatalogResourcesPlugin.java:130) in the Event Log viewer. I do not want to connect to a SQL session ... com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4008]: Unknown user name/password combinationu201D

You tried to open the SQL session with wrong user/password combinations. To connect to a SQL session please use the SYSDBA < superdba by the SAP installation > or DBA user. You could not connect to a SQL session as control < dbm > user.

You added a database (Server/Database add). Start the database studio, mark the database, right click => login & use the SYSDBA user/password < the SQL user >, Test login, finish. Then try the SQL connect as the SQL user.

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on Dec 3, 2009 5:52 PM

[Former Member · Accepted solution]

Hello Natalia,

I know, that the dbm-user can't execute SQL statements. But I do not want to, I just want to execute tasks with the dbm-user (backup/restore, adding datafiles, view tasks ... ), all task I can do with dbm-user in DBMGUI, so therefor the user control should be ok.

But if I am right, you say, that DatabaseStudio executes SQL session for its own (getting roles, schemas, users...), features requiring sysdba login in DBMGUI.

So it is really a "feature", and for me that means use the sysdaba user, even if I do not want to use features of this user, or ignore this message.

Thank you for your answers!

Best regards

Christian

[Former Member]

Hi all,

sorry for the bad formated post, but it seems all my carriagereturns are removed ...

Best regards

Christian