This discussion is archived
2 Replies Latest reply: Oct 5, 2012 10:29 AM by 966302 RSS

Adding new employee, login failed

966302 Newbie
Currently Being Moderated
Setup:
Siebel 8.1.1 on Windows 2003 Server SP2. Database: DB2 V9 on z/Os.

Procedure:
Create new user account on MVS. Username: emp1001, Password: empl
Make sure the new user account is working by login using DB2 Connect, ODBC, TSO.
Login as SADMIN into Siebel Server using Internet Explorer with http://localhost/fins_enu
Create a new employee account, username: emp1001
Logout from Siebel Server.
Login to Siebel Server as: Username: emp1001, Password: empl
Get error message: The user ID or password that you entered is incorrect. Please check the spelling and try again.(SBL-UIF-00272)

FINSObjMgr_enu_0010_10485800.log:
C:\sba81\siebsrvr\log\FINSObjMgr_enu_0010_10485800.log 8.1.1 SIA [21111] ENU

DBCLog     DBCLogError     1     0000024c506e0ed4:0     2012-10-04 19:35:47     SQLExecDirect: set current sqlid

ObjMgrLog     Error     1     0000024c506e0ed4:0     2012-10-04 19:35:47     (clicon.cpp (3584)) SBL-DBC-00103: The DB2 database cannot be accessed.

Maybe the server is down or the database that the server uses is incorrect or defective. Please contact your system administrator.

DBCLog     DBCLogError     1     0000024c506e0ed4:0     2012-10-04 19:35:47     SQLError: sqlstate 42503: [IBM][CLI Driver][DB2] SQL0567N The operation failed because the specified authorization name does not meet the identifier naming rules. Authorization name: "SADMIN". SQLSTATE=42503




Somehow, the connection is still assuming "SADMIN" user name event though I typed in "emp1001" user name.
Please help.
  • 1. Re: Adding new employee, login failed
    jiyong Pro
    Currently Being Moderated
    I'm not familiar with DB2, but what was the procedure that you followed when you created the login for SADMIN?
    Did you follow the same procedure for the new user?

    Can you also execute a query when you use ODBCSQL with the new user?
    See instructions on Supportweb: How Do You Test Connectivity Through ODBC Data Sources Created by Siebel? [ID 475610.1]
  • 2. Re: Adding new employee, login failed
    966302 Newbie
    Currently Being Moderated
    I think I know where the issue is.
    When I was "Configure a new Enterprise in a Gateway Name Server",
    I entered "SADMIN" as Current IBM DB2 SQL ID/Group Name instead of "SSEROLE" (default)
    Also, during the "Database Configuration Wizard",
    I entered "SADMIN" as Security Group ID/Grantee instead of "SSEROLE"

    I will reinstall with SSEROLE and see what happens.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points