Thursday, May 29, 2014

How to uninstall SQL Service Reporting Services

From SQL Server Reporting Services(SSRS) 2008, the SSRS is Internet Information Server(IIS) independence. This means there is no directory for Reporting Services under IIS.

In this case, please make sure the SSRS service is running, otherwise, we are not able to configure the Web Service URL and the Report Manager URL(means configuring the virtual directories).

Anyway, in order to uninstall SQL Server Reporting Services without uninstalling other SQL Server components, please follow this guide:

  1. In Add/Remove programs
  2. Click the 'Uninstall/Change' button for "SQL Server 2008 R2"
  3. In the coming dialog, click 'Remove'
  4. Click 'OK'
  5. In the 'Select Instance' dialog,  select the appropriate instance, and then click 'Next'
  6. In the 'Select Features' dialog, please only select 'Reporting Services'
  7. Then click 'Next' and 'Next' till the uninstalling process starting

If you have any more questions, please feel free to ask.

Wednesday, May 28, 2014

SQL Maintenance Plan error “Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter.”

Some body have this error : Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter. When i execute my maintenance plan.

 

Resolution

The issue is related to the default email profile, you have to set a default email profile in order for the maintenance plan send the email alert.

 

Please Follow These steps to Resolve this Problem

1. Go to Database mail

2. Right Click  Click on Configure Database mail.

3. wizard will click next

4.select Manage Profile security

5. Click Next

6. Beside Profile name  by default there will be no , Please make it yes

7. Finish