Unable to Create a Search Managed Property

While i was trying to create a new Search Managed Property against a crawled property using either PowerShell or UI I am gettin an error "There was an internal problem connecting to or querying the database".

I spent enough time in figuring out the problem. At last I have identified that the Search Service Application doesn't have a valid Administrator who has access to SSA database.
Note: The mappings will be created in DB MSSManagedProperties table.

Administrator can be added by going to Central Administration --> Manage Service Applications --> Select Search Service Application --> Click on Administrators (Ribbon) --> Add an user with Full control (who has proper privileges to DB).

This process will provide the needful privileges to SSA to add the new search managed properties.

Why Office 365 APIs

What is Office 365 APIs:

Office 365 APIs are collections of tools that simplify building Office’s cloud services into your apps.

The Office 365 APIs are REST services that provide access office 365 services like mail, calendars, and contacts from Exchange Online; files and folders from SharePoint Online and OneDrive for Business; users and groups from Azure AD.

Why Office 365 APIs & Advantages of Office 365 APIs:

·    Extend Office everywhere.

·    General availability of new Office 365 APIs for mail, files, calendar and contacts.

·    Build on an Open Platform - Apps for mobile, web, and desktop.

·    Visibility for developers’ apps through the new Office 365 app launcher.

·    Office 365 and Azure Active Directory as hubs where apps store files and users build collaborative relationships with others.

·    Building the Office 365 platform on open standards such as HTML5, REST web services, and OAuth.

·    Microsoft is providing SDKs for common platforms to access o365 REST APIs includes mobile SDKs for native app development.

·    Microsoft is exposing O365 to apps by making call against REST APIs.

·    REST and OData are used to transfer data, JSON for data abstraction.

·    Authenticate users using single sign-on with Azure Active Directory (Azure AD) to access all office 365 services.

·    OAuth version 2.0 for authentication that means application does not have to handle or store user credentials and makes it possible to request tightly scoped permissions to user data.

·    Automatically determine URL of O365 services using discovery capability.

·    Office 365 App also supports multi tenants.

·    Support rich query filters.