Skip to main content

Posts

Showing posts from February, 2010

Email Alerts are not received...

In one of application, Email alerts are sent using SQL sp_send_dbmail stored procedure. Email alerts were working properly, but suddenly noticed email alerts are not received.

To troubleshoot the issue, first I checked the msdb.dbo.sysmail_event_log table using the below query.

SELECT log_id, event_type, log_date, description, process_id, mailitem_id, account_id, last_mod_date, last_mod_user
FROM
msdb.dbo.sysmail_event_log 
ORDER BY
log_date DESC

If there is any error, you should see records with the event_type value as error.
In my case there are records with event_type value as error, and the description value for those records is same as below

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2018-02-01T10:41:27). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: Authentication required).  )

As per the error descript…

SQL Server 2008 Installation Failed....

While trying to install SQL Server 2008 in Windows XP, I got a error in "System Configuration Check"
The error is Rule "Performance counter registry hive consistency check" failed. The performance counter registry hive is corrupted.
The problem occurred since the installation trying to read the above register value and does a calculation on Last Counter and Last Help.
We can solve this issue by changing the those Last Counter and Last Help values

Type regedit in the Run and press Enter. It will open Registry Editor window.




Open the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009.
Then you will get a screen as shown in below figure.



Double click on Counter record to get a window as shown below.



Then scroll to the second last line and you will see a number like 3422 as shown in the below figure and remember it.


This is the Last Counter number that the system uses.

Then do the same thing for the Help record too and it is the Last Help number that the…

Make the starting point of a the X-Axis as the Y-Axis in an Area Chart of SSRS

You can make the starting point of a the X-Axis as the Y-Axis in an Area Chart of SQL Server Reporting Services easily. Initially the Chart will be as shown below.



First right click on the the X-Axis and select Axis Properties.
Then you will get the "Category Axis Properties" window and change the Side margins property to Disabled as shown below.



It will do the task and you will get a chart as shown below.




That's all...