SQL STUDIO ACCESS

[Former Member]

All,

im new to MAXDB and i have installed it along with the SAP PORTAL installation. My server name ia ERP and the database name is J2E, but i was not able to login to the database using SQL Studio, any thoughts.. please let me know

BTW i get the following error

ODBC - Error:[SQLOD32 DLL][SAP DB] Invalid authorization specification;-4008 POS(1) Unknown user name/password combination. return-code: SQL_ERROR (-4008).

~Gopi

[roland_mallmann]

Hi,

logging onto your DB instance using SQL Studio requires a correct user-id and password. This user <b>must</b> be an SQL user. These are normally:

<b>(sys)dba</b> -> normally 'superdba' (standard password: admin)

<b>sap-user (dba user)</b> -> normally either 'sapr3', 'sap<sid>' or when using J2EE: 'sap<sid>db'. (where <sid> denotes the db instance name). (standard password: sap)

Regards,

Roland