I've added entries for these questions into the faqts website: > 1. I set my database to start up automatically (view -- options -- > autoconnect instances). Then I shutdown the instance and when > I relaunch > DBM It starts up in the online mode but when I reboot the > server it starts > up in the admin mode. I need it to start up in the online > mode at all time > even when I reboot the server. How can I do this.
http://www.faqts.com/knowledge_base/view.phtml/aid/19483/fid/1113 1. The service (SAPDB: <database name>) must be set to 'Startup type: AUTOMATIC' 2. The kernel parameter RESTART_SHUTDOWN must be set to AUTO (DBM Gui: Configuration=>Parameters=>Tab General) Autosave Log cannot be activated through these steps. > 2. Why do I have to login as sysdba into sqlstudio all the > time. It does > not allow me to use a regular user to login to sql studio. > Even if I create > a new user and try to login it does not allow this. What am > I doing wrong? http://www.faqts.com/knowledge_base/view.phtml/aid/19484/fid/1119 Users created with dbmcli or DBM Gui are for administration only. To create a SQL user, connect as the system DBA and execute a CREATE USER statement (http://www.sapdb.org/htmhelp/48/f0daa5225811d3a97d00a0c9449261/frameset.htm) Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
