Visual Studio 2017 has landed

On 7, 8 March 2017, Microsoft celebrates 20 years of Visual Studio, announce the release of Visual Studio 2017.

Visual Studio 2017 has landed

If you missed anything from the Visual Studio 2017 launch, catch up on all the news, the keynote, and technical sessions on demand. Watch Now

In this article, I will briefly answer the following questions

Continue reading “Visual Studio 2017 has landed”

Advertisements

Is SQL Server 2016 SP1 supported for SharePoint 2016?

It’s heavily recommended to check the Hardware and software requirements for SharePoint Server 2016 before you are going to Install SharePoint 2016,

In Hardware and software requirements for SharePoint Server 2016 article, specifically in Database Server requirements section, you will note that the database server requirements is one of the following:

  • The 64-bit edition of Microsoft SQL Server 2014 Service Pack 1 (SP1)
  • Microsoft SQL Server 2016 RTM.

sql-server-2016-with-sharepoint-2016

Actually, that made me puzzled to maintain the compatibility of SQL Server 2014 SP2 or SQL Server 2016 SP1 with SharePoint 2016! until
Continue reading “Is SQL Server 2016 SP1 supported for SharePoint 2016?”

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”

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.”