401 Unauthorized errors on SharePoint 2013

In my SharePoint 2013 development environment I found a new issue which was not happened in past, I suddenly ran into 401 unauthorized errors.
Those errors would occur only when the pages would be rendered through the /_layouts/15/start.aspx page. This specific page is responsible for loading pages from a site using the Minimal Download Strategy feature, a new feature in SharePoint 2013 that improves client rendering performance and fluidity for navigating from one page to another page by downloading only the changes between two pages.

Error:
401 unauthorized

Solution:
If you are experiencing those 401 unauthorized errors, simply disable the following feature for now.
Site Settings > Manage Site Features > Minimal Download Strategy (see the image below)

Happy SharePointing...!!!

Error occurred in deployment step 'Recycle IIS Application Pool': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.

Error:
Error occurred in deployment step 'Recycle IIS Application Pool': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm. (see the image below)

Cause:
Your login user has no 'db_owner' access for SharePoint Databases.

1. SharePoint_Config

2. SharePoint_AdminContent_[XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX]

3.Your web application DB in which you want to deploy WSP (Example. WSS_Content_XXXX)

Solution:

Now connect your SQL Server with admin user.

Then select your user which has error in deployment.

Then assign all above DBs to db_owner rights. (see the image below)

Now try to deploy your WSP.

You can successfully deploy WSP.

Happy SharePointing...!!!

The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020)

Today I am trying to open my SharePoint port 80 Site in my Laptop which has installed window 7 Ultimate 64 bit OS.

But can't open site in browser so I have checked IIS Manager and seen port 80 site is stopped. So I have tried to start that site but can't start and error fire as below.

Error: The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020)  

Cause: After few minutes of research, I have seen one problem. Problem was Skype is by default use port 80 that's why I faced the issue.

Resolution: Go to Skype > Tools > Advance (left side Tab) > Connection > Now unchecked port 80 as per below screen.









Happy SharePointing...!!!

SharePoint Foundation 2013 Error : ErrorCode:SubStatus:Service running under Network Service account in workgroup environment is not supported.

Environment: Windows Server 2012, SharePoint Foundation 2013 in Stand-Alone mode

Error: ErrorCode:SubStatus:Service running under Network Service account in workgroup environment is not supported.

Resolution: 

• Go to Run > Type "Services.msc" 

• Start "AppFabric Caching Service" with proper login account.

• Go to SQL Server in then add role to login account as below.

• Add role: Public, Sysadmin, Setupadmin, Serveradmin

• Then Go to Run > Type "Cmd" & run as Administrator

• Set Psconfig.exe path as below command 

• Type "cd C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\BIN" then click ENTER.

• Now run command for silent installation "psconfig.exe -cmd Configdb Create SkipRegisterAsDistributedCacheHost"

Happy SharePointing...!!!

Error occurred in deployment step 'Recycle IIS Application Pool'

Error:

Error occurred in deployment step 'Recycle IIS Application Pool': The open operation did not complete within the allotted timeout of 00:01:00. The time allotted to this operation may have been a portion of a longer timeout.

Solution :

Close you VisualStudio Project & open again.

Happy SharePointing...!!!

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Requirement:  Migrate Data from Access to SQL Server.

So I have to create SSIS Package in SQL Server and I developed on SSIS Package in SQL Server.
All connection managers are fine but when I try to deploy its give me below error.

Error: [OLE DB Source [43]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Access Source Database1" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.


Resolution: Open SSIS Package in Visual Studio > Right Click on Project > Click on Property of your project > Then select "Debugging" node from left side > See the "Run64bitRuntime" property it will be "True" so change it to "False"
Then Deploy again... it will be work...


Happy Migrating...!!!

Cannot serialize interface System.Collections.Generic.IEnumerable in Web Service

I have faced this problem in one of my project.

I have to create WebMethod that will get some data from CRM 2011 and return that to the client.
My code is return generic types in WebMethods but I couldn't use non-generic IEnumerable as well.
So I have to change this IEnumerable to Array as below.

Older Code which is not working 

[WebMethod]
public List ReadEntityList()
{
     List lstCRMEntity = new List();
     //Write code here
     return lstCRMEntity;
 }

Working code is below

[WebMethod]
public CRMEntity[] ReadEntityList()
{
     List lstCRMEntity = new List();
     //Write code here
     return lstCRMEntity.ToArray();
 }

Happy Coding...!!!

The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file.

The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file.




Add below TAG in web.config's HttpHandler

Remove below TAG from AppSettings

Happy Coding !!!

Error occurred in deployment step 'Add Solution': Failed to extract the cab file in the solution.

Error Message: Error occurred in deployment step 'Add Solution': Failed to extract the cab file in the solution.

One day I tried to deploy Images in _layouts folder using VS 2010. But I couldn't deploy Images because above error message fired in VS2010's error window. After half and hour I found one file named with blue_button (2).gif and renamed with blue_button.gif and deploy solution. Its working fine.

Resolution: To work around this problem, remove any parentheses in the names of SharePoint project items.

This link help me to solve the problem http://msdn.microsoft.com/en-us/library/ee330922.aspx.

Happy Coding !!!