Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

When I try to open my report in reporting services I get an error:
a.. An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
a.. Cannot create a connection to data source 'Flyers'.
(rsErrorOpeningConnection) Get Online Help
a.. Cannot open database requested in login 'CRMElements_RealEstate'.
Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
----
My report is set to use NT Authentication and Works OK in VS.Net report
designer.
Reporting services is installed on a web server separate from SQL Server.
The SQL Server house both the reporting services databases and the database
I am trying to report against. Both server or Windows 2003. The SQL server
is also my AD controller.
I can get the report to work if I change the report to use SQL Server login
/ password, but then I have to supply it each time.
If I go into the report properties, data sources and try to change the way
the report authenticates I get an error:
Object reference not set to an instance of an object.
when I click apply.
The only way I can change the settings is to change them in report designer
and re-upload my report file. I am uploading the file through report
manager. I do not have any data sources configures on the report server. I
am embedding this information in the report (I think that is how it works).
IIS Security is set as Integrated Windows Authentication.
Any help as to where to look or how to troubleshoot is appreciated.I think it doesn't work because you need to activate delegation, which i am
not knowledgeable about.
As far as i know, windows credential are never retransmitted from one server
to another. Here is a little attempt at explaining what i mean
client(ie) -> reporting services(iis) -> SQL DB (sql server)
suppose these 3 elements are on distinct servers. ie will transmit your
windows authentication to IIS, but IIS will not push it to the sql server.
For this to work, i've read you need to activate delegation in active
directory, but i am not knowledgeable enough to help you on this topic. So
right now, we're just specifying sql server accounts in our report data
sources.
You can use shared data sources to make life easier.
Hope this helps
"Joe" wrote:
> When I try to open my report in reporting services I get an error:
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'Flyers'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> ----
> My report is set to use NT Authentication and Works OK in VS.Net report
> designer.
> Reporting services is installed on a web server separate from SQL Server.
> The SQL Server house both the reporting services databases and the database
> I am trying to report against. Both server or Windows 2003. The SQL server
> is also my AD controller.
> I can get the report to work if I change the report to use SQL Server login
> / password, but then I have to supply it each time.
> If I go into the report properties, data sources and try to change the way
> the report authenticates I get an error:
> Object reference not set to an instance of an object.
> when I click apply.
> The only way I can change the settings is to change them in report designer
> and re-upload my report file. I am uploading the file through report
> manager. I do not have any data sources configures on the report server. I
> am embedding this information in the report (I think that is how it works).
> IIS Security is set as Integrated Windows Authentication.
> Any help as to where to look or how to troubleshoot is appreciated.
>
>
>|||Do a google search for the "double hop problem."
You need to enable Server Principal Names (SPNs) which can be a daunting
task to setup properly.
-Joel
"Joe" <noemail@.noemail.com> wrote in message
news:OpPELIUaFHA.2664@.TK2MSFTNGP15.phx.gbl...
> When I try to open my report in reporting services I get an error:
> a.. An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> a.. Cannot create a connection to data source 'Flyers'.
> (rsErrorOpeningConnection) Get Online Help
> a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> ----
> My report is set to use NT Authentication and Works OK in VS.Net report
> designer.
> Reporting services is installed on a web server separate from SQL Server.
> The SQL Server house both the reporting services databases and the
> database I am trying to report against. Both server or Windows 2003. The
> SQL server is also my AD controller.
> I can get the report to work if I change the report to use SQL Server
> login / password, but then I have to supply it each time.
> If I go into the report properties, data sources and try to change the way
> the report authenticates I get an error:
> Object reference not set to an instance of an object.
> when I click apply.
> The only way I can change the settings is to change them in report
> designer and re-upload my report file. I am uploading the file through
> report manager. I do not have any data sources configures on the report
> server. I am embedding this information in the report (I think that is
> how it works).
> IIS Security is set as Integrated Windows Authentication.
> Any help as to where to look or how to troubleshoot is appreciated.
>
>
>|||Please excuse my ignorance, but could you specify exactly how you do the
"specifying sql server accounts in our report data sources"
Is it on the "Credentials stored securely in the report server" on the report?
How and where would you setup the user? In Report Server?
or in SQL server. It's been a while since I setup users on a database
in SQL 6.5 or 7.0... can you just use sa '
I've got what you described in your post of 2 connections
between 3 computers and connot get it to work.
Big Thanks for the Help!
--
Robert Hansen
"/dev/null" wrote:
> I think it doesn't work because you need to activate delegation, which i am
> not knowledgeable about.
> As far as i know, windows credential are never retransmitted from one server
> to another. Here is a little attempt at explaining what i mean
> client(ie) -> reporting services(iis) -> SQL DB (sql server)
> suppose these 3 elements are on distinct servers. ie will transmit your
> windows authentication to IIS, but IIS will not push it to the sql server.
> For this to work, i've read you need to activate delegation in active
> directory, but i am not knowledgeable enough to help you on this topic. So
> right now, we're just specifying sql server accounts in our report data
> sources.
> You can use shared data sources to make life easier.
> Hope this helps
> "Joe" wrote:
> > When I try to open my report in reporting services I get an error:
> > a.. An error has occurred during report processing. (rsProcessingAborted)
> > Get Online Help
> > a.. Cannot create a connection to data source 'Flyers'.
> > (rsErrorOpeningConnection) Get Online Help
> > a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> > Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> >
> > ----
> >
> > My report is set to use NT Authentication and Works OK in VS.Net report
> > designer.
> >
> > Reporting services is installed on a web server separate from SQL Server.
> > The SQL Server house both the reporting services databases and the database
> > I am trying to report against. Both server or Windows 2003. The SQL server
> > is also my AD controller.
> >
> > I can get the report to work if I change the report to use SQL Server login
> > / password, but then I have to supply it each time.
> >
> > If I go into the report properties, data sources and try to change the way
> > the report authenticates I get an error:
> > Object reference not set to an instance of an object.
> > when I click apply.
> >
> > The only way I can change the settings is to change them in report designer
> > and re-upload my report file. I am uploading the file through report
> > manager. I do not have any data sources configures on the report server. I
> > am embedding this information in the report (I think that is how it works).
> >
> > IIS Security is set as Integrated Windows Authentication.
> >
> > Any help as to where to look or how to troubleshoot is appreciated.
> >
> >
> >
> >
> >
> >|||Well with some resource digging... I've gotten my self up
out of the ignoreance hole I was in. I figured out how to
setup a SQL User Account, under Security/Logins "New Login"
and then in Reporting Services for each report under Properties-
Data Sources I checked "Credentials stored securely in the report server"
and entered <new> UserName and Password.
and it worked.!!!!! Yeah ME!!!!
I also changed it in Report Designer on on the Data Source Credentials Tab,
Saved and redeployed, but that didn't seem to do it. Looks like it has to
be done
in Report Server.
Thanks!!! Bob
To
--
Robert Hansen
"Bob Hansen" wrote:
> Please excuse my ignorance, but could you specify exactly how you do the
> "specifying sql server accounts in our report data sources"
> Is it on the "Credentials stored securely in the report server" on the report?
> How and where would you setup the user? In Report Server?
> or in SQL server. It's been a while since I setup users on a database
> in SQL 6.5 or 7.0... can you just use sa '
> I've got what you described in your post of 2 connections
> between 3 computers and connot get it to work.
> Big Thanks for the Help!
> --
> Robert Hansen
>
> "/dev/null" wrote:
> > I think it doesn't work because you need to activate delegation, which i am
> > not knowledgeable about.
> >
> > As far as i know, windows credential are never retransmitted from one server
> > to another. Here is a little attempt at explaining what i mean
> >
> > client(ie) -> reporting services(iis) -> SQL DB (sql server)
> >
> > suppose these 3 elements are on distinct servers. ie will transmit your
> > windows authentication to IIS, but IIS will not push it to the sql server.
> > For this to work, i've read you need to activate delegation in active
> > directory, but i am not knowledgeable enough to help you on this topic. So
> > right now, we're just specifying sql server accounts in our report data
> > sources.
> >
> > You can use shared data sources to make life easier.
> >
> > Hope this helps
> >
> > "Joe" wrote:
> >
> > > When I try to open my report in reporting services I get an error:
> > > a.. An error has occurred during report processing. (rsProcessingAborted)
> > > Get Online Help
> > > a.. Cannot create a connection to data source 'Flyers'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > a.. Cannot open database requested in login 'CRMElements_RealEstate'.
> > > Login fails. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> > >
> > > ----
> > >
> > > My report is set to use NT Authentication and Works OK in VS.Net report
> > > designer.
> > >
> > > Reporting services is installed on a web server separate from SQL Server.
> > > The SQL Server house both the reporting services databases and the database
> > > I am trying to report against. Both server or Windows 2003. The SQL server
> > > is also my AD controller.
> > >
> > > I can get the report to work if I change the report to use SQL Server login
> > > / password, but then I have to supply it each time.
> > >
> > > If I go into the report properties, data sources and try to change the way
> > > the report authenticates I get an error:
> > > Object reference not set to an instance of an object.
> > > when I click apply.
> > >
> > > The only way I can change the settings is to change them in report designer
> > > and re-upload my report file. I am uploading the file through report
> > > manager. I do not have any data sources configures on the report server. I
> > > am embedding this information in the report (I think that is how it works).
> > >
> > > IIS Security is set as Integrated Windows Authentication.
> > >
> > > Any help as to where to look or how to troubleshoot is appreciated.
> > >
> > >
> > >
> > >
> > >
> > >