High availability architecture for SharePoint Farm with SQL Server Always on Availability Group-grant permission to account

July 31, 2018

Case:
Recently, I have been working with High availability architecture for SharePoint Farm with SQL Server Always on Availability Group as shown in below diagram.

Gives following error:
Database Mirroring login attempt by user ‘XXXX\YYYY$.’ failed with error: ‘Connection handshake failed. The login ‘XXXX\YYYY$’ does not have CONNECT permission on the endpoint. State 84.’. [CLIENT: 172.19.5.144]

Solution:
Need to grant permission to account which is failing to connect as per message in Errorlog.

GRANT CONNECT ON ENDPOINT::Endpoint_Mirroring TO [login_mirroring]
GO

Reference:
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-allow-network-access-windows-authentication?view=sql-server-2017

Advertisements

Microsoft Flow Presentation

June 30, 2018

Presentation

Topic: Microsoft Flow
Scope: basic
Level: Executive

Click here to download presentation


Code organization ideas-SPA-SharePoint Add-in

May 23, 2018

Don’t want to be shameless, self-promoted…….:)……But here is my folder structure for for SharePoint Add-in with following keywords.
#[Somebody might get code organization ideas.]
#[Code structure for SharePoint Add-in]
#[Folder structure for SharePoint Add-in]
#[Single Page App, SPA as of SharePoint Add-in/SharePoint Hosted App]
#[AngularJS app for SharePoint Online]
#[AngularJS based App for SharePoint 2016]
#[AngularJS Add-in for SharePoint Online]
#[AngularJS Add-in for SharePoint 2016]
#[SharePoint Hosted App]
#[Angular-UI based SharePoint development]
#[Angular-UI based Two way binding and separation of concern for SharePoint development]
#(Angular UI Grid, based client side development SharePoint development )
#[Bootstrap based SharePoint development]
#[Bootstrap-UI based SharePoint development]
#[NG-Router based SharePoint development]
#[Module loading based on RequireJS for SharePoint Add-in/SharePoint Hosted App]
#[Lazy loading of AngularJS Controllers via RequireJS for SharePoint Add-in/SharePoint Hosted App]
#[MVC based app development for SharePoint Add-in/SharePoint Hosted App]
#[MVVM based app development for SharePoint Add-in/SharePoint Hosted App]
#[MVP based app development for SharePoint Add-in/SharePoint Hosted App]
#[JS-JavaScript design pattern for SharePoint Add-in/SharePoint Hosted App]
#[JS-JavaScript OOP for SharePoint Add-in/SharePoint Hosted App]
#[SharePoint client side development-JSOM for SharePoint Add-in/SharePoint Hosted App]
#[SharePoint client side development-Rest API for SharePoint Add-in/SharePoint Hosted App]
#[John Papa, SPA ideas for SharePoint Add-in/SharePoint Hosted App]
#[ Andrew Connell – SPA ideas for SharePoint Add-in/SharePoint Hosted App]


Crystal clear focus provide a depth of knowledge.

April 29, 2018

Software Industry is evolving very fast. A lot of dimensions are there. So it is very important for a software professional to focus. Crystal clear focus provide a depth of knowledge.

My career focus is as:

  • Cloud Productivity/Platform (Office 365/Azure)
    • Collaboration and Content (SharePoint)
    • Project and Portfolio Management (Project Server)
    • Application Development

Cloud_Application_Architecture_Guide_EN_US

Application Architecture Cloud Guide attached is very important to grow knowledge about Azure design.

This guide presents a structured approach for designing cloud applications that are scalable, resilient, and highly available. The guidance in this ebook is intended to help your architectural decisions regardless of your cloud platform, though we will be using Azure so we can share the best practices that we have learned from many years of customer engagements. In the following chapters, we will guide you through a selection of important considerations and resources to help determine the best approach for your cloud application:

  1. Choosing the right architecture style for your application based on the kind of solution you are building.
  2. Choosing the most appropriate compute and data store technologies.
  3. Incorporating the ten high-level design principles to ensure your application is scalable, resilient, and manageable.
  4. Utilizing the five pillars of software quality to build a successful cloud application.
  5. Applying design patterns specific to the problem you are trying to solve.

Thanks to Microsoft and LinkedIn, for sharing the guide with me.


JavaScript in SharePoint App development / SharePoint Framework

March 31, 2018

JavaScript in SharePoint App development / SharePoint Framework.

AngularJS based App.  Angular-UI

Bootstrap based App.

choose-the-right-javascript-framework-for-your-next-web-application_whitepaper

future_of_js_2018_progress

Shared with Thanks to Progress, Telerik.


SharePoint 2016-CSOM-File Upload-via-ClientContext

February 27, 2018

Exception:
An unhandled exception of type 'System.Net.WebException' occurred in Microsoft.SharePoint.Client.dll Additional information: The remote server returned an error: (409) Conflict.

Code:
var clientContext = new ClientContext("http://myservername/sites/subsitename") { Credentials = LogonCredentials };
using (var fileStream = new FileStream(@"C:\Temp\Test.txt", FileMode.Open))
{
Microsoft.SharePoint.Client.File.SaveBinaryDirect(clientContext, "/MyDocLibraryName/Test_FromClientOM.txt", fileStream, true);
}

Reason :
• Context can be from Root site or from Sub site, does not make difference.
• Verify that Second parameter to .SaveBinaryDirect( method is right.
• API does not create a folder
• Note: Second parameter is path starting from Root Site, Not Sub site.
So ideally code should be like:
Microsoft.SharePoint.Client.File.SaveBinaryDirect(clientContext, “/sites/subsitename /MyDocLibraryName/MyFolderName/Test_FromClientOM.txt”, fileStream, true);

Enjoy SharePoint.


Free remote SharePoint online – Office 365 training – Part 3

January 21, 2018

Free remote SharePoint online – Office 365 training (3 sessions)
Participate in our free remote SharePoint online – Office 365 training.
First session 11/15/2017 – 6:00-8:00 PM Eastern time
The second session 11/22/2017 at 6:00 PM US Eastern time.
The third session 11/29/2017 at 6:00 PM US Eastern time.
Join the meeting:
https://join.me/aasoftech

Below are the link for the presentation-Recording:
(Third session)
https://recordings.join.me/KhYLlgbRTUSlAL8pIRA4Jg
https://recordings.join.me/NWD9_20C00a1ob_r3FTzcw

Download Third presentation from here.