Use SQL Server Table or View as the Calendar Plus data source

Use SQL Server Table or View as the Calendar Plus data source

Overview of Calendar Plus Configuration settings

SQL Server Table or View is one of the four available data sources for Calendar Plus.
Data Source Settings screen with the SQL Server Table or View radio button selected
When working with SQL Table or View as the data source keep in mind:

  • Icon-Warning
    SQL Server must use Mixed Authentication mode. Additional information on Mixed Authentication mode is available here

The following steps require you to have accessed the Calendar Plus Settings screens by clicking the Calendar Plus Web Part Settings button in the web parts configuration tool pane.

Step Action Result
1.

Click the SQL Server Table or View button under Data Source Settings in the navigation tool pane. Image of the Navigation Pane with the SQL Server Table or view button available. All other data source buttons are grayed out

You will only be able to select this button if SQL Table or View is selected as the Data Source Type

The SQL Server Table or View Settings will be visible on the right side of the configuration screen and is divided into two sections:

  • Required Steps: the configuration settings which must be defined to add the table or view to the Calendar Plus display

    NOTE: Only the required steps are discussed in this topic

  • Optional Steps: Modify the display options
    associated with the data source

2. Enter the Server Name of the SQL server to which you want to connect credentials

Keep in mind:
Client applications connect to an instance of Microsoft SQL server. If you used the Default Instance when creating the SQL Server, you only need to know the server name.

To connect to a Named Instance you will need to specify both the server and instance name in the Server Name field.

Enter Server name
3.

If you are connecting to a database that resides on the same server as SharePoint, check the Trusted Connection box.

This will allow you to bypass the requirement to enter authentication information as Trusted Connections utilize the current logged in SharePoint account to access the defined SQL server.

NOTE: This method is only supported on single server SharePoint Farm deployments.

Trusted connections check box
4. Enter the SQL Login Account and Password credentials if you are not using a Trusted Connection.
Icon-WarningImportant:
1. The SQL Login Account must have at least db_datareader access to the desired table or view that resides on the database specified in the Server Name field.
2. The SQL server must be configured for Mixed Authentication mode.
3. Domain Users accounts are not supported
Enter SQL credentials in the provided fields
5. Click the Load Databases button to populate the Database drop-down box, then select the desired SQL Database from the available options. Select the SQL database from the drop down selector
6. Select the SQL Table or View to display, the choose the display column from the Item Display Column drop down menu.
Calendar_SPList_Req3.png
Calendar_SPList_itemDisplay.png
7. Select the Date and Time column(s) in the list or library that will be displayed in the calendar. Enter the desired start and end date fields from the drop-down selectors Whether you see Start Date and End Datefields or Single Date field will depend on the selection made on the General Settings screen to use a …Single Date or Interval.
Image of the Base Calendar on Single Date or Interval drop down selector found on the general settings screen.
8.

Apply a filter for the content by selecting from the following options:

  • Show All Items

  • Specify Filter Conditions To Specify Filter Conditions select the radio button and set filter conditions in the 3 fields provided

Keep in mind:
1. Calendar Plus supports the two SharePoint variables; [ME] representing the currently logged in user, and [Today], representing today’s date. that can be used to specify filter conditions

2. Use the Add Filters link if you want to add another specified filter condition using AND/OR boolean operators.

3. Web part connections can be used to filter the contents of the calendar display but are not configured in the Calendar Plus web part settings. Information on using web connections is available here

9.

Stay in the SQL Server Table or View Settings screen and configure the Optional Steps associated with the data source]

OR

Use the left navigation pane and configure View Settings for the Calendar Plus web part.

Clicking Save and Close will exit the Calendar Plus Web Part settings screen

Overview of Calendar Plus Configuration settings