> Hello.
Hello Ben,
you wrote :
> I recently installed SAP DB 7.3 on my WinNT4 SP6
> workstation. I managed to create a new database with several
> tables. However, in SQL Studio I can only connect with user
> DBA. I created a new user 'bgreen' in the DBMGUI, but SQL
> Studio will not let me connect. It says,
>
> "ODBC-Error: [SAP AG][SQLOD32 DLL][SAP DB]Invaldid
> authorization specification;-4008 POS(1) Unknown user
> name/password combination. return-code: SQL_ERROR (-4008)"
the users created with DBMGUI are only created for administrative
purposes, they cannot connect using the ?dbc interfaces
(except 'DBA' ).
connect as 'DBA' in SQL studio and create ordinary users
with a 'create user <...>' statement.
you probably want to do full text searches on the mailing list
archive to answer similar questions, often searching for contributions
containing the error code (-4008) will give reasonable hints :
http://www.sapdb.org/sap_db_contact.htm
regards,
Markus Stausberg
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
