Issue SSL Certificate from the https://cheapsslsecurity.com using the CSR

Generate SSL Certificate: go to the recent order and click on the certificate and

• Chose the domain validation option “Email Authentication” for this you have the access of one of the following emails:

1. admin@yourdomain.com
2. administrator@yourdomain.com
3. webmaster@yourdomain.com
4. postmaster@yourdomain.com
5. hostmaster@yourdomain.com

• Input CSR (Certificate Signing Request)
• Select Your Server(optional) – left this as default or select “Microsoft Internet Information Server”
• Select the Signature Algorithm – choose SHA2
• Click on the continue – this will send a verification email of the selected email in the step Verify the verification – please verification by clicking the link received in the mail
• Get SSL Certificate – You will receive a SSL certificate in the Mail

How to Install an SSL certificate on IIS

Install an SSL certificate on IIS

• Press Win + R and type “inetmgr” in the appeared window to run the Internet Information Services (IIS) Manager.
• On the IIS Manager home page, locate the “Server Certificates” icon and double-click it:
  
  
  
• Locate the “Actions” panel on the right side and click “Complete Certificate Request”:
  
• In the “Specify Certificate Authority Response” window, perform the actions below.

1. In the “File name containing the certification authority’s response” field, browse the file system to select your .p7b (or .cer) certificate.
2. In the “Friendly name” field, specify any name that will help you to identify the certificate among other files. It is best to submit the actual domain name of the certificate.
3. In the “Select a certificate store for the new certificate” field, leave the default value “Personal”.
   

• Click “OK” to import the certificate to the server storage.
• Once the import is completed, in the “Server Certificates” window, you will see a new entry associated with the imported certificate:
  
•  Assign the certificate to your website by expanding the “Sites” subsection in the “Connections” menu on the left and select the corresponding site. Then, in the “Actions” panel on the right side, locate the “Edit Site” menu and select the “Bindings” option:
  
• On the right side of the “Site Bindings” window, click “Add”: 
  
• In the “Add Site Binding” window, modify the fields as below:

1. In the “Type” field, select “https”.
2. In the “IP address” field, select your website’s IP address or “All Unassigned”.
3. In the “Port” field, specify “443” (default).
4. In the “SSL certificate” field, select the previously imported certificate, which can be identified by the friendly name:
   NOTE: The “Require Server Name Indication” box needs to be checked if there are multiple SSL certificates on the server.

• Click “OK” in order for the new “https” entry to appear in the “Site Bindings” window:
  
• That’s all - the certificate should now be installed and the website should be accessible via HTTPS.

How to Generate CSR from Microsoft IIS 7/ IIS 8/ IIS 10

Generate a CSR from Microsoft IIS

• Open Internet Information Services (IIS) Manager - Click Start, Control Panel, Administrative Tools, and then select Internet Information Services (IIS) Manager.
• Open Internet Information Services (IIS) Manager - In the left Connections menu, select the server name (host) where you want to generate the request.
• Navigate to Server Certificates - In the center menu, click the Server Certificates icon under the Security section near the bottom
  
• Select Create a New Certificate - In the right Actions menu, click Create Certificate Request.
  
• Enter your CSR details - In the Distinguished Name Properties window, enter in the required CSR details and then click Next.
  Note: To avoid common mistakes when filling out your CSR details, reference 
• Select a cryptographic service provider and bit length - In the Cryptographic Service Provider Properties window, select Microsoft RSA Channel Cryptographic Provider and Bit Length of 2048, then click Next.
  Note: Bit Length: 2048 is the current industry standard. You may choose a larger key size, but only if you have a requirement to do so, as longer key lengths increase latency and may reduce compatibility.
• Save the CSR - Click Browse to specify the location where you want to save the CSR as a “.txt” file and click Finish.

How to generate CSR, purchase SSL from cheapest SSL and Install On IIS

Generate a CSR from Microsoft IIS

• Open Internet Information Services (IIS) Manager - Click Start, Control Panel, Administrative Tools, and then select Internet Information Services (IIS) Manager.
• Open Internet Information Services (IIS) Manager - In the left Connections menu, select the server name (host) where you want to generate the request.
• Navigate to Server Certificates - In the center menu, click the Server Certificates icon under the Security section near the bottom
  
• Select Create a New Certificate - In the right Actions menu, click Create Certificate Request.
  
• Enter your CSR details - In the Distinguished Name Properties window, enter in the required CSR details and then click Next.
  Note: To avoid common mistakes when filling out your CSR details, reference 
• Select a cryptographic service provider and bit length - In the Cryptographic Service Provider Properties window, select Microsoft RSA Channel Cryptographic Provider and Bit Length of 2048, then click Next.
  Note: Bit Length: 2048 is the current industry standard. You may choose a larger key size, but only if you have a requirement to do so, as longer key lengths increase latency and may reduce compatibility.
• Save the CSR - Click Browse to specify the location where you want to save the CSR as a “.txt” file and click Finish.

Purchase SSL Certificate from cheapsslsecurity.com

Generate SSL Certificate: go to the recent order and click on the certificate and

• Chose the domain validation option “Email Authentication” for this you have the access of one of the following emails:

1. admin@yourdomain.com
2. administrator@yourdomain.com
3. webmaster@yourdomain.com
4. postmaster@yourdomain.com
5. hostmaster@yourdomain.com

• Input CSR (Certificate Signing Request)
• Select Your Server(optional) – left this as default or select “Microsoft Internet Information Server”
• Select the Signature Algorithm – choose SHA2
• Click on the continue – this will send a verification email of the selected email in the step Verify the verification – please verification by clicking the link received in the mail
• Get SSL Certificate – You will receive a SSL certificate in the Mail

Install an SSL certificate on IIS

• Press Win + R and type “inetmgr” in the appeared window to run the Internet Information Services (IIS) Manager.
• On the IIS Manager home page, locate the “Server Certificates” icon and double-click it:
  
  
  
• Locate the “Actions” panel on the right side and click “Complete Certificate Request”:
  
• In the “Specify Certificate Authority Response” window, perform the actions below.

1. In the “File name containing the certification authority’s response” field, browse the file system to select your .p7b (or .cer) certificate.
2. In the “Friendly name” field, specify any name that will help you to identify the certificate among other files. It is best to submit the actual domain name of the certificate.
3. In the “Select a certificate store for the new certificate” field, leave the default value “Personal”.
   

• Click “OK” to import the certificate to the server storage.
• Once the import is completed, in the “Server Certificates” window, you will see a new entry associated with the imported certificate:
  
•  Assign the certificate to your website by expanding the “Sites” subsection in the “Connections” menu on the left and select the corresponding site. Then, in the “Actions” panel on the right side, locate the “Edit Site” menu and select the “Bindings” option:
  
• On the right side of the “Site Bindings” window, click “Add”: 
  
• In the “Add Site Binding” window, modify the fields as below:

1. In the “Type” field, select “https”.
2. In the “IP address” field, select your website’s IP address or “All Unassigned”.
3. In the “Port” field, specify “443” (default).
4. In the “SSL certificate” field, select the previously imported certificate, which can be identified by the friendly name:
   NOTE: The “Require Server Name Indication” box needs to be checked if there are multiple SSL certificates on the server.

• Click “OK” in order for the new “https” entry to appear in the “Site Bindings” window:
  
• That’s all - the certificate should now be installed and the website should be accessible via HTTPS.

How to add ads.txt to blogger.com?

Set up an ads.txt file

If your blog is monetized with third-party providers or you’ve manually integrated AdSense in your blog, you will need to manually set up the content of the ads.txt file.

1. Sign in to Blogger.
2. In the top left, click the Down arrow  .
3. Click the blog you want to set up an ads.txt file on.
4. On the left, click Settings.
5. Under "Settings," click Search preferences.
6. Under "Monetization," find "Custom ads.txt" and click Edit.
7. Click Yes.
8. Copy the settings from your third-party monetization provider and paste them in the text box.
9. Click Save settings.
10. Optional: To check the content of your ads.txt file, go to http:///ads.txt.

Note: If your blog is not monetized, or it’s only configured to use AdSense using the Blogger-AdSense integration, then you do not need to manually set up ads.txt. Blogger will do this for you. Read more about ads.txt for AdSense.

reference has been taken from https://support.google.com/blogger/answer/1269077?hl=en

Sql-Server the Select permission was denied on the object 'types', Error 229

Please check that you didn't check the following  DB role:
1. db_denydatareader
2. db_denydatawriter

Please uncheck both of them, this will solve your problem.

Steps to uncheck the roles:

1. Open SQL Management Studio
2. Expand your database
3. Expand the "Security" Folder
4. Expand "Users"
5. Right click the user (the one that's trying to perform the query)
6. Make sure you uncheck

Contact Form 7 reCAPTCHA not showing

Contact Form 7 latest version not supporting the reCAPTCHA, So, We need to downgrade the Recaptcha plugin,

Steps to Rollback the Contact Form 7 :

1. Install the Plugin "wp rollback".
2. After Installing go to the plugins, you will find an option below all the plugins for rollback.
3. So, rollback the Contact Form 7  from 5.1 to 5.0.5
4. After this go to integration on the contact form and paste your keys again like you did in the beginning.
5. Open your contact form on the backend and save it again. Make sure you add the recaptha again
6. Now go to your front-end and refresh your page.And your done!

Wait for next update with the fix.

No need te install any other plugins.

RadTimePicker, showing error as " 'SelectedDate' should be between 'MinDate' and 'MaxDate'".

The default minimum date for the RadDatePicker is 01/01/1980. So, when you try to assign the value this than this date you will get the below error:

if you will set the Mindate of RadDatePicker to a minimum range than this will fix the issue

ID="RadDateofBirth" DateInput-DateFormat="dd/MM/yyyy" MinDate="01/01/1940" DateInput-DisplayDateFormat="dd/MM/yyyy" runat="server">

This will solved the issue.

Microsoft SQL Server - How to check all empty tables in database?

Process to check all empty tables in a Database:

1. Select the database in the SSMS and open the "New Query" window.
2. Run the below query.

SELECT sch.name as SchemaName, t.NAME AS TableName,  p.rows AS RowCounts
FROM   sys.tables t
INNER JOIN  sys.partitions p ON t.object_id = p.OBJECT_ID
INNER JOIN sys.schemas sch on t.schema_id = sch.schema_id
WHERE  t.NAME NOT LIKE 'dt%'   AND t.is_ms_shipped = 0   AND p.rows <=0
GROUP BY  sch.name,t.Name, p.Rows
ORDER BY  sch.name,t.Name

System.InvalidOperationException: 'String[n]: the Size property has an invalid size of 0.'

This error occurs generally when we are not passing the Output parameter in the SqlDbType.VarChar value like the below example

SqlParameter job1 = cmd2.Parameters.Add("@job", SqlDbType.VarChar);
job1.Direction = ParameterDirection.Output;

You need to define a length when specifying SqlDbType.VarChar parameter, So

SqlParameter job1 = cmd2.Parameters.Add("@job", SqlDbType.VarChar, 50);

You should use the same length as defined in your SQL Server stored procedure.