Skip to Content

IDT-Connection Erroring out for Restricted Objects

Hi All,

We have created around 40 objects in the universe and set object access level to Restricted and at CMC we have assigned restricted access to Group  ABCgroup on this universe . So that only ABC group can able to  see  these 40 obejcts and it worked as expected.

Our backend is SQLserver and we have created connection using Generic account (ABC_BOBJ) with SQL server authentication.

Issue is- We are not  able to retrive data for restricted objects(all 40) . All other objects are retriving data while querying from BOBJ except these 40 restricted obejcts.

Error message :

Database error: [Microsoft SQL Server Native Client 10.0] : The server principal "ABD_BOBJ" is not able to access the database "DBNAME" under the current security context.. (IES 10901) (WIS 10901).

Can you shre some suggestions.

Thanks,
Raja

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 21, 2014 at 08:51 PM

    Hi

     

    Can you please check the DSN connection on the server and also check that no one has renamed it in the universe design module.

    1. Go to 'Control Panel > Administrative Tools > Data Sources (ODBC)'

    2. Locate the 'LMS_Reports' system DSN

    3. Check that it is pointing to the correct reporting database and has the correct login details.

    4. Test that the connection works ... And check wether your DSN connection is responding..

    if it is working then check is your ID, included in to the ABC group? if yes....but still getting the error please check with administrator with the details of the error that occurred.

    Add comment
    10|10000 characters needed characters exceeded

    • HI

      Check your ID is added to ABCgroup

      Login to CMC -->  Select the Users and Groups -->  Select the Groups (ABCgroup -- From Left hand side)  -->  check your ID’’s are added or not

      If still facing problem, Please check with administrators are able to run the report without issues

      Groups.png (16.4 kB)