Extend SharePoint Trial Period

As we know, we can use SharePoint as a trial version for 180 days, but What about if the SharePoint Trial Period has been expired

the-trial-period-for-this-product-has-expired

In this article, I’ll try to answer the following questions related to SharePoint Trial Period and Licenses:

  • Is there any way to Extend SharePoint Trial Period?
  • Is there a SharePoint free key for learning and Development Purpose?
  • What should I do after the SharePoint Trial Period has expired?
  • Can I use SharePoint Trail Version in a production environment?
  • What’s the required license for SharePoint?
  • What are the types of Client Acess Licenses (CAL)?
  • Can I use the same SharePoint key for multiple servers?

Continue reading “Extend SharePoint Trial Period”

Advertisements

Scale-Out Deployment for SQL Reporting Service (SSRS)

In this article, I will elaborate How to Scale Out SQL Reporting Service (SSRS) to work with two Database Server (Always-on)?

Scenario:

I have a 2-Tire SharePoint 2013 Farm

  • 2 WFE+ APP Servers.
  • 2 Database Servers (Always-on).

SharePoint Farm 2 tire

If  you need to use Reporting Services with SharePoint. it’s recommanded to configure SSRS SharePoint integrated mode with  Reporting service application service on an indpenedent reporting server to ensure the Performance, Manageability and Security.

But in my case, the customer budget is not enough to apply the best practice, Meanwhile configuring SSRS SharePoint integrated mode with  Reporting service application service on the same WFE + APP server lead to low performance.

So I have decided to work with SSRS Native mode to ensure at least the performance and show reports inside SharePoint via:

And in this case, I should configure SSRS Native mode on both SharePoint WFE Servers because as we know the Database Servers are not accessible over the internet,

Note: If you configured SSRS native mode on only one WFE server. you will get it worked properly. but sometimes when browsing the Report Manager URL you will get 404 error!

404 - file or directory not found

Continue reading “Scale-Out Deployment for SQL Reporting Service (SSRS)”

Missing Security Section in PWA Settings

In this hint, I’ll elaborate

  • questWhy is the Security Setting missing by default in Project Server 2013 / 2016?
  • How to show the Security Setting in PWA Settings?

sharepoint-permission-mode-pwa-settings

Cause: Continue reading “Missing Security Section in PWA Settings”

An error occurred while accessing a data connection (.udcx) file that is required for this form to function correctly. The file cannot be found or you do not have permissions to access it.

Once I have published an InfoPath form that has a data connection file that stored in a data connection library, and tried to open the InfoPath form via browser, I got the following error:

An error occurred while accessing a data connection (.udcx) file that is required for this form to function correctly. The file cannot be found or you do not have permissions to access it.

n-error-occurred-while-accessing-a-data-connection-udcx-file-that-is-required-for-this-form-to-function-correctly-the-file-cannot-be-found-or-you-do-not-have-permissions-to-access-it

I am pretty sure that the connection file is found in a data connection library and I have a permission to access it.

Cause:
Continue reading “An error occurred while accessing a data connection (.udcx) file that is required for this form to function correctly. The file cannot be found or you do not have permissions to access it.”

Install and Configure SQL Server Reporting Service (SSRS)

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

sql-reporting1.pngIn this article, I will elaborate How to install and configure SQL Server Reporting Service (SSRS) native mode.

Note: The mentioned steps is valid for SSRS 2008 / 2012 / 2014.

Steps: Continue reading “Install and Configure SQL Server Reporting Service (SSRS)”

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment

I have an ASP.Net website that connects to SQL server always-on failover cluster instance.

But I have a strange behavior when I configured the Connection String inside Web.Config as SQL Authentication, the connection has been connected successfully.

Server=load balancer IP;Database=Database Name;User Id=User; Password=Password; 

Bu when I tried to configure the Connection String as Windows Authentication.

Server=load balancer IP;Database=Database Name;Integrated Security =true;

I got the following error.

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.
This could be because the pre-login handshake failed or the server was unable to respond back in time.

connection-timeout-expired.png

I made sure that the application pool service account has elevated privilege with SQL Server as public server role and user mapping database. but unfortunately, the issue still persist.

Cause: Continue reading “Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment”