Test the SQL Server User's Credentials for the Database using .UDL files

1.create note pad and save As .udl extension files in to your system
2.Open that file and enter user name and password
3.Click on the Test Connection.

 

App Management Service for Sharepoint 2013 SP Desinger Workflows

I've created SP 2013 simple workflow using SP Designer 2013. I've set up my environment as described in msdn documentation. But when I'm trying to deploy the solution I'm receiving following exception:

Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this
application.
   at Microsoft.SharePoint.SPRoundRobinServiceLoadBalancer.BeginOperation()
   at Microsoft.SharePoint.Administration.SPServiceApplicationProxyBase`1.ExecuteOnChannel(Boolean
requireDelegation, Action`1 codeBlock)
   at Microsoft.SharePoint.AppManagement.AppManagementServiceApplicationProxy.GetScaleOutDatabaseMap()
   at Microsoft.SharePoint.SPScaleOutDatabaseMap.GetMapCacheEntries

Solution:

Just resolved.

I found following message in ULS:
"There are no instances of the App Management Service started on any server in this farm. Ensure that at
least one instance is started on an application server in the farm using the Services on Server page in
Central Administration."
I went to CA -> System Settings -> Services on server and started App Management Service. Then performed
iisreset and the workflow deployed successfully.

 

Delete Sharepoint Published Infopath Column using sharepoint Manager

The Infopath form has published in the Sharepoint Form library . After published the promoted fields is added in the respective form library. You can not remove the column because it is read only.

Solution:

You can open Sharepoint Manager and Open the Web,Form Library and set the specific column Allow deletion to yes, Save and delete the column.

 

C# Log File Code could not create log files in the Production server(EventLogEnryType)

I did the Timer job for reading SharePoint Lists and Writing Log files in the C Drive\Test.

When I run this code in my Test Machine and UAT server. Log files has created properly in that Particular folder. But When I run in the Production server, It could not create the Files in that Folder.

Solution:

Please check you Production server environment, Is it any Web Front end server has configured?

So if it has configured then You have to create the Log Folder Structure in that Web Front end server.

Then it will create and write Log files in any server(App server or Web front end servers).

WSS 3.0 Central Admin Screen

The screens below are the Windows SharePoint Services 3.0

 

How to Enable Sign in as Different User Option in SharePoint 2013

Problem

By default in SharePoint 2013 there is no option for "Sign in as different user".

Use the following procedure to enable this in SharePoint 2013.

Solutions

Step 1

Go to the location:
C:\Program Files\Common Files\microsoft shared\Web ServerExtensions\15\TEMPLATE\CONTROLTEMPLATES
Here we have a file named "welcome.ascx".
We need to edit this file to enable the option.

Step 2

Open the welcome.ascx file in Visual Studio or in Notepad and add the following code

<SharePoint:MenuItemTemplate runat="server" ID="ID_LoginAsDifferentUser"  Text="<%$Resources:wss,personalactions_loginasdifferentuser%>"  Description="<%$Resources:wss,personalactions_loginasdifferentuserdescription%>"  MenuGroupId="100"  Sequence="100"  UseShortId="true"  />

before the content SharePoint:MenuItemTemplate runat="server" ID="ID_RequestAccess"

and save it:

 
Step 3

Refresh the site and then "Sign in as different user" will be enabled.

How to Enable Sign in as Different User Option in SharePoint 2013

Problem

By default in SharePoint 2013 there is no option for "Sign in as different user".

Use the following procedure to enable this in SharePoint 2013.

Solutions

Step 1

Go to the location:
C:\Program Files\Common Files\microsoft shared\Web ServerExtensions\15\TEMPLATE\CONTROLTEMPLATES
Here we have a file named "welcome.ascx".
We need to edit this file to enable the option.

Step 2

Open the welcome.ascx file in Visual Studio or in Notepad and add the following code

<SharePoint:MenuItemTemplate runat="server" ID="ID_LoginAsDifferentUser"  Text="<%$Resources:wss,personalactions_loginasdifferentuser%>"  Description="<%$Resources:wss,personalactions_loginasdifferentuserdescription%>"  MenuGroupId="100"  Sequence="100"  UseShortId="true"  />

before the content SharePoint:MenuItemTemplate runat="server" ID="ID_RequestAccess"

and save it:

 
Step 3

Refresh the site and then "Sign in as different user" will be enabled.