Post reply

Problems with Reports from Active Directory

  • December 12, 2005 at 7:38 am

    #166255

    Hi all,

    I have a report that is pulling some user info from active directory for an employee directory.  The report works fine when run from my computer from both the report designer and the report manager running on my computer, but does not work when I put it on the report manager on my machine and run it from somewhere else or run it from the report manager on a different web server.  Basically it seems to have a problem being served up from remote server.  Both report managers are running SQL Reports SP2, and it gives the following error message is returned when I run it:

    An error has occurred during report processing. (rsProcessingAborted) Get Online Help

    • Query execution failed for data set 'ActiveDirectory'. (rsErrorExecutingCommand) Get Online Help

      • No error information available: DB_E_NOTABLE(0x80040E37).

    The data source is configured to use OLE DB with integrated security and the following connection string is being used:

    Provider=ADsDSOObject

    I used the following query to return the data also:

    SELECT   DistinguishedName, givenName, mail, telephoneNumber FROM 'LDAP://dc=Domain,dc=com'

    I've also tried other authentication methods without any luck, and the error message hasn't really helped much. 

    Any help would be greatly appreciated.

    Happy Holidays,

    Bryan

  • December 13, 2005 at 2:27 pm

    #609311

    Hi Bryan,

    I found this link to microsoft with the db_e_notable error...

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/mdacsdk_oledb_security_best_practices.asp

    Also got the following from sql erors messages.

    DB_E_NOTABLE80040E37The specified table does not exist. The error string should contain the table name.

    From the OLE help in Microsoft...

    OLE DB Simple Provider Toolkit

    Registration Problems

    If no registration settings have been entered or if no data source initialization property has been set, IOpenRowset:penRowset returns the error DB_E_NOTABLE. This indicates that no table exists in the current data source.

    Have you tried just the sql command from enterprise manager on the other machine to see if that works?

    I hope that this is useful to you. Looks like a permission thing somehow.

     

    Michael

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply