Hi Naresh,
 
you wrote :
>I have database manager 7.3.
>I can connect it properly.
>But when I go to SQL Studio and try to connect database
>It gives following error.

>"ODBC -Error:[SAP AG][SQLOD32 DLL][SAP DB]Invalid authorization specifi return-code:SQL_ERROR (->4008)"
>I changed password through database manger for both the users(First database manager operator   & SYSDBA) and tried >again through SQL Studio , but no luck.
 
as Elke explained there are DBMUSERs which cannot connect to the db via SQLStudio
(generally : they cannot connect using ODBC/JDBC).
This applies to the "first database manager operator" but not to the SYSDBA.
 
If you have problems in connecting with SQLSt. as the latter it is likely that you
created a password which contains special characters (e.g. a mixed case one).
In that case you have to enter it enclosed in doublequotes into the connect dialog.

regards

Markus Stausberg
SAP Labs Berlin

Reply via email to