Groups | Blog | Home
all groups > sql server reporting services > july 2007 >

sql server reporting services : Deploy Report error?


GGill
7/5/2007 3:28:00 PM
I try to deploy report "rptInfo.rdl" and I receive this error;

A connection could not be made to the report server
http://localhost/ReportServer.
Unable to connect to the remote server (Microsoft.ReportingServices.Designer).

What should i do to make this work?

GGill
7/5/2007 4:24:01 PM
I reinstall my IIS and when i deploy again this report, I have a new error
message;

Error 1 The report server cannot open a connection to the report server
database. A connection to the database is required for all requests and
processing. 0 0


[quoted text, click to view]
GGill
7/5/2007 4:40:01 PM
One more error i have when i try to deploy the report

------ Build started: Project: Report Project1, Configuration: Debug ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Report Project1, Configuration: Debug ------
Deploying to http://localhost/ReportServer
Error rsReportServerDatabaseUnavailable : The report server cannot open a
connection to the report server database. A connection to the database is
required for all requests and processing.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

[quoted text, click to view]
Roman Rehak
7/5/2007 8:57:42 PM
Looks like the Report Server web service cannot connect to the database. Is
this SQL Server 2005? Is so, run the configuration utility to set up a
backend database for RS. If it's SQL 2000, you may have to run Rsactivate to
provide correct database connection details.

Roman

--
Roman Rehak
http://sqlblog.com/blogs/roman_rehak


[quoted text, click to view]

Bruce L-C [MVP]
7/6/2007 11:59:07 AM
Back up. Make sure RS is working. Even with no reports deployed it will
still be there.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

GGill
7/6/2007 4:46:00 PM
From SQL Server 2005 i am connecting to sql server 2000 database.
I try to connect to 'Reporting Services Configuration Manager' and i
received error message 'Provider load failure'.
How should i make RS work?

[quoted text, click to view]
AddThis Social Bookmark Button