Error while linking server to Active Directory service (advance)

I read that I can ignore this problem (it's normal!),
but I have another error.
I run SQL Server service with my domain account, I add my SQL Server istance
to Active directory inside Enterprise Manager, I create the linked server ho
w
documented with access by my domain account.
Finally, I execute this query in Query Analyzer:
SELECT * FROM OpenQuery( ADSI, 'SELECT *
FROM "LDAP://" ')
having this error:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14]
Any suggests to solve this issue?

> I need to retrieve information from LDAP in SQL Server 2000.
> I have installed SQL Server 2000 on a machine with Windows XP Professional
> (SP2).
> When I execute this script inside Query Analyzer:
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and then I open tables or views of linked server this error appears:
> "Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject
'
> a necessary interface..."
> Can I solve this issue?
> Where I can find a good documentation about SQL Server 2000 and LDAP?
> Many thanks
>The right error message is:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prep
are
returned 0x80040e14].
Sorry!
[vbcol=seagreen]
> I read that I can ignore this problem (it's normal!),
> but I have another error.
> I run SQL Server service with my domain account, I add my SQL Server istan
ce
> to Active directory inside Enterprise Manager, I create the linked server
how
> documented with access by my domain account.
> Finally, I execute this query in Query Analyzer:
> SELECT * FROM OpenQuery( ADSI, 'SELECT *
> FROM "LDAP://" ')
> having this error:
> Message 7321, Level 16, State 2, Row 1
> OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
> returned 0x80040e14]
> Any suggests to solve this issue?
>

Error while linking server to Active Directory service (advance)

I read that I can ignore this problem (it's normal!),
but I have another error.
I run SQL Server service with my domain account, I add my SQL Server istance
to Active directory inside Enterprise Manager, I create the linked server how
documented with access by my domain account.
Finally, I execute this query in Query Analyzer:
SELECT * FROM OpenQuery( ADSI, 'SELECT *
FROM "LDAP://" ')
having this error:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14]
Any suggests to solve this issue?

> I need to retrieve information from LDAP in SQL Server 2000.
> I have installed SQL Server 2000 on a machine with Windows XP Professional
> (SP2).
> When I execute this script inside Query Analyzer:
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and then I open tables or views of linked server this error appears:
> "Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject'
> a necessary interface..."
> Can I solve this issue?
> Where I can find a good documentation about SQL Server 2000 and LDAP?
> Many thanks
>
The right error message is:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prepare
returned 0x80040e14].
Sorry!
[vbcol=seagreen]
> I read that I can ignore this problem (it's normal!),
> but I have another error.
> I run SQL Server service with my domain account, I add my SQL Server istance
> to Active directory inside Enterprise Manager, I create the linked server how
> documented with access by my domain account.
> Finally, I execute this query in Query Analyzer:
> SELECT * FROM OpenQuery( ADSI, 'SELECT *
> FROM "LDAP://" ')
> having this error:
> Message 7321, Level 16, State 2, Row 1
> OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
> returned 0x80040e14]
> Any suggests to solve this issue?
>

Error while connecting to analysis services data source from reporting services

I am trying to connect to an analysis services data source from reporting services.

Analysis services is on a different domain. When I try to run the reports I get the error

"Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https. "

Any ideas on what is the workaround?

Try this:

on the reporting server, create a user ie. report and in IIS let the Reports and Reportserver run as the report user you just created. On the Analysis server, create that same user with the same password. Add that user to the Analysis cube. Thats it.

I have added my report user on the domain and also locally on the server. I don't think you need the user in both places but you can test as a local user as see what happens

|||When I modified the user in the report server application poll, I'm getting "service unavailable" error when connecting to reports|||

Leave the app pool as Network Service,

In IIS, Report/Reportserver properties ->directory security, check enable anonymous access and type in your user name and password