Tag Info

Hot answers tagged

5

Check Server Manager -> Roles and verify if you have Web Server (IIS) installed. If yes, make sure you have IIS Management Console installed.


4

SSRS 2008 does (by default) not rely on IIS. You can run them side-by-side if you wish, but it is no longer required. To configure the URLs to access SSRS, you use the Reporting Services Configuration Tool - you probably want the "Advanced" configuration for Report Manager. See the following link for detailed instructions on how to setup URLs in SSRS 2008. ...


2

Late reply, but I just ran into this issue with moving SSRS 2008 R2 to a new server. Had the same problem as described above, but going through the Database and Credentials wizards fixed it for me, even though I made no changes and everything was displayed correctly. Go to Database -> Change Credentials/Change Database in the configuration manager and ...


2

Look at below. Depends on if it is named instance or default instance. http://technet.microsoft.com/en-us/library/bb677364.aspx#DefaultURLs http://technet.microsoft.com/en-us/library/bb630447.aspx


2

Using ILSpy, I've determined that "ExecutionLogLevel" setting isn't even used by SSRS 2012; it's not a supported setting. There is no code that references that string anywhere. FYI, I can find code that references "EnableExecutionLogging" and "ExecutionLogDaysKept" (complete with the internal constants defining the default values that SSRS uses). The ...


1

AFAIK (99% sure) the Dundas components that Microsoft licensed for SSRS in SQL Server 2008 are present in all versions of SQL Server 2008, thus if you're already running 2008 then there is nothing to upgrade. Where are you seeing that they are missing? Which do you think you are missing? If you see for example the donut chart then they are there.


1

I have something that works on SSRS 2012, but it's a total hack. It's possible to use client-side Javascript to rewrite all the URLs (plus the occasional RedirectUrl parameter SSRS is fond of), but that doesn't account for the Response.Redirect() calls server-side. So you'd be left with a partial solution. In short, add an HttpModule to ReportManager so you ...


1

What is the value of the LmCompatibilityLevel registry value on the domain controller? Authentication of trusted users fails on a Windows Server 2003-based server if the UPN format is used and if the value of the LmCompatibilityLevel entry is equal to or larger than 3 http://support.microsoft.com/kb/947861 LmCompatibilityLevel ...


1

I don't believe that it will support this natively, but you could do some thing like the following 1) Add a trigger to the table that will set a last modified date value each time the a record is inserted or updated. 2) Create an SSIS package to reprocess your cubes. 3) Have the ssis package write a last run date time value to track the last time it ...


1

"Proactive caching can only be deployed to a server running Microsoft SQL Server Enterpise Edition or Developer Edition." You've answered your own question there.


1

THIS ISSUE HAS BEEN RESOLVED! Root cause: There was a user who was somehow added 3 times to four different roles under Home folder. Any sub folder using the same permissions as Home (inheritance) suffer the same consequences. Why should SSRS allow this in the first place or not flag it clearly in the error log is beyond me! Resolution: Removed the ...


1

You can use Reporting Services Configuration Manager (Either locally on the SSRS server or from a remote machine that has the Configuration Manager installed from SQL Server media) to check what base URL is used by the web service, the default is http://server/ReportServer/ if you can browse that URL with your browser the firewall is open and you should be ...


1

If you go to SQL Server Reporting Service Configuration, you should be able to switch from Sharepoint Integrated mode to native mode. You may have to recreate the ReportServer and Reportservertempdb databases.


1

Yes. Both SQL Server 2008 R2 and SDQL Server 2008 SSRS can run on a SQL Server 2005 or higher back end. From MSDN For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic. ... SQL Server 2005 or SQL Server 2008 can be used to host the databases. Do not use SQL Server 2000 or earlier versions of SQL ...


1

SSRS snapshots will not give you the functionality you are looking for. You can create a SSRS subscription that will output an excel file (or another file type) to a file share. You can take the query from your reports and use that to copy point in time data to another database/table (using a night job). The easiest solution would probably be the ...


1

What error do you get in Reporting Services Configuration Manager when you try and restore the encryption key through there?


1

I hope this helps How to: Install and Configure Reporting Services on Windows Server 2008


1

Use ServerManagerCmd to change Windows 2008 Roles. Examples: ServerManagerCmd.exe -query ServerManagerCmd.exe -install Web-Server -resultPath installResult.xml ServerManagerCmd.exe -inputPath install.xml -whatIf


1

SSRS 2008 does not require IIS to be installed, therefore the SSRS Virtual Directories will not show up in IIS configuration tools anyway! http://blogs.msdn.com/b/bwelcker/archive/2007/12/04/everybody-why-leave-iis.aspx


1

type IIS in the search bar it should bring you to the internet services manager, or you can click start, programs, admnistrative tools and the IIS maanger should be listed



Only top voted, non community-wiki answers of a minimum length are eligible