Tag Info

Hot answers tagged

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

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

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

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


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

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

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


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

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

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

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


2

SSRS does not rely on IIS (from SQL 2008 onwards), it uses his own http.sys enviroment to host the web service and the report manager. Refer to: C:\Program Files\Microsoft SQL Server\MSRS10_50\Reporting Services\LogFiles To the possible cause. With so little detail it is hard to know, If you come up with an error in the logfiles, post it to help ...


2

Runs fine, I have one in production (SSRS 2008, not R2) and have had no problems related to the server OS.


2

I have managed to get this to work quite easily and in fact it's the only way we provide access to Report Builder. Citrix XenApp 4.5 Windows Server 2003 (enterprise) MS SQL Server 2005 Different versions may have different nuances! Make sure you run Report Builder on the Citrix XenApp server as an account with Administrator privileges in order to ...


2

ReportServer requires some rights in master and msdb, based on the RSExecRole At some point, these have been lost eg RS account change, server migration etc This MSDN article shows you how to recreate it


2

Is Exchange set up to allow relaying from your SQL server? If not, then no email to outside domains will be forwarded through the system from SMTP sources. Check out the following link: http://blogs.technet.com/b/exchange/archive/2006/12/28/3397620.aspx


2

This is by design and can be researched by searching for Kerberos and double hop issue. You need to enable Kerberos delegation on your reporting services server as well as set up an SPN so that Kerberos can pass the credentials of the user running the report instead of the Service Account for SSRS.


2

IIRC RS Configuration Manager looks for matching version of the report server. You will need RSConfigTool that comes with Sql Server 2008 (you can run it remotely on any other machine)


2

I really like pingdom. They will externally monitor services or even look for a specific string which is returned by a web server etc. http://pingdom.com/ You get one free probe without SMS messaging. You just pay for SMS credits as and when you use them. If you get by with just e-mails or push notifications to their apps they it's completely free for one ...


1

Most points are covered in KB 842425, aka "How to move a Reporting Services database from a computer that is running Reporting Services to another computer"


1

Database mirroring isn't supported by SQL Reporting Services. http://msdn.microsoft.com/en-us/library/bb510781%28SQL.90%29.aspx


1

Yes. Windows Authentication just means that the Windows accounts on the server are what's used for SQL logins, instead of SQL-only accounts defined within SQL Server Management Studio. If the SQL server isn't in a domain (your existing case), then it will use the local Windows accounts (found with Computer Management, Users and Groups.) You don't need to ...


1

Authentication methods for Reporting Services in 2008 are all handled by a file called RSReportServer.config. See: http://msdn.microsoft.com/en-us/library/cc281309.aspx for details.


1

How is Reporting services authenticating to the back-end database? What database type (SQL Server, Oracle, MySQL, etc.) is it connecting to? If you're connecting to a SQL Server, using the requesting user's credentials, you'll need to setup Kerberos authentication to avoid the "double-hop" issue. This will also involve setting up the appropriate SPNs within ...


1

I just just downloaded RSScripter for a similar situation and it worked fine. Be sure to read the read me file as it's operation is not readily apparent.


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 just set 'Trusted Sites' to 'Low' in IE and it now works. This page was helpful:



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