Markus and Daniel, Thank you both for your help. I really appreciate it!
Ben -----Original Message----- From: Stausberg, Markus [mailto:[EMAIL PROTECTED]] Sent: Monday, May 27, 2002 2:26 AM To: '[EMAIL PROTECTED]' Subject: RE: [newbie!] Can't connect with new user > 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
<<attachment: winmail.dat>>
