The URL is not available, does not reference a SharePoint site, or you do not have permission to connect

I am trying to connect SharePoint URL in dashboard designer,it prompt's a message

"The URL is not available, does not reference a SharePoint site, or you do not have permission to connect"

To know the more information about this
Checked the Event logs ->Event Viewer ->Windows Logs->Application logs

I am getting Error message

SQL database login for 'SharePoint_Config' on instance 'DBServerName' failed. Additional error information from SQL Server is included below.
Login failed for user 'domain\userName'.

This account dont have permissions on the SQL database.
Run this below script in SharePoint 2013 Management Shell

$w = Get-SPWebApplication ("Web Application Name")
$w.GrantAccessToProcessIdentity("domain\userName")

This command will do the following

Creates a domain\userName as a new user for the DB associated with the web application Name.
Assigns db_owner role to domain\userName
It will creates a new schema for domain\user Name


The Datasource cannot be used because PerformancePoint Services is not configured correctly

The Datasource cannot be used because PerformancePoint Services is not configured correctly
When we trying to create a datasource for PerformancePoint Services(PPS),Getting the error.

The Datasource cannot be used because PerformancePoint Services is not configured correctly

This Cause of this error, we did not configured PPS correctly.

Navigate to Central Admin->Application Management->Manage Service Application

Click on the "Performance Point Service" and select the "Performance Point Service Application Settings"

Give  the Unattended Service account Username and Password,Click ok.

Now go and try the selecting the database in Dashboard Designer.


SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to download all wsp files from Central Admin

How to download all wsp files from Central Admin

If you want to take the backup of all the wsp files from your central admin.

Use this Power shell Script.


$pathName = "c:\WSPFiles\"
foreach ($solution in Get-SPSolution)
   {
 
    $solid = $Solution.SolutionID
    $title = $Solution.Name
    $filename = $Solution.SolutionFile.Name
    $solution.SolutionFile.SaveAs("$pathName\$filename")
}


SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to download WSP file Central Admin

How to download WSP file Central Admin
Some times we need to take the backup of WSP file,if you don't have back of the old WSP file
we can get it easily from central admin,before deploying the new WSP.

 using power shell run this below script.

$SPFarm = Get-SPFarm
$getWSP = $SPFarm.Solutions.Item(“dotnetsharepoint.wsp”).SolutionFile
$getWSP.SaveAs(“C:\dotnetsharepoint.wsp”)

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to configure SharePoint Outgoing Email Settings using powershell

I prepared a script,easy way to configure the outgoing email using powershell.

Here we check the image before executing the script


$SMTPServer = 'mail.dotnetsharepoint.com'
$FromAddress = 'jlakshmitulasi@dotnetsharepoint.com'
$ReplytoAddress = 'jlakshmitulasi@dotnetsharepoint.com'
$Charset = 65001

$CAWebApplication = Get-SPWebApplication -IncludeCentralAdministration | Where { $_.IsAdministrationWebApplication }
$CAWebApplication.UpdateMailSettings($SMTPServer, $FromAddress, $ReplytoAddress, $Charset)


Here we can check the output after executed the script
                            

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Activating and Deactivating Features in a SharePoint Site Collection Using Power Shell

If we want to know the list of features activated in your Site Collection
Run the following command in SharePoint 2013 Management shell



It will gives list of features with DisplayName,ID

For activating or deactivating  the feature use we can do based on Feature Name or Feature ID

Activating the Feature:

Enable-SPFeature –Identity FeatureIDhere –url  http://DotNetSharePoint:1234/sites/SharePoint
Or
Enable-SPFeature –Identity FeatureNamehere –url  http://DotNetSharePoint:1234/sites/SharePoint


Deactivating the Feature:

Disable-SPFeature –Identity FeatureIDhere –url  http://DotNetSharePoint:1234/sites/SharePoint
Or
Disable-SPFeature –Identity FeatureNamehere –url  http://DotNetSharePoint:1234/sites/SharePoint


SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to rename WSP file in SharePoint

The SharePoint Project name will come as a WSP name, some time when we need to rename the WSP file.

In Visual Studio->Navigate to Package->Click on the Package.package


Previous I am getting the WSP with name SharePointSolution1.WSP.



Now I want change the Name to DotNetSharePoint 


Save it.

Now I can get WSP name as DotNetSharePoint.WSP

Once it’s done, restart the visual studio get the WSP file with modified name.

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

This control is currently disabled

 When i am  trying to deploy sandbox solution in SharePoint site, it was showing an error as "This control is currently disabled".I am unable to activate the solution as shown below.



 I tried to figure out the solution that "Microsoft SharePoint Foundation Sandboxed Code Service" was not started in central admin .To resolve this issue we have to start the "Microsoft SharePoint Foundation Sandboxed Code Service".

Navigate to CA->Manage Services on Server->









SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to change the site logo in SharePoint

Sometimes we have to change the site logo based on the requirement, It is very easy to change using the Out of box feature.

Navigate to Site Settings

  Under Look and Feel
   Click on Title, description, logo

Now I am adding the logo from my computer.


Added the image click ok.

If we want to add the logo from SHAREPOINT we can add the image in “15 hive” on the file system then the URL will come as “/_layouts/Images/YourLogname.jpg”.

Logo is changed as shown below.




SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Check the Duplicates Values in SharePoint List

How to Check the Duplicates Values in SharePoint List


<div>
    <label>EmployeeName</label>
    <asp:TextBox ID ="txtempname" runat ="server"></asp:TextBox>
    <asp:Label ID ="lblerror" runat ="server" Text ="Employee Name Already Available" Visible ="false" ForeColor ="Red"></asp:Label>
</div>
<div>
    <asp:Button ID="btnInsert" runat ="server"  Text ="Submit" OnClick="btnInsert_Click" />
</div>


  protected void btnInsert_Click(object sender, EventArgs e)
        {
            using(SPSite site = new SPSite(SPContext.Current.Web.Url))
            {
               using( SPWeb web = site.OpenWeb())
                {
                   SPList list = web.Lists["EmployeeInfo"];
                   SPQuery checkduplicates = new SPQuery();

                   checkduplicates.Query = "<Where><Eq><FieldRef Name='Name' /><Value Type='Text'>" + txtempname.Text.ToString().ToLower() + "</Value></Eq></Where>";
                   SPListItemCollection myListColl = list.GetItems(checkduplicates);
                   if (myListColl.Count > 0)
                   {
                       lblerror.Visible = true;
                     
                   }
                   else
                   {

                       SPListItem item = list.Items.Add();
                       item["Name"] = txtempname.Text;
                       item.Update();
                   }

                }

            }

        }

OutPut:

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Error occurred in deployment step 'Add Solution': A feature with ID has already been installed in this farm. Use the force attribute to explicitly re-install the feature.

I am trying to deploy the solution using visual studio I am getting the error as shown below.

        Error occurred in deployment step 'Add Solution': A feature with ID  has already been installed in this farm.  Use the force attribute to explicitly re-install the feature.

This error will come mainly the feature is not retracted properly, so I am enable “Always Force Install to True” in our Feature

In our Solution Explorer Double Click on Feature, in properties windows we can able to see as shown below.

By default I will show False, Now I am changing to True.



SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Deploying Custom Master Page in SharePoint

Using Visual Studio I am deploying the master page am creating an Empty Project, in that Feature I am adding a new Feature Scope I am selecting as” Site “and adding the Event Receiver.
I am adding the module it is used to deploy files to the SharePoint Environment,
In That Module I am having sample.txt I am changing it to CustomMaster.master

Finally my solution is looks as shown below.



In Feature1.EventReceiver.cs I am adding the Below code
public override void FeatureActivated(SPFeatureReceiverProperties properties)
        {
            SPSite siteCollection = (SPSite)properties.Feature.Parent;
           SPWeb web = siteCollection.RootWeb;
            Uri masteruri = new Uri(web.Url+"/_catalogs/masterpage/CustomMaster.master");
            web.MasterUrl = masteruri.AbsolutePath;
            web.CustomMasterUrl = masteruri.AbsolutePath;
            web.Update();

        }

        public override void FeatureDeactivating(SPFeatureReceiverProperties properties)
        {
            SPSite siteCollection = (SPSite)properties.Feature.Parent;
            SPWeb web = siteCollection.RootWeb;
            Uri masteruri = new Uri(web.Url + "/_catalogs/masterpage/Seattle.master");
            web.MasterUrl = masteruri.AbsolutePath;
            web.CustomMasterUrl = masteruri.AbsolutePath;
            web.Update();
        }

Module1 in Element.xml I am adding the below lines

<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
  <Module Name="Module1" List="116" Url="_catalogs/masterpage">
    <File Path="Module1\CustomMaster.master" Url="CustomMaster.master" Type="GhostableInLibrary" IgnoreIfAlreadyExists="TRUE" />
  </Module>
</Elements>

Once completed all the steps deploy the solution in visual studio

It will be changed as our custom master as shown below.


SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

insert data into sharepoint list using gridview

I will expalin how to insert data into sharepoint list using gridview.
Now i am taking a Visual webpart,in this .ascx i am designing the screen with Employee Information like Name,Location,Phoneno,Designation.
<asp:GridView ID="gridinsertdata" runat="server" AutoGenerateColumns="False"
    CellPadding="4"   ShowFooter="True"
    onrowcommand="gridinsertdata_RowCommand" Width="700px">
        <Columns>
            <asp:TemplateField>
            <HeaderTemplate>
            <table width="100%" cellpadding="0" cellspacing="0">
            <tr>
            <td width="20%">
            Name
            </td>
             <td width="20%">
            Location
            </td>
             <td width="40%">
           Phoneno
            </td>
                <td width ="40%" >

                    Designation
                </td>
            </tr>
            </table>
            </HeaderTemplate>
            <ItemTemplate >
            <table width="100%" cellpadding="0" cellspacing="0">
            <tr>
            <td align="center" width="20%">
            <%#Eval("Name") %>
            </td>
              <td align="center" width="20%">
             <%#Eval("Location") %>
            </td>
             <td align="center" width="40%">
            <%#Eval("Phoneno") %>
            </td>
                   <td align="center" width="40%">
            <%#Eval("Designation") %>
            </td>
            </tr>
            </table>
            </ItemTemplate>
            <FooterTemplate>
            <table  cellpadding="0" cellspacing="0">
            <tr>
            <td align="center" width="20%">
            <asp:TextBox ID="txtname" runat="server"></asp:TextBox>
            </td>
            <td align="center" width="40%">
            <asp:TextBox ID="txtlocation" runat="server"></asp:TextBox>
            </td>
            <td align="center" width="40%">
            <asp:TextBox ID="txtphoneno" runat="server"></asp:TextBox>
                </td>
                   <td align="center" width="40%">
            <asp:TextBox ID="txtdesignation" runat="server"></asp:TextBox>
                       </td>
                <td>
                       <asp:Button ID ="btnSave" runat ="server" Text ="Save" CommandName ="Insert" />
                </td>
                       </tr>
            </table>
            </FooterTemplate>
            </asp:TemplateField>
        </Columns>
     
        </asp:GridView>

Now in .cs  writing the logic as shown below.

        protected void Page_Load(object sender, EventArgs e)
        {
            if(!Page.IsPostBack)
            {
                bindGrid();
            }
        }

        public void bindGrid()
        {

            SPWeb web = SPContext.Current.Web;
            SPList list = web.Lists["EmployeeInfo"];
            SPListItemCollection listcoll = list.Items;
            gridinsertdata.DataSource = listcoll.GetDataTable();
            gridinsertdata.DataBind();
        }
        protected void gridinsertdata_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
        {
            if(e.CommandName == "Insert")
            {

                SPWeb web = SPContext.Current.Web;
                SPList list = web.Lists["EmployeeInfo"];
                SPListItemCollection myColl = list.Items;
                TextBox txtname = (TextBox)gridinsertdata.FooterRow.FindControl("txtname");
                TextBox txtlocation = (TextBox)gridinsertdata.FooterRow.FindControl("txtlocation");
                TextBox txtphoneno = (TextBox)gridinsertdata.FooterRow.FindControl("txtphoneno");
                TextBox txtdesignation = (TextBox)gridinsertdata.FooterRow.FindControl("txtdesignation");
                SPListItem item = myColl.Add();
                item["Name"] = txtname.Text;
                item["Location"] = txtlocation.Text;
                item["Phoneno"] = txtphoneno.Text;
                item["Designation"] = txtdesignation.Text;
                item.Update();

                bindGrid();

            }

        }

Output:


SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Enable PowerShell ISE windows server 2008 r2

Enable PowerShell ISE windows server 2008 r2
In windows 7 or Windows Server 2008 R2 we cannot find the PowerShell ISE in start menu.
If we want to enable using power Shell
Open the Power Shell run the following commands

 1)Import Module Server Manager

Import-Module  ServerManager

2)Now Search for PowerShell ISE Feature

Get-WindowsFeature  -Name *PowerShell*

3)Now Add the Feature

Add-WindowsFeature PowerShell-ISE  



After executing the above commands we can find the PowerShell ISE in Start Menu

SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

How to check the site template of SharePoint site

How to check the site template of SharePoint site
Sometimes we have to know which site we are using in SharePoint, It is very simple using the browser we can find the site we are using.
Right click on the browser click on View Source.
Find using the “SiteTemplateId”
We can find Site Template ID Name as shown below
var g_wsaSiteTemplateId = 'BLANKINTERNET#0';

For More Information we can find the site templates with ID, Name, and Title.



SharePoint Online Real Time Training Contact: JLAKSHMITULASI@GMAIL.COM

Labels

.Net Interview Questions add custom button in sharepoint using javascript Add custom column property into a PageLayout in SharePoint Add Page Title on their browser's title bar in SharePoint Customly add zip files in blogger Add-SPOSiteCollectionAppCatalog : Must have Manage Web Site permissions or be a tenant admin in order to add or remove sites from the site collection app catalog allow list Advance SmartObject An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL. Angular 2 Angular JS Angularjs Angularjs 1 anonymous users accessing lists and libraries App Permissions for SharePoint 2013 asp.net membership unique email Asp.net TreeView Control asp.net. Attendees in SharePoint Auto refresh list using Content Editor WebPart in SharePoint 2013. Auto Refresh SharePoint list using JavaScript Block and unblock of attachment types in SharePoint Blogger C# Callouts in SharePoint 2013 Cascading Dropdown list in SharePoint change onenote to another location. change SuiteBarLeft in SharePoint 2013 check if userid exists in database c# click node text to expand/collapse in Treeview client object model Close webpart CQWP crate chart using BI site in PPS Create a modern team site collection in SharePoint online Create BI chart in PPS SharePoint 2013 create filter in dashboard designer. create kpi's in dashboard designer create kpi's in SharePoint 2013 dashboard designer Create List Create List In SharePoint Create List using Power Shell Script Create Lookup Field in List using Power Shell Script Create lookup field in List create SharePoint List custom view. create SharePoint List views in List Schema create site collection in site collection in SharePoint using powershell created Date Time calculated field in SharePoint Cross site Collection in SharePoint 2013 Crud Operation in Asp.net Using Stored Procedure Custom MasterPage Approval in SharePoint custom view for survey list Customly add SharePoint List view in Page. delete items in sharepoint using powershell Difference between Angular 1.x & Angular 2 difference between Office 365 and Windows Azure difference between Windows Azure and Office 365 in sharepoint? DifferenceBetween discussion board Display Data in Grid View display radio buttons and choice fields horizontally in SharePoint 2013 Document library DotNet Drag and drop documents in document library in SharePoint dynamically populating values from one list to another list using jquery in sharepoint edit and delete buttons in datagridview Edit Links email notification using Nintex enable anonymous access in SharePoint 2013 enable app catalog sharepoint online site collection powershell Enable appcatalog site collection level using PowerShell based on Input file Enable versions for list and library except the hidden lists using PowerShell Script Error occurred in deployment step 'Recycle IIS Application Pool': Cannot resolve model for the project package Errors&Solutions Export document library in sharepoint using powershell Export particular Group in Term Store Management in SharePoint 2013 Export to Excel first release Flow Flow features free disk space on servers using powershell Friendly URLs and Managed Navigation in SharePoint 2013 get a list of site collection with template in web application using PowerShell Script in SharePoint Get attachments in SharePoint custom list using c# get current list item id sharepoint programmatically Get current url using jquery Get data from SharePoint list using Rest api & Angular JS Get Random Get Random SharePoint items using PowerShell Get Random values from SharePoint list using PowerShell Get url of the last value using jquery Get-SPOSite : The managed path sites/yoursitename is not a managed path in this tenant. Getting Email From User Hide “Edit Links” in left navigation SharePoint 2013 hide button in sharepoint based on permissions Hide column in SharePoint List view hide fields using client side object model Hide list in Quick Launch in SharePoint using PowerShell How to add Custom Tiles to SharePoint site Page. How to add extension files in Search Navigation in SharePoint 2013 How to Add Multiple users Using SharePoint People Picker How to add SharePoint list view in Page using C# How to Approve MasterPage using PowerShell in SharePoint How to bind Multiple users Using SharePoint People Picker how to change indicators on kpi performance how to check if an email address already exists in the database in asp.net how to configure workflow manager platform for SharePoint 2013 how to create calculated value using powershell how to create certificate in SharePoint How to create flow. how to create gantt chart webpart in sharepoint how to create KPI indicators in Dashboard designer How to create moden communication site in SharePoint online How to create Multi selected filter in Dashboard How to create nintex workflow in sharepoint how to create rdlc reports in asp.net How to Display Data Grid View in ASP.net How to enable anonymous access in SharePoint How to find data in datagridview in c# How to get image names from the folder using C# how to get particular list content type id in SharePoint 2013 How to get QueryString value in SharePoint WebPart Programatically how to get the current item id for newly created item using REST API and JQuery how to hide list in sharepoint how to know who created list in sharepoint How to make a Site Collection Read-Only in SharePoint 2010 How to overlay Office 365 shared calendar on SharePoint Site how to pass jquery value to asp.net textbox control How to pass pagename as a browser's title bar in the page how to remove unused Application Pool in SharePoint how to remove zone using powershell script How to send mail to particular group of people using PowerShell how to update modified by and created by using powershell how to uplaod RAR files in blogger import csv data into sharepoint import data using powershell Import group to term store management using SharePoint 2013. InfoPath InfoPath Cascading Dropdown list Insert update delete in datagridview in C# winforms Integration from SharePoint to k2. K2 Smart Forms for SharePoint JavaScript Injection jquery K2 blackpearl K2 Designer K2 Designer Workflow. K2 smartform cascading dropdown list k2 Workflow K2 workflow to send a mail with PDF left navigation Local Term Set in managed meta data Managed meta data navigation in SharePoint 2013 Managed metadata service in SharePoint 2013. Managed Navigation in SharePoint 2013. Managed Promoted Sites. meta data navigation Microsoft Flow New Features New-SPConfigurationDatabase The user does not exist or is not unique NintexWorkFlow Office 365 OneNote overwrite existing document in sharepoint using javascript PDF Converter PDF Method in K2 Performance Point Service in SharePoint 2013 PerformancePoint Services Configurtion PerformancePoint Services Configurtion for SharePoint 2013 PerformancePoint Services in SharePoint Server 2013 Popularity trends in SharePoint 2013 Pages populate dropdown list dynamicallyusing jquery Power Shell Power shell script to get SharePoint site size. powershell read xml PowerShell Script PowerShell script to get list of users from SharePoint groups PowerShell Scripts in SharePoint 2013 Powershell to set the masterpage in SharePoint Promoted Links Promoted Sites psconfig.exe quick launch Rdlc reports Readonly Column in SharePoint Editview Realtime DotNet Interview Questions Recent Dotnet interview questions Recent SharePoint interview questions recover deleted OneNote page. OneNote content is missing Regional Settings in SharePoint 2013 Replace New Item text in SharePoint Rest API Schedule PowerShell Script Search in SharePoint 2013 Search navigation in SharePoint 2013 Secure store service SecureStore Services SecureStore Services configuration for SharePoint 2013 self-signed certificate on IIS Server Send email to members of SharePoint Group using PowerShell sharepint2010 sharepoin2010 SharePoint 2013 SharePoint 2010 SharePoint 2013 SharePoint 2013 Dashboard Designer SharePoint 2013 features SharePoint 2013 Interview Questions SharePoint 2013. SharePoint 2013.disable views from user to create SharePoint 2013.Power shell SharePoint 2013.SharePoint 2010 SharePoint 2016 SharePoint Administration SharePoint Alerts and Reminders SharePoint App Configuration SharePoint Apps SharePoint Bulk upload SharePoint Calculated field SharePoint Calendar View sharepoint interview questions SharePoint online training SharePoint Onprem vs Online SharePoint RealTime Online Training SharePoint2010 SharePoint2013 SharePoint2016 SharePointInterview SharePointOnline SharePointOnline;Restore deleted site;SharePoint 2013 show data in datagridview in C# Simple Insert update Delete Retrieve Clear in asp.net. Site Collection Operations in SharePoint 2013 Site Collection Read-Only in SharePoint 2013 site contents Sorting & Filtering SPSite Site Collection Operation parameters in SharePoint 2013 Step by step to create rdlc report in .Net Store names in text files in C# Sub site Subsite Term store management. The server was unable to save the form at this time. please try again UI New look update created by using client side object model update field values in SharePoint using powershell update items in SharePoint list using client object model update modified by field using client side object model upload zip files in blog use IsNullOrEmpty in PowerShell VirtoSoftware VirtoSofware vitrosoftware WebParts what is Document Set in SharePoint 2010 What is Filter in SharePoint Dashboard what is Limited-access user permission lock down mode feature What is Modern Team site What is Target Audience in SharePoint Who Created Site Using PowerShell Workflow in SharePoint 2013 Workflow management platform in SharePoint 2013 Workflow manager for SharePoint 2013 XSL-Template.