I'd like to connect to the SAP DB database by using the Database Manager application. The DB instance was installed with sapinst.exe and I've never got any username and password.
It worked - "control - control" was the right one. Thanks!
Kind regards,
Igor
P.S.
I don't see how could I know it if I wasn't told by Hay. I'm sure that I didn't see it anywhere during the installation process. It should be published in installation instructions or somewhere...
the users above are the default user. We don't ask for a password during the installation since we don't expect that the people know the meaning of these users.
But you are right we have to add the default passswords for these users into the installation guide.
"control - control" was fine for a DBM user, but now I need an SQL user. I tried in SAPDB SQL Studio with SAP<sysid>DB and SAP<sysid> with the password entered in the installation process, but it doesn't work. In DB Manager -> Configuration -> Users I can see only default DBM users CONTROL and SUPERDBA.
However, when the SAP system is up and running, in Information -> Sessions I can see 8 sessions of SAPDEV user. This is obviously an SQL user which SAP uses to connect to the database, but I don't know it's password.
Is there some other default SQL user or a way to find out or change the SAPDEV's password (ofcourse, then I'd have to change it in SAP too, or otherwise it couldn't connect)?
When you install SAPDB there are 2 types of users we have DBM Operators - control and Supedba and database users.
DBM operators are having previliges to work at DBM GUI level (out side the database) where as databse operators are the users inside the database. If you have DBM GUI 7.5 you can create and maintain the database users by logging in as DMB operator (SUPREDBA/admin) from configuration menu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.