Wednesday, June 18, 2014

SharePoint Registration ID, List Template ID

The list template ID is required for a hardcore SharePoint developer and frequently I used to refer this. Hope some one will see this page and useful for them.

100 Generic list
101 Document library
102 Survey
103 Links list
104 Announcements list
105 Contacts list
106 Events list
107 Tasks list
108 Discussion board
109 Picture library
110 Data sources
111 Site template gallery
112 User Information list
113 Web Part gallery
114 List template gallery
115 XML Form library
116 Master pages gallery
117 No-Code Workflows
118 Custom Workflow Process
119 Wiki Page library
120 Custom grid for a list
130 Data Connection library
140 Workflow History
150 Gantt Tasks list
200 Meeting Series list
201 Meeting Agenda list
202 Meeting Attendees list
204 Meeting Decisions list
207 Meeting Objectives list
210 Meeting text box
211 Meeting Things To Bring list
212 Meeting Workspace Pages list
301 Blog Posts list
302 Blog Comments list
303 Blog Categories list
1100 Issue tracking
1200 Administrator tasks list

Tuesday, June 17, 2014

SQL Server 2012 SP1 SSRS Integration with SharePoint 2013

There are a few documents in Internet for SQL Server 2008 R2 SSRS Integration with SharePoint. But for SQL Server 2012 SP1, I couldn't find a good one. The aim is to help someone is Installing SQL Server 2012 SP2 with SSRS Integration mode and Integrate in SharePoint 2013 Server.

The below are the Important points

1. Install SQL Server 2012 featured installation with SharePoint Integrated mode (Install only)

If App server and WFE server is in a single box, then follow the steps 2 and 3
2. Install SQL Server 2012 SP1 featured installation option in "App server"
3. Choose the shared features "Reporting Services - SharePoint" and "Reporting Services Add-in for SharePoint products"



If App server and WFE server are in different box 4 to 6
4. Install SQL Server 2013 SP1 featured installation option in "App server"
5. Choose the shared features "Reporting Services - SharePoint" in "App server"
6. Choose the shared features "Reporting Services Add-in for SharePoint Products" in WFE server.


7. In app server (where we installed SSRS) you have to run the below power shell scripts

Install-SPRSService
Install-SPRSServiceProxy
get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance






Note : SSRS in integrated mode (now as a service application) needs to be installed on the SharePoint server, not the SQL
Server.Also, with 2012, you should be installing the SP1 update in order to integrate with SharePoint 2013.

Tuesday, June 10, 2014

SharePoint Secure Store Application - How to use

The main use of Secure store application is

-To store the secured credentials in encrypted format in database
-To allow a group of users to use the credentials to use applications such as Excel services, Performance point services etc.
-To Impersonate the  users to run with elevated privileges.
- The below screen shot is the example to use Secure Store Application in BCS



The below two videos demonstrates how to configure secure store application in Central admin and usage in BCS to access SQL Server.