Search This Blog

Loading...

Saturday, November 19, 2016

SSRS Installation on Single and Multiple Servers

Please find the below steps for SSRS installation


Single Server Farm Installation
1.       Install SQL Server (Select Reporting Service - SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
3.       Install SharePoint server
4.       Run Install-SPRSService
5.       Run Install-SPRSServiceProxy
6.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
7.       Create SQL Server Reporting Service application from “Manage Service Applications)
1 SQL Server
1 SharePoint Server (APP + WFE)
SQL Server :
1.       Install SQL Server (Select Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
SharePoint Server :
1.       Install SharePoint Server
2.       Using SQL setup media that is used in the SQL server, install Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products) only – only two checkbox has to be selected
3.       DO NOT INSTALL DATBASE ENGINE
4.       Run Install-SPRSService
5.       Run Install-SPRSServiceProxy
6.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
7.       Create SQL Server Reporting Service application from “Manage Service Applications)

Multiple SQL Server + Multiple SharePoint Server
SQL Server Role – Irrespective of no of servers (only if it is clustered)
1.       Install SQL Server (Select Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products)
2.       Ensure SharePoint-native mode is not selected
SharePoint Application Server Role
1.       Install SharePoint Server with Application role
2.       Using SQL setup media that is used in the SQL server, install Reporting Service – SharePoint, Reporting Services add-in for SharePoint Products) only – only two checkbox has to be selected
3.       DO NOT INSTALL DATBASE ENGINE
4.       Till step 3 do it in all SharePoint App server, and hold for a while and continue the steps in WFE Servers
5.       Run Install-SPRSService
6.       Run Install-SPRSServiceProxy
7.       Ensure SQL server Reporting Service is started in “Manage Services on Server”
8.       Create SQL Server Reporting Service application from “Manage Service Applications)
SharePoint WFE server Role
1.       Install SharePoint Server with WFE Role
2.       Install only the Reporting Services add-in for SharePoint Products only
3.       Continue with STEP 5 in all SharePoint app servers

Saturday, September 17, 2016

SharePoint Online Navigation Enabling Access Denied - Solved with PowerShell

Check this link for resolution:

http://blogs.catapultsystems.com/hmasters/archive/2014/12/11/sharepoint-online-sorry-you-dont-have-access-to-this-page/ 

Saturday, March 19, 2016

New technologies to learn:


  • SharePoint Online 
    • SharePoint Hosted Apps
    • Provider Hosted Apps
    • App Parts
    • SharePoint Online PowerShell
    • Pulling Data from SPO User Profile into SharePoint App Part / Customizations 
    • Hosting a App in the App Store (SharePoint App Store)
    • Custom Authentication (Possible? 
  • MS Office Add-Ins 
  • Workflow Related
    • Creating a drag and drop interface which creates the activities automatically 
  • Services related
    • REST Services
    • Web APIs
    • differences between both
  • SharePoint 2016
    • What is new in features
    • What is new in capacity development 
    • What is new development 
  • .Net Development / Others
    • What is new in VS 2015
    • What is new in latest .Net Framework? 
    • MVC, MVVM
    • Angular JS
    • HTML5, CSS3
    • TFS (Team Foundation Server) - Configuration Management
    • ALM (Application Lifecycle Management)
    • XAMARIN - Cross Platform Mobile Development 
  • BI
    • SQL Server Integration Services
    • SQL Server Analysis Services
    • Power BI
    • Power BI R Script 
    • Predictive Analytics
    • Custom Visuals for Power BI
    • Power BI integration with Tally
  • Dynamics CRM 
    • CRM OOB Features, Configuration
    • CRM Development 
    • CRM Add-In Development
    • CRM Migration 
  • Office 365
    • Exchange Setup, Exchange Migration 
    • DirSync / Azure AD Connect
    • SFB Setup / Migration 
    • Yammer 
    • SharePoint Online 
    • Azure AD
  • Azure
    • Azure Virtual Networks Setup
    • Azure VMs Setup
    • Azure Monitoring
  • Mockup tools
    • Balsamiq

Thursday, March 17, 2016

Power BI Salient Features

PowerBI is certainly raising up the ranks with key differentiators as below:

1.     Updates almost every week from Microsoft
2.     Integration with SSRS 2016
3.     Custom Visuals (www.powerbi.com/visuals) where you can write your own visuals and render your business data on it
4.     Excel Add-In for Power BI (Add your Excel Pivot Tables, Charts into Power BI Dashboards)
5.     PowerPoint Add-In for Power BI (Embed Power BI Visuals into your slides)
6.     Quick Insights Feature
7.     Ever growing content packs (more than 59 as I am writing this)
8.     Third party providers for Content Packs and Connectors like Theobald software
9.     Yammer Embed Option – with the ability to have a live conversation with your colleagues along side a Power BI Dashboard
10.  Video Embed Option into your dashboard
11.  Public Web Embed Option (Ability to embed your live visual inside a web page) – see examples of what iGrid has done: http://tnceo.gov.in/en-in/SitePages/PastElection.aspx - it has 2 links, which has Power BI Dashboards to show election results
12.  Sharing your Dashboard with your customers or partners
13.  Exporting content out of a visual as CSV – for further analysis
14.  Setting alerts on data values on Mobile Apps – for instance, when profitability comes down, your mobile app can immediately alert you and you can take a quick action based on that
15.  R Integration
16.  Azure Machine Learning Integration

17.  Cortana Integration 

Monday, February 8, 2016

Power BI Clarifications - Q&A

  
1.       How can we display Power Bi Visuals inside SharePoint
a.       Can we display the whole Dashboard inside SharePoint Pages
b.       Or can we display just one Visual inside a SharePoint Page using an App?

Response : A new feature has been added to PowerBI.com which is managing of embedded codes in the Settings section of PowerBI. It was added sometime last week only.


2.       How can we provide security for our content so that – the content the dashboard uses only shows the content that the logged in user has permission to
a.       For instance, I have 5 projects (Project 100, 101, 102, 103, 104 for instance) running – we have built a dashboard to show project progress, costing details, resource details etc.
b.       Now when Project Manager 1 of Project 100 comes in, the same dashboard should show data only about Project 100 and not any other Project?
c.       That is how, how does the data security transcend to the project dashboard so that the project dashboard automatically filters and shows only the data authorized for the logged in user
Response :
This scenario is called as dynamic security and is implemented by creating a bridge table which maps each user with the projects he has access to.

Power bi supports dynamic security using analysis services connectors or enterprise gateways.

For more information you can read following articles

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-analysis-services-connector-indepth/

https://msdn.microsoft.com/en-us/library/hh479759.aspx

  
3.       Last, on the licensing
a.       We have a company of 500 users
b.       There is 1 Power BI pro license – for a Developer – who will create the Dashboard (Pulling data from an On-Premise SQL Server) and then Publish to Power BI
c.       Now, he shares this Dashboard to the other 499 users – all of these have only Power BI free license assigned
d.       So is it right to say, we have only 1 Power BI pro license and 499 Power BI free licenses?

Response : What is said is correct. 1 Pro license and 499 free licenses. The first time you share you do get a message that asks you to upgrade to Pro License for free but on clicking cancel you can see the shared dashboard.


Monday, January 4, 2016

Understanding SharePoint Share Option at Site and Document Levels

The Pre-Conditions to enable External Sharing is that, External Sharing must be turned on for that Particular Site Collection. It can be turned on at the tenant level by the Office 365 Admin and then separately can turn on or off for every Site Collection. 

It is important to understand the below scenarios, when Share Option is clicked at the Site Level: 
  • When you are logged in as a User with Full Control Permissions Or you are present in the Owners Group, you can share your Site with both Internal Users as well as External Users; When such a User shares, he also will an option to select one out of 3 permissions levels: Owner, Edit or Read - so accordingly, the Owner user can assign permissions to any of these 3 permission categories. 
  • When you are logged in as a User with Contribute Permissions (Or you are present in the Members group), you can share your Site with both Internal Users as well as External Users). A Member user cannot select the Permission category for the Invited user. The user by default gets Member permissions only. 
  • When you are logged in as a User with Read Permissions (Or you are present in the Visitors group), you can share your Site with Internal Users, but the Permissions request are only sent to the Site Owner. The Site Owner then has to login, go to Site Settings -> Site Permissions -> Click on View Permissions Requests and Pending Invitations and then Approve or Decline the request. Once Approved, then, the respective User invited by the Visitor User will get the required permissions (Member / Contribute level and the Admin can change it after Approving also). A User in the Visitors group however cannot invite External Users                                                                                                                                                                                     External User Invitations also expire in 7 days.                                                                                   
 When a single document is shared, then Get a Link option appears (this does not appear when Site level Sharing is done) and behaves as below: 
  • When a Full Control or Member user shares this, then, he / she gets an option to send a link for both View as well as Edit 
  • When a Member user shares the document, then he / she gets an option to send a link only for View 

Saturday, November 21, 2015

Sharing in SharePoint 2013 - Explained well

http://sharepoint-community.net/profiles/blogs/sharing-in-sharepoint-2013-1