Tag Info

Hot answers tagged

7

“Microsoft® System CLR Types for Microsoft® SQL Server® 2012” can be downloaded at Microsoft® SQL Server® 2012 Feature Pack (direct links: X86 version, X64 version). And it seems to have fixed the installation problem for us; the server we needed to install the Report Viewer 2012 on does not have SQL Server installed at all.


6

If you don't have any good reason to expose it, Then you should probably not expose it. By the way you may be interested in this article to decide wether or not you should expose it


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


4

The Local System account is the computer's operating system's own security context. It has all the rights of "Administrator" users and more. More than likely the account you're naming that is not working properly doesn't have permissions to access some resource needed by the service program. You could put that account into the local "Administrators" group ...


3

You can install SQL Server 2005 with client tools without installing the database engine, or other SQL Server services. Do you have access to a enterprise/standard/development dvd/cd of sql server 2005? If not the free/express version of BIDS is available for download from Microsoft. I do not know if it has a full feature set compared to the full version, ...


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)?


3

SSRS for SQL 2008 always requests authentication. Use the Report Manager URL (servername/reports). Someone will need to give you access to the report server via the Report Server UI or SSMS connecting to he Report Server. There's a bunch of log info in the ReportServer folder in C:\Program Files\Microsoft SQL Server\MSRS.MSSQLSERVER... that can show you ...


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

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


3

You don't have IIS installed: it's a pre-requisite and would have been shown on earlier setup screens:


2

Have you installed SP2 or SP3 for SQL Server 2005? This is an issue with SP1 on Vista/2k8. See: http://msdn.microsoft.com/en-us/library/ms156468.aspx From the afore mentioned website (around halfway down): Reporting Services SP1 and earlier do not run on Windows Vista. If you try to run an SP1 report server on Windows Vista, you will encounter: An ...


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

We typically do retroactive SharePoint NTLM to Kerberos authentication changes as you're proposing. When we establish our SharePoint sites, it takes a couple of days for DNS changes to propagate, and getting our SPNs set on service accounts typically takes some time also. So after our SPN's are set, we first create a small test site on the server running ...


2

Have you tried just removing the virtual directories from IIS and running the report configuration wizard again? This is what I have done when our installation went wonky and not only was it quick and painless, it resolved the problem too! NOTE: We had a security issue where no client could view the reports even when in the correct AD groups YMMV but ...


2

Browse to http://servername/Reports/. Go to the Properties tab and add New Role Assignments as necessary.


2

To see the status of your subscriptions and when they last executed, you can perform a query: http://feedproxy.google.com/~r/sqlserverpedia/~3/O78C3knsUO0/


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

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

here is another reference link http://sqlcat.com/technicalnotes/archive/2009/10/23/sql-server-reporting-services-disaster-recovery-case-study.aspx you can certainly mirror the db's, but SSRS needs a handful of other items to failover as well. so, while your data gets mirrored, you may have to manually failover some components.


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

Because your site is also being visited by it's IP-address (without your domainname). AWStats doesn't know this is the same website unless you configure the HostAliases configuration directive. Add this to your AWStats configuration: HostAliases="72.249.150.9" Another solution would be redirecting visitors who visit your website by it's IP-address to your ...


2

You won't be able to log ship from SQL 2005 to SQL 2008 and be able to read the database. When the database goes into standby mode it can't bring the database online because it can't upgrade the database's physical version.


2

I've seen customers use Cacti. It is very customizable and you can graph any data. They are line and area charts, though.


2

Two things come to my mind the first is Splunk which can collect almost anything and make graphs for reporting, also it has a powerfull search engine. Second, is as usual i would say Zabbix , because you can feed it with any data and in many ways, it can also do lots of graphs, furthermore Zabbix provides an API for consumming the datas it has stored.


2

As a report generation tool, take a look at JasperForge's iReport. It can do drag and drop creation of reports based on data from various sources (including MySQL obviously). It is a little more complicated than Access reports, but much more powerful too. The main output of the tool is supposed to be a report you can use in JasperReports/JasperServer, but ...



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