Tag Info

Hot answers tagged

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. ...


3

The report redist must also be installed on any application/web servers if the app is using the report viewer .net control. Users also need admin rights to install the activeX in xp. We automate the installation of these component to all users - similar to this: ...


3

Some troubleshooting steps: Are you seeing any errors in the Application event log for the OS? Do you see the hits against /reportserver/ in the IIS logs? Have you verified in IIS that the /reportserver/ virtual directory is still present and that it's using the correct application pool (which has the proper identity)?


2

Resolved the issue after reading an MSDN post here: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/880b77ac-3228-40ce-99dc-12b0ff0eb46a The steps outlined below allowed me to run the msi successfully and then deploy the feature to the farm: Open the commad window (Start>Run type cmd and press enter) Navigate to the path where ...


2

Definitely sounds like a double-hop issue. You will need to set your environment to use Kerberos authentication between your clients, the report server, and the data server. For Kerberos to work, you'll need the reporting service and SQL database service to be running as domain accounts rather than local accounts (Local system/Network service), and you'll ...


2

Research into how Kerberos delegation works shows that no, you cannot share SPNs between service accounts on the same box. I solved the problem by provisioning a second IP address for my server and mapping IIS to one IP address and SSRS to the other. I then created two new A records in DNS (don't use C records, they are unreliable with Kerberos delegation) ...


2

Do the keys become unnaccessible after a reboot, or after a restart of the Reporting service, or after a restart of the support SQL Server service? As a generic guideline, see this article to troubleshoot the issue: Troubleshooting Initialization and Encryption Key Errors. Then use rsconfig and/or rskeymgmt.exe to fix the problem, once you identify the ...


2

Yes you can use SQL 2005 backend for SSRS 2008. Quote: You can use an instance of the Database Engine from SQL Server 2005 or SQL Server 2008 to host the databases. In the olden days, you could not host SSRS 2005 databases onto SQL Server 2000.


2

I would first determine if SSRS is indeed only using one processor. This is simple enough using Process Monitor, Task Manager, or Performance Monitor. If it's only using one thread, I would research the documentation and see if there is anyway to scale this out. Unfortunately, I don't know the answer. The other thing I would look at is SQL Server. Use SQL ...


2

I use the principle of least privilege when setting up services and create a specific account for each service. If you are going to use built-in accounts, which one you should select depends if you are using Active Directory or not. If the server is in an AD Domain, you should use Network. Otherwise, I'd suggest Local System. But my first choice would be to ...


2

I assume you've discussed the impact of the "no activex" policy with whoever is proposing it? You can set the "ie internet zones" appropriately to only allow SSRS ActiveX to be used for certain trusted sites (like internal sites). A workaround would be to use SSRS schedules to create offline copies of the reports to a file share. You'd only get "canned" ...


2

The solution was two-fold: I exported the certificate from the primary site sever under "Personal\Certificates" the friendly name is "ConfigMgr SQL Server Identification Certificate." I then imported the certificate to my local workstation under "Trusted Root Certificate Authorities\Certificates." This allowed me to connect to SQL server when I choose "Use ...


1

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

I checked Add/Remove programs and no luck either, Can't find SSRS listed. That's because it's not listed as SQL Server Reporting Services. You will need to choose SQL Server in the list of installed programs, click "Uninstall/Change", select the instance of SQL Server that you want to work with, then finally in the 'Select Features' interface, check ...


1

SSRS exports a web service that allows reports to be downloaded and uploaded programatically (amongst other things). It comes with utility called rs.exe that lets you script this type of process using vb.net. All this really does is top and tail the script and then compile and execute it. IronPython or any .net language can also be used to do this type of ...


1

Here's how I solved this: 1) Turned on 'the' administrator account via command line: net user administrator /active:yes 2) Logged in as the built in admin and opened the browser as an administrator 3) Successfully went to http://localhost/reports and assigned my regular admin account all the rights it needed. I'm not sure what the difference is between ...


1

If you can configure the VPN client not to change your default gateway, you shouldn't have any interruption to your internet connection. The only reason you lose your internet connection is because the VPN client adds a new default route to the VPN server at the other end of the tunnel, forcing all traffic through the VPN. Almost all VPN clients I've ever ...


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

Have you captured a profiler trace and checked if there is a "Login Failed" reported on the SQL Server GP database or an access denied on certain tables on the SQL database? Or is there a login failed reported in the Reporting Services logs? Also, do these users have access to browse these reports? Users need to be in the browser role to generate these ...


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

Firefox by default has NTLM and Kerberos authentication disabled. Websites smart enough to detect this give an appropriate error page. SharePoint isn't that smart. Enable Negotiated authentication by opening "about:config", search for "network.negotiate-auth.trusted-uris" and set it to the domain name your SP server is in (ie if your SP server is ...


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

Reporting services exposes a WMI interface that can be scripted via powershell or other scripting provider I believe there is also a way to achieve some of this via the commandline and rsconfig.exe The Report Server WMI provider exposes classes, properties, and methods that allow you to configure all aspects of a Reporting Services installation including ...


1

upgrade to SSRS 2008 or 2008 R2. The rendering engine and the startup times are much faster. That being said, if part of the issue is with start times, I have heard of people creating warmer scripts to ensure the app pool is constantly running. Caching and saving report execution may ba an option for you as well. Especially in a batch load DW ...


1

To find out edition of SSRS, go to: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log on the server which has SSRS Open the Summary.txt file. Look for the log file for Product : Microsoft SQL Server 2005 Reporting Services. In the SSRS log file, search for keyword "edition"


1

First off, is it a valid class? Try this: PS>get-wmiobject -list -namespace "root\Microsoft\SqlServer" Does that class get listed? Shortcut: PS>get-wmiobject -list -namespace "root\Microsoft\SqlServer"|where{$_.name -eq "MSReportServer_Instance"} I have a VM running Server 2008 with SQL 2008 and can try this out tomorrow. If you're not sure of the ...


1

Using WmiExplorer.ps1 script I can see the instance name in __NAMESPACE and this query returns my instance name: gwmi -class "__NAMESPACE" -namespace "root\Microsoft\SqlServer\ReportServer" To get to MSReporterServer_Instance you must supply the instance name in this example my instance name is RS_SQL2K8: gwmi -class "MSReportServer_Instance" -namespace ...


1

If what you're trying to do requires WMI this may be missing the point, but SQL Server 2008 ships with managed extensions that means most automation tasks no longer need to be perfromed with WMI. For example on a machine with the client extensions installed either select the DB with open in powershell right click context menu command or load the extensions ...


1

I have similar problem. I created "banks" of shared schedules to handle this. For example I have 1 "bank" setup to run at 6am another to run at at 6:05 etc. Then I make sure that the reports are balanced across each "bank". Another option to look into is Resource Governor (Requires sql server 2008). It won't queue up the jobs; but it will allow you to ...


1

You would need to save the report to the file system (not sure if SSRS 2000 can do that) then pick it up with the SQL Mail job. Failing that setup a .NET app to connect to the web method that SSRS exposes (this is based on SQL 2005, so hopefully it'll work in 2000) and create the PDF and have the .NET app save it. Then have the next step of the job grab ...



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