Tag Info

Hot answers tagged

9

“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

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


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

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

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

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:


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


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

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


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

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


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


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


2

It means that your queries aren't large enough to fill the memory. This is a good thing, unless you are seeing heavy I/O while running the report.


2

You said in a comment above that your databases are only about 10GB total. SQL Server can easily load them entirely in memory, including data, indexes, and temporary data from your queries. This is a good thing, and provides better performance than reading from disk.


2

You can use the SMO WMI Management class which supposedly takes care of any special permissions. [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement") $wmi = new-object ("Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer") $env:computername $wmi.services | where {$_.Type -eq 'ReportServer'} | foreach ...


2

It took sometime to understand the problem. Correct me if I am wrong. You have a database where you load data for only one data and users ask for reports on this data. But during the import process (done only once a day) the reports are being blocked. The amount of data being added is 2GB everyday. And you want to optimize this process. What is the SELECT ...


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



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