Error: 18456, Severity: 14, State: 16.

I'm getting login errors when trying to run reports both locally on the
report server and remotely on a client machine.
This is the error I get:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'RequestDataSource'.
(rsErrorOpeningConnection)
Cannot open database "<database name>" requested by the login. The login
failed. Login failed for user "<domain\username>".
Here's what I see in my SQL log:
2007-02-26 14:44:49.88 Logon Error: 18456, Severity: 14, State: 16.
2007-02-26 14:44:49.88 Logon Login failed for user <domain\username>.
[CLIENT: <local machine>]
The user is a domain admin and has full rights to all the databases on the
database server.
Any insight would be apprecaited. Thanks!On Feb 26, 1:57 pm, Henry <H...@.discussions.microsoft.com> wrote:
> I'm getting login errors when trying to run reports both locally on the
> report server and remotely on a client machine.
> This is the error I get:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'RequestDataSource'.
> (rsErrorOpeningConnection)
> Cannot open database "<database name>" requested by the login. The login
> failed. Login failed for user "<domain\username>".
> Here's what I see in my SQL log:
> 2007-02-26 14:44:49.88 Logon Error: 18456, Severity: 14, State: 16.
> 2007-02-26 14:44:49.88 Logon Login failed for user <domain\username>.
> [CLIENT: <local machine>]
> The user is a domain admin and has full rights to all the databases on the
> database server.
> Any insight would be apprecaited. Thanks!
Sometimes this occurs when the datasource has not yet been set up -or-
has not been set up correctly.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Error with Report Manager

Hi,
"localhost/reportserver" is all right.
But With "localhost/reports" i have the following error:
--"The underlying connection was closed: The remote name could not be
resolved."
I have no more idea. Thanks !!Hello MIB,
Try accessing the Report Manager with https://<machinename>/Reports or
http://<machinename>/Reports
Peter Blackburn
www.sqlreportingservices.net
"MIB" <MIB@.discussions.microsoft.com> wrote in message
news:CB391524-0F0E-4FAB-A5D5-17467F120B02@.microsoft.com...
> Hi,
> "localhost/reportserver" is all right.
> But With "localhost/reports" i have the following error:
> --"The underlying connection was closed: The remote name could not be
> resolved."
> I have no more idea. Thanks !!|||Thanks for your helps.
I tried to access with the machinename, but it doesn't work.
I'm using Wondows Server 2003 (FAT 32 - It's stupid I know but i haven't
choose this configuration).
At the end of RS install, I had the following message : launch manually
report manager (How to do it?).
I need to access to the report mnager, i tried so many things and i have no
more idea.
"Peter Blackburn (www.sqlreportingservice" wrote:
> Hello MIB,
> Try accessing the Report Manager with https://<machinename>/Reports or
> http://<machinename>/Reports
> Peter Blackburn
> www.sqlreportingservices.net
> "MIB" <MIB@.discussions.microsoft.com> wrote in message
> news:CB391524-0F0E-4FAB-A5D5-17467F120B02@.microsoft.com...
> > Hi,
> > "localhost/reportserver" is all right.
> > But With "localhost/reports" i have the following error:
> >
> > --"The underlying connection was closed: The remote name could not be
> > resolved."
> >
> > I have no more idea. Thanks !!
>
>

Error while previewing the report in Visual Studio 2005

Hi there,

The Visual Studio 2005 asks me to send an error report each time when I try to preview the reports. The reports are created in report server project in Visual Studio 2005.

Does anyone know why this is a problem?

Thanks

As a first step I would recommend to install SQL Server 2005 SP1 (http://www.microsoft.com/sql/sp1.mspx).

If you still encounter problems, you may want to try to directly publish the report to a report server and see if there are any publishing warnings or errors. Also posting the RDL file on this forum may help in further diagnosis.

-- Robert

|||

Thanks Robert, will get back if I still have any problems

Error while launching the report builder

Hi,

We are getting the following error when we launch the report builder as per below

http://<webservername>/reports

Reporting Services Error

---

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.

---

SQL Server Reporting Services

Please let us know what could be the reason.

Thanks,

San

Hi,

seems like the application account from IIS or the app pool is running under an account which is not privileged to read those file located on the hard drive. YOu reither give him the appropiate right, or use e.g. a Local System account.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Error while exporting to Excel SP2

All of my reports work fine, while trying to export them to excel. But I'm
not able to render one Report to Excel. The Report contains some Lists and
the visibility depends on some(9) parameters. The rendering works fine with
all other Rendering-Formats. It seems that the Reporting Service (thread)
aborts and restart again. Is it possible that the Service quits because of
the Memory Limit (160 MB)? In the IIS I have created a seperate AppPool for
the Server and the Web-Service.
Because other services running on the Server, I put the memory limit for the
AppPool to 250 MB.
This is the Error while processing the Report via Report-Manager and/or
Web-Service:
Operation is not valid due to the current state of the object
rrRenderingError 400
Microsoft.ReportingServices.ReportRendering.ReportRenderingExceptionI had the same problem until I installed RS SP2 on my workstation
which is where I was actually receiving the error (Visual Studio 200
Report Designer, Layout view). Now it works great

Error while executing reports from report manager

Hi..

I have deployed reports on to the report server. When I try to open the reports from report server, I get the error," Value does not fall within the expected range." This error message appears as soon as I click on any report on the report manager.

I am not able to find the cause of the error.

Does anybody have any suggestions?

Thanks ,

Viva

Viva1

Try checking your C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\web.config and make sure you have the below settings:

<appSettings>
<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</appSettings>

Ham

|||

Hi.

Thanks for your reply. I checked the web.config.. It has the settings that you have specified.

Still it does not work.

Any other suggestions for the problem?

Viva

|||

Viva1

In the directory C:\Program Files\Microsoft SQL Server\MSSQL.1 is a logfile directory for Reporting Service. In this directory, is a reporting service application log file and normally contains a more descriptive error message. It would be helpful to know what its contains.

Ham

|||

Ham,

Thanks for that. I shall take a look into that file and try to find out the issue.

ViVa