Showing posts with label error. Show all posts

Friday, March 30, 2012

Reporting Services and .NET can not co-exist?

Hi,
I had trouble getting reporting services going. I would
get the configuration error. If I restart the IIS Admin
the reporting services works fine but my other aspx pages
get the same configuration error. Something about
Microsoft.Office.Interop.Owc. If I restart IIS Admin
again the other aspx pages work but reporting services
does not.
What is going on here?
Can't Reporting Services and other .NET pages co-exist?
Please help.
-Marciaapplications can co-exist, but not in the same virtual folder.
maybe you can try to create a new application pool dedicated to reporting
services. (this is required when installing reporting services and
sharepoint on the same server)
I've already installed RS on some computer and I never get any error.
What is the content of your web.config files? (under the RS folders and un
der parent folder)
"Marcia Gorby" <anonymous@.discussions.microsoft.com> a écrit dans le message
de news:5ffc01c48174$eb0e7840$a401280a@.phx.gbl...
> Hi,
> I had trouble getting reporting services going. I would
> get the configuration error. If I restart the IIS Admin
> the reporting services works fine but my other aspx pages
> get the same configuration error. Something about
> Microsoft.Office.Interop.Owc. If I restart IIS Admin
> again the other aspx pages work but reporting services
> does not.
> What is going on here?
> Can't Reporting Services and other .NET pages co-exist?
> Please help.
> -Marcia

Reporting Services Add-in Installation Error

I have tried several times to get the Reporting Services Add-In to install. It seems as if everything is going along well except when the installation gets to "Removing Backup" files it hangs and then completely uninstalls the product. Moreover, the event log simply notes "installation failed". Has anybody else encountered this? Thanks in advance for any help.

Yeah I get exactly the same thing - "Removing backup files" just sits there. Hasn't uninstalled the product yet, maybe I'm too impatient

When I check the activity, the HCINSTAL (which I guess is the right process) is active and consuming CPU, but apart from that nothing... I rebooted the server just in case, and though it seems to think the product is installed I'd like to get a clean install!

|||

Am I assuming correctly that this is wrt running SharePointRS.msi? If yes, then the SharePointRS.msi creates a log file in the Temp folder - <Drive>:\Documents and Settings\<user_name>\Local Settings\Temp\RS_SP_<number>.log file

Could you provide contents of the RS_SP_<number>.log file that corresponds to when you got the error?

thanx,

Prash

|||

I am having the exact same problem...This is the error I get from the RS log file!

The web configration file, C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\config\webconfig.dlc.xml, does not have element "configuration/configSections/sectionGroup[@.name='SharePoint']" or it is invalid.

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1

I opened the xml file and there is no section for configuration...|||

Same error. Eventually it finishes, but the webparts and associated actions are not registered in the site collections. (The Application management Reporting Services settings are available however).

|||I am getting the same error. Any resolution on this? It would be nice if the error would show what the config file should look like. It knows the section is missing...so why not show how to fix it?|||

I was told by an MS rep to try two things, neither of which worked:

1) re-download the add in

RESOLUTION:
==============
1. Run the .MSI from a command line with the following command:
a. msiexec /I SharePointRS.msi SKIPCA=1
2. Run the rscustomaction.exe file manually from a command line by running this
command:
a. %TEMP%\rscustomaction.exe -I
b. It could be in a different directory underneath %TEMP% though as on
Fredericks machine it was in the %TEMP%\2 directory.

I was wondering if it could be caused by an underpowered server -- my server/laptop has 1GB of memory and I saw where the req was 2GB. In any event, I get the same exact problem (hanging on the removing backup files), and at this point cannot get around it

|||It took my installation a long, long, long time to 'Remove Backup Files' but it eventually worked.

The other important thing is to make sure you have set yourself up as a Site Collections Admin in Sharepoint for *all* the Site Collections.

When you're running the install, it is modifying the SharePoint site collection to add the new SSRS bits.

Hope this helps.|||

The long time and HCInstall process you see during 'Remove Backup Files' are due to the RS Add-in installing RS help in all the languages supported in SharePoint in the various SharePoint Web Applications.

We are considering updating the 'Remove Backup Files' setup UI to be more informative and less confusing in the Katmai timeframe.

HTH,

Prash

|||

I have successfully installed the SQL Reporting Services add-in for MOSS on a single server farm. However, on our medium farm dev environment, I can not "set server defaults" for reporting services under Central administration site. I get the following error "An internal error occurred on the report server. See the error log for more details. > An internal error occurred on the report server. See the error log for more details. > Value does not fall within the expected range." In addition, I get this same error in our Test Medium farm environment.

To make things worse, the web parts and the reporting content types do not install correctly in my iltest medium farm either for any site collection eventhough the log file in my temp directory states their were installed and activated. I have deactivated the feature report server and uninstall it now several times after the repair and removal from add remove programs did not fix the issue.

Any ideas on how to fix the DEV error and then ge the Test enivronment to install correctly. I am wondering if their is an issue with using this in a medium farm scenario with 2 front-end web servers.

|||

RESOLUTION:
==============
1. Run the .MSI from a command line with the following command:
a. msiexec /I SharePointRS.msi SKIPCA=1
2. Run the rscustomaction.exe file manually from a command line by running this
command:
a. %TEMP%\rscustomaction.exe -I
b. It could be in a different directory underneath %TEMP% though as on
Fredericks machine it was in the %TEMP%\2 directory.

I have tried this solution and it worked perfectly.

BIG THANKS.

|||

who can resolve it?I saw the same error!

|||When you run the command line for msiexec (resolution outlined by henkyck), make sure you have changed the working directory to be the folder where the SharePointRS.msi exists.

This was the only way we were able to get the installation to work successfully.

sql

Reporting Services Add-in Installation Error

Yeah I get exactly the same thing - "Removing backup files" just sits there. Hasn't uninstalled the product yet, maybe I'm too impatient

|||

Could you provide contents of the RS_SP_<number>.log file that corresponds to when you got the error?

thanx,

Prash

|||

I am having the exact same problem...This is the error I get from the RS log file!

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1

I opened the xml file and there is no section for configuration...|||

Same error. Eventually it finishes, but the webparts and associated actions are not registered in the site collections. (The Application management Reporting Services settings are available however).

I was told by an MS rep to try two things, neither of which worked:

1) re-download the add in

|||It took my installation a long, long, long time to 'Remove Backup Files' but it eventually worked.

The other important thing is to make sure you have set yourself up as a Site Collections Admin in Sharepoint for *all* the Site Collections.

When you're running the install, it is modifying the SharePoint site collection to add the new SSRS bits.

Hope this helps.|||

We are considering updating the 'Remove Backup Files' setup UI to be more informative and less confusing in the Katmai timeframe.

HTH,

Prash

|||

I have tried this solution and it worked perfectly.

BIG THANKS.

|||

who can resolve it?I saw the same error!

|||When you run the command line for msiexec (resolution outlined by henkyck), make sure you have changed the working directory to be the folder where the SharePointRS.msi exists.

This was the only way we were able to get the installation to work successfully.

Reporting Services Add-in Installation Error

Yeah I get exactly the same thing - "Removing backup files" just sits there. Hasn't uninstalled the product yet, maybe I'm too impatient

|||

Could you provide contents of the RS_SP_<number>.log file that corresponds to when you got the error?

thanx,

Prash

|||

I am having the exact same problem...This is the error I get from the RS log file!

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1

I opened the xml file and there is no section for configuration...|||

Same error. Eventually it finishes, but the webparts and associated actions are not registered in the site collections. (The Application management Reporting Services settings are available however).

I was told by an MS rep to try two things, neither of which worked:

1) re-download the add in

|||It took my installation a long, long, long time to 'Remove Backup Files' but it eventually worked.

The other important thing is to make sure you have set yourself up as a Site Collections Admin in Sharepoint for *all* the Site Collections.

When you're running the install, it is modifying the SharePoint site collection to add the new SSRS bits.

Hope this helps.|||

We are considering updating the 'Remove Backup Files' setup UI to be more informative and less confusing in the Katmai timeframe.

HTH,

Prash

|||

I have tried this solution and it worked perfectly.

BIG THANKS.

|||

who can resolve it?I saw the same error!

Reporting Services Add-in Installation Error

Yeah I get exactly the same thing - "Removing backup files" just sits there. Hasn't uninstalled the product yet, maybe I'm too impatient

|||

Could you provide contents of the RS_SP_<number>.log file that corresponds to when you got the error?

thanx,

Prash

|||

I am having the exact same problem...This is the error I get from the RS log file!

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1

I opened the xml file and there is no section for configuration...|||

Same error. Eventually it finishes, but the webparts and associated actions are not registered in the site collections. (The Application management Reporting Services settings are available however).

I was told by an MS rep to try two things, neither of which worked:

1) re-download the add in

|||It took my installation a long, long, long time to 'Remove Backup Files' but it eventually worked.

The other important thing is to make sure you have set yourself up as a Site Collections Admin in Sharepoint for *all* the Site Collections.

When you're running the install, it is modifying the SharePoint site collection to add the new SSRS bits.

Hope this helps.|||

We are considering updating the 'Remove Backup Files' setup UI to be more informative and less confusing in the Katmai timeframe.

HTH,

Prash

|||

I have tried this solution and it worked perfectly.

BIG THANKS.

|||

who can resolve it?I saw the same error!

|||When you run the command line for msiexec (resolution outlined by henkyck), make sure you have changed the working directory to be the folder where the SharePointRS.msi exists.

This was the only way we were able to get the installation to work successfully.

Reporting Services Add-in Installation Error

Yeah I get exactly the same thing - "Removing backup files" just sits there. Hasn't uninstalled the product yet, maybe I'm too impatient

|||

Could you provide contents of the RS_SP_<number>.log file that corresponds to when you got the error?

thanx,

Prash

|||

I am having the exact same problem...This is the error I get from the RS log file!

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1

I opened the xml file and there is no section for configuration...|||

Same error. Eventually it finishes, but the webparts and associated actions are not registered in the site collections. (The Application management Reporting Services settings are available however).

I was told by an MS rep to try two things, neither of which worked:

1) re-download the add in

|||It took my installation a long, long, long time to 'Remove Backup Files' but it eventually worked.

The other important thing is to make sure you have set yourself up as a Site Collections Admin in Sharepoint for *all* the Site Collections.

When you're running the install, it is modifying the SharePoint site collection to add the new SSRS bits.

Hope this helps.|||

We are considering updating the 'Remove Backup Files' setup UI to be more informative and less confusing in the Katmai timeframe.

HTH,

Prash

|||

I have tried this solution and it worked perfectly.

BIG THANKS.

|||

who can resolve it?I saw the same error!

|||When you run the command line for msiexec (resolution outlined by henkyck), make sure you have changed the working directory to be the folder where the SharePointRS.msi exists.

This was the only way we were able to get the installation to work successfully.

Reporting Services Add-in Installation Error

Yeah I get exactly the same thing - "Removing backup files" just sits there. Hasn't uninstalled the product yet, maybe I'm too impatient

|||

Could you provide contents of the RS_SP_<number>.log file that corresponds to when you got the error?

thanx,

Prash

|||

I am having the exact same problem...This is the error I get from the RS log file!

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1

I opened the xml file and there is no section for configuration...|||

Same error. Eventually it finishes, but the webparts and associated actions are not registered in the site collections. (The Application management Reporting Services settings are available however).

I was told by an MS rep to try two things, neither of which worked:

1) re-download the add in

|||It took my installation a long, long, long time to 'Remove Backup Files' but it eventually worked.

The other important thing is to make sure you have set yourself up as a Site Collections Admin in Sharepoint for *all* the Site Collections.

When you're running the install, it is modifying the SharePoint site collection to add the new SSRS bits.

Hope this helps.|||

We are considering updating the 'Remove Backup Files' setup UI to be more informative and less confusing in the Katmai timeframe.

HTH,

Prash

|||

I have tried this solution and it worked perfectly.

BIG THANKS.

|||

who can resolve it?I saw the same error!

|||When you run the command line for msiexec (resolution outlined by henkyck), make sure you have changed the working directory to be the folder where the SharePointRS.msi exists.

This was the only way we were able to get the installation to work successfully.

sql

Reporting Services Add-in Installation Error

Yeah I get exactly the same thing - "Removing backup files" just sits there. Hasn't uninstalled the product yet, maybe I'm too impatient

|||

Could you provide contents of the RS_SP_<number>.log file that corresponds to when you got the error?

thanx,

Prash

|||

I am having the exact same problem...This is the error I get from the RS log file!

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1

I opened the xml file and there is no section for configuration...|||

Same error. Eventually it finishes, but the webparts and associated actions are not registered in the site collections. (The Application management Reporting Services settings are available however).

I was told by an MS rep to try two things, neither of which worked:

1) re-download the add in

|||It took my installation a long, long, long time to 'Remove Backup Files' but it eventually worked.

The other important thing is to make sure you have set yourself up as a Site Collections Admin in Sharepoint for *all* the Site Collections.

When you're running the install, it is modifying the SharePoint site collection to add the new SSRS bits.

Hope this helps.|||

We are considering updating the 'Remove Backup Files' setup UI to be more informative and less confusing in the Katmai timeframe.

HTH,

Prash

|||

I have tried this solution and it worked perfectly.

BIG THANKS.

|||

who can resolve it?I saw the same error!

|||When you run the command line for msiexec (resolution outlined by henkyck), make sure you have changed the working directory to be the folder where the SharePointRS.msi exists.

This was the only way we were able to get the installation to work successfully.

Reporting Services Addin - Set Server Defaults Error

Hey All,

I installed Reporting Services Add-in with no problems on a Virtual server that already hosts MOSS 2007 and configured everything that was stated in documentation. The Report server Url works fine..like http://myserver1:802/ReportServer and I can see the contents when I type this url.

However, when I go to Central Administration and click on "Set Server Defaults"...I am getting a "401.1 Unauthorized..." error.I setup the Manage Integration to TrustedAccount and the Grant DatabaseAccess to the account that is the Server.Farm and local administrator.

In the Reporting Services Configuration, I used SSRSWebAccount for WebService and SSRSWindowsAccount for WindowsService and the RSAppPool which is the ApplicationPool for ReportingServices Web Site uses the SSRSWindowsAccount only.

Anybody..please help.

Thanks,

Vedala

I resolved my problem by installing SQL Server 2005 SP2. All along I assumed my virtual machine had SQL Server 2005 SP2, but after looking closely, I found that my version was 9.0.3033 and not 9.0.3042 which is official SP2 release version. I grabbed that and reinstalled it on my image and everything started working.

I however did couple of other steps too...which I did not go back and undo and test..so at this point I am not really sure if only the above was the problem or something else.,,, I will update this post with the blog entry about my issue later.

Thanks,

Vedala

Reporting Services Addin - Set Server Defaults Error

Hey All,

Anybody..please help.

Thanks,

Vedala

Thanks,

Vedala

sql

Reporting Services Activation error

I try to activate it by command prompt like so:
C:\Documents and Settings\Administrator>rsactivate -c"C:\Program
Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
And I get this for output:
Failure starting the web service:
Unable to connect to the database (-2147159551) 0x80070005
I have looked through every knowledgebase article and have found no answers.
Can anyone help me here?If you get an answer to this question, please let me know, as I am having the same issue. rsahakian1960 at yahoo dot com. Thanks
--
Message posted via http://www.sqlmonster.com

Wednesday, March 28, 2012

Reporting Services 2005 semantic query error

I recently changed my datasource in our Reporting Service Model. We changed to a quicker SQL server with disk capacity. I am able to run new reports but when I try to run old ones that were on the old datasource, I get an error. The datasource has been changed to point to the new server (datasource).

The error is: An error has occurred during report processing. (rsProcessingAborted)
Semantic query compilation failed: e EmptySemanticQuery The SemanticQuery does not contain any Groupings or MeasureGroups. SemanticQuery must contain at least one of these elements. (SemanticQuery ''). (rsSemanticQueryEngineError)

I will appreciate any help.

Nick

Is your data source an SSAS 2005 cube? Or did you misconfigure the model data source? Use the Report Manager to verify/reset the model data source.

|||My datasource is one of our SQL server databases. I know that the datasource is not misconfigured in the model because I am able to run new reports.sql

Reporting Services 2005 on Vista

Hi All
When I go to http://localhost/reports on my laptop running Vista and SQL
Server Reporting Services 2005 SP2 I recive the following error:
HTTP Error 401.1 - Unauthorized
Description: You do not have permission to view this directory or page using
the credentials that you supplied.
Does anyone know how to resolve this?
Thanks
- DavidNot sure if this is to do with you having to be logged in to the machine as
Admin or someone with admin rights.
"David" wrote:
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>|||I don't run Vista but here is a post I saved that might help you:
>>>>>
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <David@.discussions.microsoft.com> wrote in message
news:90D7717A-5883-4EB8-BFDF-A97EE9E5FE40@.microsoft.com...
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page
> using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>

Reporting Services 2005 on a separate server

I recently installed an instance of SQL Server 2005 on a server that didn't have IIS. I received an error notification in the install logs that some components of SQL Server would not work. This lead me to wonder if Reporting Services 2005 truly can be installed on a separate server and run efficiently, so I pose the question to anyone out there who has had success doing so. Does IIS need to be installed on a server running an instance of SQL Server 2005 even if Reporting Services is not installed and is intended to be installed on a separate server? Any installation recommendations in installing RS 2005 on a separate server?Hi, some short answers, I hope they are suffiecient to your questions:

RS needs IIS to run. SQL Server 2005 does not.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Reporting Services 2005 Error Creating Report Server Virtual Directory

Hi all,
I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
installed SQL 2005 Reporting Services. However when I got to configure
the reporting services the following happens
When creating a new report server virtual directory on our server, (I
am installing to the default web site and the default virtual directory
name 'ReportServer'.)
1) It creates the virtual directory and says The virtual directory was
created and assigned
2) this is followed by a green tick next to 'Change Secure Connection
Level'
3) This is immediatly followed by a message coming up stating
'ReportServicesConfigUI has encountered a problem and needs to close.
We are sorry for the inconvenience.'.
I cant help feeling that it hasnt finished this correctly as the
'Report Manager Virtual Directory' section is still greyed out and I
cannot enter it.
Any help would be greatly appreciated.
TomHi,
This sounds like a permission error. In addition, what version of Windows
2003 are you running?
Have you checked the Event Log? If so, what other possible errors do you see?
Thanks,
Phillip
"tom@.isolditonline.co.uk" wrote:
> Hi all,
> I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
> installed SQL 2005 Reporting Services. However when I got to configure
> the reporting services the following happens
> When creating a new report server virtual directory on our server, (I
> am installing to the default web site and the default virtual directory
> name 'ReportServer'.)
> 1) It creates the virtual directory and says The virtual directory was
> created and assigned
> 2) this is followed by a green tick next to 'Change Secure Connection
> Level'
> 3) This is immediatly followed by a message coming up stating
> 'ReportServicesConfigUI has encountered a problem and needs to close.
> We are sorry for the inconvenience.'.
> I cant help feeling that it hasnt finished this correctly as the
> 'Report Manager Virtual Directory' section is still greyed out and I
> cannot enter it.
> Any help would be greatly appreciated.
> Tom
>|||If I use IE 6 I have no problems. I can access and view parts of the date
with IE7, but the controls do not come up in the reports.
"Phillip MacPherson-Cox" <PhillipMacPhersonCox@.discussions.microsoft.com>
wrote in message news:1FD05115-7F89-470F-AF3E-4866154C7B53@.microsoft.com...
> Hi,
> This sounds like a permission error. In addition, what version of Windows
> 2003 are you running?
> Have you checked the Event Log? If so, what other possible errors do you
see?
> Thanks,
> Phillip
> "tom@.isolditonline.co.uk" wrote:
> > Hi all,
> >
> > I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
> > installed SQL 2005 Reporting Services. However when I got to configure
> > the reporting services the following happens
> >
> > When creating a new report server virtual directory on our server, (I
> > am installing to the default web site and the default virtual directory
> > name 'ReportServer'.)
> >
> > 1) It creates the virtual directory and says The virtual directory was
> > created and assigned
> > 2) this is followed by a green tick next to 'Change Secure Connection
> > Level'
> > 3) This is immediatly followed by a message coming up stating
> > 'ReportServicesConfigUI has encountered a problem and needs to close.
> > We are sorry for the inconvenience.'.
> >
> > I cant help feeling that it hasnt finished this correctly as the
> > 'Report Manager Virtual Directory' section is still greyed out and I
> > cannot enter it.
> >
> > Any help would be greatly appreciated.
> > Tom
> >
> >|||In the Event Log, I just get the following:
Source - NET Runtime 2.0 Error Reporting
Event ID - 5000
EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.242.0, P3 443f597d, P4
rsconfigtool, P5 9.0.242.0, P6 443f597d, P7 154, P8 5, P9
system.nullreferenceexception, P10 NIL.
I am running on the local machine as an administrator.
The Windows 2003 Edition is Standard Edition.
Tom|||A uninstall of reporting services and re-install did the trick.
Tom
tom@.isolditonline.co.uk wrote:
> In the Event Log, I just get the following:
> Source - NET Runtime 2.0 Error Reporting
> Event ID - 5000
> EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.242.0, P3 443f597d, P4
> rsconfigtool, P5 9.0.242.0, P6 443f597d, P7 154, P8 5, P9
> system.nullreferenceexception, P10 NIL.
> I am running on the local machine as an administrator.
> The Windows 2003 Edition is Standard Edition.
> Tom

Monday, March 26, 2012

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Hi,

I am getting the following error whenever I try to open the reportserver 2005 default web page

http://home/reportserver

Reporting Services Error
--
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

--
SQL Server Reporting Services

SQL SERVER 2005 DEVELOPER EDITION ERROR LOG
2006-01-24 17:54:52.65 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.

REPORTING SERVICES 2005 ERROR LOG
aspnet_wp!runningjobs!15!1/24/2006-18:41:26:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

SURFACE AREA CONFIGURATION TOOL
SQL Server 2005 -> Reporting Services -> Integrated Security hangs 60 seconds

Next, long error stack trace follows with a message near the beginning ...

The report server can not open a connection to the SQL Server database.

All of my instances are up and running.
All of my instances allow both Windows Authentication and SQL Server Authentication.
Each has an sa password. (They are all the same.) I have tested each and can connect to each instance.
All of my instances allow remote connections. I have up'ed the connection timeout to 60 seconds.

Any ideas?

Any place that I could look to find SQL Server 2005 Reporting Services database connection Troubleshooting documentation?

Thank you very much.

AIMDBA

This error sounds like reporting services cannot communicate to the reportservices database, which is just a standard sql server 2005 database. Are you hosting the database server and reporting services on the same physical machine?|||

JonM,

Yes, I am hosting SQL Server 2005 Developers Edition database edition and SQL Server 2005 Reporting Services Developer Edition reporting server on the same machine. I just went through the regular install.

Any directions to try to start debugging this problem?

AIMDBA

|||The first thing to do is to go the 'Reporting Services Configuration Manager' Please make sure there is a green check mark next to everything (except encryption keys and execution accounts). Many common problems can be diagnosed here. Specifically make sure the 'Database Setup' looks correct.|||

Yes,

The SQL Server 2005 Developer Edition Report Server and the SQL Server 2005 Developer Edition Database Server are on the same machine.

I also did the following ...

Went into Report Server configuration ...

Set and Tested the login creditions to be

SQL Server Credentials

password

I used a . for the local database. That all worked fine.

Next, I changed the Execution Account to be .\Administrator.

That seems O.K.

Next, I changes the Reporting Services Service to run under .\Administrator.

I shut down and restarted everything.

When I do : http://localhost/reportserver

Now, I get a new message:

Reporting Services Error

The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) Get Online Helpsql

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Hi,

I am getting the following error whenever I try to open the reportserver 2005 default web page

http://home/reportserver

--
SQL Server Reporting Services

SURFACE AREA CONFIGURATION TOOL
SQL Server 2005 -> Reporting Services -> Integrated Security hangs 60 seconds

Next, long error stack trace follows with a message near the beginning ...

The report server can not open a connection to the SQL Server database.

Any ideas?

Any place that I could look to find SQL Server 2005 Reporting Services database connection Troubleshooting documentation?

Thank you very much.

AIMDBA

JonM,

Any directions to try to start debugging this problem?

AIMDBA

Yes,

The SQL Server 2005 Developer Edition Report Server and the SQL Server 2005 Developer Edition Database Server are on the same machine.

I also did the following ...

Went into Report Server configuration ...

Set and Tested the login creditions to be

SQL Server Credentials

password

I used a . for the local database. That all worked fine.

Next, I changed the Execution Account to be .\Administrator.

That seems O.K.

Next, I changes the Reporting Services Service to run under .\Administrator.

I shut down and restarted everything.

When I do : http://localhost/reportserver

Now, I get a new message:

Reporting Services Error

Reporting Services 2005 & IE7 Beta

When trying to print an RS2005 report, I keep getting the error "Unable to
load client print control". This is because the RSClientPrint ActiveX
control is not loaded. I have noticed that in IE7 Beta is not automatically
prompting to download the control. Has anyone been successful in running
this under IE7? I am using 7.0.5112.0, Beta 1.
* "Enable download for the ActiveX client print control" is enabled on the
server.
* Report Server added to the Trusted Sites list
* Download Signed ActiveX Controls = Enable
* Script ActiveX Controls Marked Safe for Scripting = Enable
* Automatic Prompting for ActiveX Controls = Enable
Works fine under IE6.
Thanks,
-sYou may want to insure that it is enabled.
Tools->Internet Options->Programs->Manage Add-ons
If RSCleintPrint Class is enabled, you may want to delete it and allow
it to be reinstalled.
Hope you get it to working,
Lonsql

Friday, March 23, 2012

Reporting Services (Arithmetic overflow error) error. Please help

Rep Svcs has been installed as part of MOM 2005, but this error is coming up
across several reports, so I believe it to be a RS error.
<message>
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot read the next data row for the data set ErrorCount.
(rsErrorReadingNextDataRow) Get Online Help
Arithmetic overflow error converting expression to data type datetime.
</message>
It has only recently (about a week or so) begin to happen, and I wonder if
anyone can point me in the right direction, of provide feedback/opinions on
wht it might be happening?
Thanks very much!
GarthOn a datetime field this usually happens due to a bad date
example 04/31/2005
what is the data type of the original column?sql

Wednesday, March 21, 2012

Reporting Services - Excel vs HTML ERROR plz help

Hey,
I have a little format issue with Excel 2003:
I am working in reporting services - creating a report. The SQL store
procedure returns a date with the following format:
MM/DD/YYYY HH:MM PM/AM
In my report on that perticular text field I have the following format:
dd/mm/yyyy HH:MM:SS
Because I want it in military time.
It displays fine in the report but when I open it in Excel it brings up
the following ERROR:
"File Error. Some number formats may have been lost"
And it shows the date columns the following way:
"38692.46597"
The document is NOT huge and does't contain more than 2000 rows.
Any ideas on how to solve this?
Sorry for posting twice(first post on here).
I have put this same post in the reporting services group.. Sorry

Friday, March 30, 2012

Reporting Services and .NET can not co-exist?

Reporting Services Add-in Installation Error

Reporting Services Add-in Installation Error

Reporting Services Add-in Installation Error

Reporting Services Add-in Installation Error

Reporting Services Add-in Installation Error

Reporting Services Add-in Installation Error

Reporting Services Add-in Installation Error

Reporting Services Addin - Set Server Defaults Error

Reporting Services Addin - Set Server Defaults Error

Reporting Services Activation error

Wednesday, March 28, 2012

Reporting Services 2005 semantic query error

Reporting Services 2005 on Vista

Reporting Services 2005 on a separate server

Reporting Services 2005 Error Creating Report Server Virtual Directory

Monday, March 26, 2012

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Reporting Services Error

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Reporting Services Error

Reporting Services 2005 & IE7 Beta

Friday, March 23, 2012

Reporting Services (Arithmetic overflow error) error. Please help

Wednesday, March 21, 2012

Reporting Services - Excel vs HTML ERROR plz help

Reporting in SQL Server

Blog Archive

About Me