Recently I moved to Windows Intune group. Windows Intune meets several companies' needs, and provides them with the tools they need to help manage and secure PCs through the cloud. It's a powerful combination of cloud services for PC security and management...

Device information settings in SSRS are used to pass parameters to a rendering extension. For more information regarding device information settings in reporting services, see Passing Device Information Settings to Rendering Extensions . For SQL Reporting...

SQL Reporting ReportViewer-SOAP API usage sample is available on CodeGallery. This sample demonstrate how to embed a Microsoft ReportViewer control that points to reports hosted on SQL Reporting report servers and how to use SQL Reporting SOAP APIs in...

The SQLReportingAdmin sample for Windows Azure SQL Reporting demonstrates the usage of SQL Reporting APIs, and manages (add/update/delete) permissions of SQL Reporting users. You must install the Windows Azure Software Development Kit (SDK) 1.3 or later...

Windows Azure SQL Reporting is now commercially available to the Windows Azure customers. Like other services on the Windows Azure Platform, SQL Reporting is designed to support elastic scale. Based on your usage and seasonal requirements, you can easily...

I was installing SQL Server 2012 RTM on my Windows Server 2008 R2 SP1 machine. I selected the following option on Setup Role: I selected all features that are available: I went ahead and choose the default values on all the screens, and here...

SQL Server 2012 can now be installed on a Server Core installation of Windows Server 2008 R2 SP1. My previous blog posts has those details about installing Windows in Server Core mode, and configurations needed on the operating system. I worked on a technet...

In Step-by-step procedure for Installing SQL Server 2012 on Windows Server 2008 R2 Server Core : PART 2 , we covered details about Add the machine to a domain, Add an administrator and Rename the Server. You can achieve all these specified tasks in a...

We all know about the Popup windows being used in Windows based .NET applications, and its usability. In ASP.NET Web based applications we don’t have any control that can be used to accomplish this. There are some third party controls which can...

Configuring Windows Server 2008 R2 Server Core Find the domain: To identify the domain of the computer you are connected to, run the following command from command prompt: systeminfo | findstr /B /C:"Domain" Add machine to the domain: At a command...

Starting SQL Server 2012, you can now install SQL Server on a Server Core operating system. For more information, see : Install SQL Server 2012 on Server Core What is Server Core Installation? The Server Core installation option for the Microsoft Windows...

Problem Description: This is regarding the SQL Server 2005, SP4 Installation. This is in reference to: http://support.microsoft.com/kb/2463332 There had been a lot of issues being reported on MSDN Forums, about the installation failures. About the patch...

Check the new BI Labs site from Microsoft: http://www.microsoft.com/BI There are some exciting new tools/samples being published on the BI Labs site. Check them over here: http://www.microsoft.com/bi/en-us/Community/BILabs/Pages/Home.aspx They are: PivotViewer...

Reporting Services LogViewer Tool Sample is developed in Microsoft Windows Presentation Foundation ( WPF ) in Visual C# using Microsoft Visual Studio 2010. The sample demonstrates how to read and analyze the Reporting Services trace logs and the Report...

Adding some of the useful tools, and reports for SQL Server Installation. SQL Server Setup Discovery Report: The SQL Discovery report can be used to verify the version of SQL Server and the features installed on the computer. To open the SQL Discover...

1. Test the connectivity using UDL file: To create a Universal Data Link (.udl) file Open Windows Explorer . Select the folder in which you want to store the .udl file. Create a new Text Document under this folder. A new file named New Text Document.txt...

The forms authentication sample: http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008%21Security%20Extension%20Sample&referringTitle=Home , is strictly for educational purpose only. They are not intended to be used in a production environment...

I had worked with a few customers in the past who had the following requirement. Using web ReportViewer control. Rendering a Server Report Providing an option to create a Copy of the existing report with some specified set...

The functionality of managing permissions via SQL Server Management Studio had been removed in Reporting Services 2008. A new sample, RSPermissions which demonstrates how to write an application which manages Reporting Services permissions via the Reporting...

Once we create an UDL File and run it on 64 Bit OS, it will list down all the 64 bit OLE DB providers installed on the machine. The reason behind for this is simple. When you double click on a UDL file on a 64 bit machine, it’ll enumerate only the...

Question: How to display Dynamic Data in the ReportViewer Control. Scenario: Imagine having a ReportViewer Control on either Winforms or Webform. We use a SQL Query to fetch the data and have a dataset returned as a result of executing the SQL Query...

If we are trying to insert a page break after a Rectangle based on a Conditional Expression, that does not work. Work around: You need to next two rectangles inside one another. Apply the conditional (apply the conditional expression) formatting...

Problem Description: ======================================================================= - We had a report that displays the Japanese characters. When we try to export the report to either PDF or TIFF format we don’t see these Japanese characters...

Report Manager and Report server may take time for the first time after we do an IIS Reset or a recycle of the application pool. For the first time Report Manager might take a few seconds, and that is expected. But if it takes either 2 or 3 minutes...

There are scenarios where we do not see the Report Builder visible while trying to browse the Report Manager. This can be on the same domain or from a different domain. If we are accessing from a different domain, (Both the domains are trusted among each...