Melick's Blog

Getting started with NEW Office 365 As you may already know, Office 365 comes with different subscription models. First you need make you’re your billing address is available in supported countries. You can find the geographical availability by referring below URL. https://products.office.com/en/business/international-availability Once you are confident with your location you can check the available subscription plans. Available Plans:    https://products.office.com/en/business/compare-more-office-365-for-business-plans# There are trial versions and service descriptions are clearly available in above link. Once you are done with the payment you will be redirect to a page with an introduction wizard, where you will be highlighted with main sections in Office 365. I will provide a detailed article later in my post. But for the moment I will summarize the main Highlights.     These screens talking about everyth...

This is a bit of a DBA task. I have come across with a situation which I want to check Cross Database Reference for SharePoint Service Application databases like ReportingService_ServiceApplication_DB You can use following SQL scripts to find database cross references and references with in the Database. Database Cross References SELECT  OBJECT_NAME (referencing_id) AS referencing_object, referenced_database_name,  referenced_schema_name, referenced_entity_name FROM sys.sql_expression_dependencies WHERE  referenced_database_name IS NOT NULLAND is_ambiguous = 0;  Object References with in the Database SELECT  OBJECT_NAME (referencing_id) AS referencing_object, referenced_database_name,  referenced_schema_name, referenced_entity_name FROM sys.sql_expression_dependencies WHERE is_ambiguous = 0; 

“This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator. To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold.” And if you are more dig in to it, the error will be occur in your Web Parts Custom Scripts SharePoint Apps CAML Queries Which is related to that list. First we have a look why this is happening. The Live View Threshold is item count which is limited by SharePoint Administrator to process by SharePoint server at a time. Further elaborating when you are viewing or query (CAML, ODATA, and REST) against the list SharePoint will process the entire set of items to get the required results even though you have mentioned limits or filters unless it is not indexed. Thus when it is exceeding threshold limit (5000 default) SharePoint will throw ...

This article breaks into three sections. Identify and Cause Add Exception to Strict Name Checking Disable Loopback Identify and Cause There are many reasons to happen this but most of the time it will happen when you change the Access mapping to match your domain. For an example you might have webwfe01 as your web application in your default zone. And if you change that to www.sampleweb.com this may be occurred for Windows Users. This is because by not having Fully Qualified Domain name specified is not matching with the local machine. For an Example, Your local machine can be in a domain myorg.com and the specified Mapping is sampleweb.com Thus this will cause LoopBack check which it true by design for security reasons. Microsoft specifies two methods to resolve the issue. Disable Strict Name Checking Disable Loopback Check REF: https://support.microsoft.com/en-us/help/896861/you-receive-error-401.1-when-you-browse-a-web-site-that-uses-integrated-authentication-and-is-...

  Quick Tip : I have configured the membership provider to work with ASP.NET application which is going to deploy in to the SharePoint. But when I used FormsAuthentication.SetAuthCookie() to set the Authentication Token it doesn’t work for me. I have tried disabling anonymous authentication but still didn’t work. Then I changed the FormsAuthentication.SetAuthCookie() method to following set of lines and ultimately worked. FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(txtUserName.Value, false , 60); string encTicket = FormsAuthentication.Encrypt(ticket); Response.Cookies.Add( new HttpCookie(FormsAuthentication.FormsCookieName, encTicket));

“You are being redirected to the following url that was not registered as the app launch url https://xx?SPHostUrl=xx&SPLanguage=enSPClientTag=0&SPProductNumber=xx&SPAppWebUrl=xx&{AppContextToken} If you trust this url, click here to proceed to the app now. Otherwise go back to the previous page or close this page." It is common that you may have encountered this kind of an error when you are accessing an App that you have developed and published to the SharePoint 2013. There can be many deep reasons behind the message such as Not provisioning the app web correctly Errors on App management service But most of the time it is because of not registering your app in the SharePoint. You can simply follow following steps to register your app in the current SharePoint site. First go to Appreg.aspx page which used to register the app in http:// xxx/_layouts/15/Appreg.aspx . Then you will find a following interface where you can register your app wit...

Insufficient SQL database permissions for user 'Name: doman\SP_UserProfiles SID: S-1-5-21-2738186777-3937669245-3595685374-1123 ImpersonationLevel: None' in database 'SharePoint_Config' on SQL Server instance 'ADXWSQL.adxweb.ae'. Additional error information from SQL Server is included below. The EXECUTE permission was denied on the object 'proc_putObjectTVP', database 'SharePoint_Config', schema 'dbo'. This is a caused by not having permission to database objects of using least privileges configuration in farm configuration. Thus you need to give permission exclusively to this Object. First you need to Connect to SharePoint Database using privileged account. Then go the SharePoint Config Database and security section. Then go to Roles and find WSS_Content_Application_Pools under the Database Roles section. Double click (or Right Click -> Properties) the item and select the Securable section in the modal window. And click Searc...