Showing posts with label ssrs. Show all posts
Showing posts with label ssrs. Show all posts

Thursday, March 29, 2012

Database name

First let me apologize...I am using SSRS 2000 and I haven't worked in
it in 2 years so I'm having trouble with some very elementary stuff.
I need to get the database name in a footer. Any help would be
greatly appreciated!
ReneeUse a dataset with the following: select db_name()
Then in the footer put a textbox and an expression. The expression will use
First (there is only one record so this works).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"beener" <rmp_colo@.hotmail.com> wrote in message
news:1188319538.901307.242230@.50g2000hsm.googlegroups.com...
> First let me apologize...I am using SSRS 2000 and I haven't worked in
> it in 2 years so I'm having trouble with some very elementary stuff.
> I need to get the database name in a footer. Any help would be
> greatly appreciated!
> Renee
>
Posted by adap at 7:17 PM 0 comments
Labels: , , , , , , , , , ,

Friday, February 17, 2012

Database Logon Failed SSRS

Hi All,

My Report Server works find but after apply SQL Server 2005 Service Pack2. I can't connect to ReportServer Database. When Trying to connect from SQL Server Management Studio i get following Page.

TITLE: Connect to Server

Cannot connect to VISTA.


ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3054.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR[:#]3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR[:#]FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR[:#]3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color[:#]FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDatabaseLogonFailed&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3054.00" target="_blank">Get Online Help</a></li><ul>
<li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</ul>
</body>
--. (Microsoft.SqlServer.Management.UI.RSClient)


BUTTONS:

OK

Colud anyone help me to resolve this issue please?

Thank you very much.

Regards,

Balwant Patel

Try using the Reporting Services Configuration Utility (Database tab) to generate a database script and apply this script manually to your ReportServer database.|||

Did you just put on SP2? I had the same error very shortly after I put either SP2 or a hotfix (can't remember which), and it was fixed after a complete system restart and hasn't returned.

|||Make sure that the Service Accoutn the Reporting Server is running under has appropiate permissions to access the Report Server Database.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Teo,

Thank you very much for your response... I tried with Database script but it doesn't work.

Regards,

Balwant Patel.

|||

Hi gnieboer,

Thank you very much for response...I also restarted my system after apply SQL Server 2005 SP2 but I can't get rid of the problem.

Regards,

Balwant Patel

|||

Hi Suessmeyer,

I check permission on Report Server Database...It is fine

Regards,

Balwant Patel

|||Which account has been granted access to the Report Server database, the ReportService Account (Windows Service) or the ASP_Net Worker process ?


Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi suessmeyer,

I m using Windows Service Account

Regards,

Balwant Patel

|||Make sure that the the ASPNET account is a member of the SQLServer2005ReportingServicesWebServiceUser$<computername> $MSSQLSERVER Windows group and NT Authority\System is a member of the SQLServer2005ReportServerUser$<computername>$MSSQLSERVER group.|||

Hi Teo,

Yes, ASPNET Account & Authority\System are members of above groups...

I dont know what's the problem with it...

Regards,

Balwant Patel.

Posted by adap at 2:04 AM 0 comments
Labels: , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)