If somebody like the post and its helpful in your work then, add comments.

Monday, December 17, 2012

Visual Studio 2012 Project Load Failure Dialog Box for Database Project

Upon loading Visual Studio 2012 RC or Visual Studio 2010, several package load failure messages are shown for SSDT components.

The ‘SqlStudio Editor Package’ package did not load correctly.

Trying to build solution that contains a sql database project (VS 2012 RC). Other projects build fine but database project fails. Error log shows:

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(386,5): error MSB4061: The "SqlModelResolutionTask" task could not be instantiated from "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\Bin\Microsoft.Data.Tools.Schema.Tasks.Sql.11.dll".  [C:\a\src\Gamma.Db\Gamma.Db.sqlproj]

SQL Server Data Tools (SSDT) : SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development and maintenance/update inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise.

Resolution : Install SQL Server Data Tools (SSDT) in the system and restart the machine

Link to download : http://msdn.microsoft.com/en-us/jj650015

Friday, November 2, 2012

SharePoint 2010 error when trying to delete a managed account: An object in the SharePoint administrative framework, SPManagedAccount Name=managed-account could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation.

After deleting a User profile Service Application, we may want to clear up the corresponding managed account that we have created for the Service Application.

But we get the above error when we try to deleted the acount from CA-> Securtiy->Configure Managed Accounts.

To resolve this error, we have to use SharePoint PowerShell,

Steps :

  1. Go to Start->Microsoft SharePoint 2010 Products->SharePoint 2010 Management Shell
  2. Paste this commend on the shell “Get-SPServiceApplicationPool” (get a list of the Service Application Pools)
  3.            App
  4. The run the following cmdlet “Remove-SPServiceApplicationPool” and press enter key.
  5. The the service application pool and press enter
  6.          App1
  7. Remove the Managed account via PowerShell by following cmdlets
  8. Get-SPManagedAccount
    Remove-SPManagedAccoun <accounetname>

Monday, October 29, 2012

The forefront identity manager service service on local computer started and then stopped : SharePoint 2010 user profile issue

When we create user profile service application, then some times the User profile Synchronization services does start or run. The common scenarios the farm admin and domain admin are same. So, user profile synchronization does not run under the same account. From my research or we can say finding, when we do new installation of the SharePoint in new server, most of the time the service does not run, we just wait for long hours, and it stat is like starting. Seriously it wasted my lot of time, just sitting at my screen and waiting to start.

The main reason of the that is, we have create a new service account say “sp_userprofiles” in managed account of the Active Directory section.


And give the following permissions.


Now we have create one Delegate Control for created user.


Click on Next

On the Users or Groups page, click Add

Type the name of the synchronization account (farikam\sp_userprofiles), and then click OK.


On the Tasks to Delegate page, select create a custom task to delegate, and then click Next.


On the Active Directory Object Type page, select This folder, existing objects in this folder, and creation of new objects in this folder, and then click Next.


On the Permissions page, in the Permissions box, Select Replicating Directory Changes (select Replicate Directory Changes on Windows Server 2003), and then click Next.


Click Finish.


Create User profile Service Application.

Run the services from Central Admin(User Profile Service and User Profile Synchronization Service )


Check the services.msc in the system


Both service are now running(Do not run or edit the properties of the service manually)

Enjoy SharePoint Smile

Tuesday, January 31, 2012

SharePoint 2010 : Types of Event Receivers

List Events -
Adding/ed a new list field.
Updating/ed a field.
List Item Events -
Adding/ed a new list item or document.
Document checking/ed in or out.
Adding/ed an attachment.
Deleting/ed an item or document.
List Email Events -
A list received an email.
Web Events -
Deleting/ed a site collection or site.
Creating/ed a new site collection or sub site.
Feature Events -
Feature activating/ed or deactivating/ed.
List Workflow Events -
A workflow is starting/ed, postponed, or completed.