How to Install Reporting Services In Integrated Mode after SharePoint


  1. Click the Start button

  2. Click the Microsoft SharePoint 2010 Products group.

  3. Right-click SharePoint 2010 Management Shell click Run as administrator.

  4. Run the following PowerShell command to install the SharePoint service. A successful completion of the command displays a new line in the management shell. No message is returned to the management shell when the command completes successfully:

    Copy

    Install-SPRSService
    
  5. Run the following PowerShell command to install the service proxy:

    Copy

    Install-SPRSServiceProxy
    
  6. Run the following PowerShell command to start the service or see the following notes for instructions to start the service from SharePoint Central administration:

    Copy

    get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance
    

You can also start the service from SharePoint central Administration rather than running the third PowerShell command. The following steps are also useful to verify that the service is running.

  1. In SharePoint Central Administration, click Manage Services on Server in the System Settings group.

  2. Find SQL Server Reporting Services Service and click Start in the Action column.

  3. The status of the Reporting Services service will change from Stopped to Started. If the Reporting Services service is not in the list, use PowerShell to install the service.

Advertisements

What’s New in T-SQL SQL Server 2012–Result Set


Lets Build a Scenario,

Imagine your need to Standardize your Stored procedure output for dynamic batching. as a matter of fact if the output of your Stored procedure is different from what you expect your query will fail.

So you need to standardize your output from stored procedure. to Do that lets welcome the new SQL Server 2012 T-SQL Feature Result Set.

Result Set will let the format the stored procedure output to map your requirements no matter how the data is formatted internally. Lets take a look using the following code sample

EXECUTE <batch_or_proc> WITH <result_sets_option>;

Sample Code for that is

EXECUTE GetEmployees WITH RESULT SETS(
(

EmployeeId INT,

EmployeeName VARCHAR(150)

)

)

Some notes to consider when using Result Set

  • Sometimes if you want to restrict a stored procedure to return a result set you can use the RESULT SETS NONE clause.
  • The WITH RESULT SETS option cannot be specified in an INSERT…EXEC statement.
  • The number of columns being returned as part of result set cannot be changed