RE: Problem with login

[Zabach, Elke]

Naresh Chandak  wrote:   > Hi  > I have database manager 7.3.  > I can connect it properly.  >   > But when I go to SQL Studio and try to connect database  > It gives following error.  >   > "ODBC -Error:[SAP AG][SQLOD32 DLL][SAP DB]Invalid authorization specifi return- > code:SQL_ERROR (-4008)"  > > I changed password through database manger for both the users(First database manager operator   & SYSDBA) >and tried again through SQL Studio , but no luck.   Did you pay attention to the difference between  DBMUSER and SQLUSER as described in the following message found in the archive?   I am using sapdb 7.3  for windows NT can anyone plz help me out? You have to distinguish between administrative users for the DBM ("DBMUSER") and the ("real") database users for SQL ("SQLUSER"). The SQLUSERs are the users for your database operations via a SQL interface. The task of this users is to save and find data in the database. The users are saved inside the database. You can create and maintain this users via DBM commands ("user_*") with "SQLUSER=YES". The better way is to create and maintain this users via a SQL interface with "create user ..." oder "alter user ..." statements. In this case the DBM don't know this users, but is not necessary for the DBM to know this users. The DBMUSERs are saved outside from the database (for OFFLINE use). You can use this users only to get a DBMServer logon and execute DBMServer commands. The task of this user is to administrate the database (start, stop, backup etc.). The SQL interface don't know them. You can only create and maintain this users via DBMServer commands.  Elke  SAP Labs Berlin