Skip to main content


Showing posts from June, 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
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…

Hosting ASP.Net Site in IIS in Windows Server 2008 R2

I am posting this post since I had some problems while hosting a site in IIS in Windows Server 2008 R2.

To add a web site in IIS, right click on Sites in the IIS Manager and select Add Web Site as shown in the below figure.

Then you will get the Add Web Site window as shown below and enter the required details.

Physical Path should be the folder which contains the web site files and it should locate inside the C:\inetpub\wwwroot\wss\VirtualDirectories folder.

Then click Ok to complete it.
But if you try to browse the site, it will give you an error.

To avoid it and browse the web site you need to do two things.
First one is, add the IIS_IUSRS and allow full permission. To do it right click on the site and select Edit Permission as shown in the below figure.

Then go to the Security tab in the new window and add the IIS_IUSRS user and allow Full Control. Then click Ok.

Still you cannot view the page because of an authorization error.

To avoid it you need to do the second thing.
Select the site and…

Increase Virtual Hard Disk Size in Hyper-V

In some situations we may need to increase the virtual hard disk size.
We can increase the size of the disk by using Edit Disk under Actions in the Hyper-V Manager.

Then you will get a window as shown below.

Select Expand from it and click Next.

Then add the New Size as shown below and click Next.

Then you will get a Summary as shown below and click Finish to complete it.

But you cannot use that increased space straight away. When you start the Virtual Machine, previous disk size will be avilable. To add the increased capacity, go to the Disk Management window by right clicking Computer and by selecting Manage. Then right click on the partition and select Extend Volume as shown below.

Then you will get the Welcome screen as shown below and click Next.

Then you will get the Extend Volume Wizard. Give the amount to be increased as shown below and click Next.

After that you will get the final screen as shown below.

Click Finish to add that disk space.

Connect to IBM DB2 Database Using Toad

We can use Toad to explore the DB2 Database Structures. Before using Toad we need to configure IBM DB2. To configure it open the Configuration Assistant as shown in the below figure.

Then you will get a window as shown below. Select TCP/IP as the Protocol and click Next.

After that we have to provide the details of the Host and the Service.

Insert those information and click on Retrieve button to get the Port Number.

Then follow the instructions as shown in below figures.

Then launch the Toad for DB2 as shown in the below figure.

After that create a new connection right click on the Connection Manager and select Create as in the below figure.

Then you will get a window as shown below.

You can see the available databases in the Database alias.

Then provide login details and the category.