Showing posts with label component. Show all posts
Showing posts with label component. Show all posts

Sunday, January 29, 2017

Visual Studio cache clear

Hey guys,

Today, while playing around with Visual Studio templates, I did which had put me in a fix. I had changed some config files and after which I started getting weird errors on VS launch. (Sorry don't remember the exact errors now)

Then I revert the config files from the backup which I had taken before doing the changes still the errors didn't go away. Then it struck me that it's got something to do with the VS cache and on googling I found the below method to clear the cache:

1. Close Visual Studio (ensure devenv.exe is not present in the Task Manager)
2. Delete the %USERPROFILE%\AppData\Local\Microsoft\VisualStudio\14.0\ComponentModelCache directory
3. Restart Visual Studio.

You should change the VisualStudio/14.0 to the version of visual studio you are using. I am using VS2015.

Credits: https://github.com/Codealike/Codealike-KnowledgeBase/blob/master/clear-visual-studio-component-cache.md

Friday, August 21, 2015

SSIS 2012: Access is denied error

While connecting to SSIS in SSMS, you may face an error of "Access is denied". It can be resolved by following the below steps:
  1. If the user is not a member of the local Administrators group, add the user to the Distributed COM Users group. You can do this in the Computer Management MMC snap-in accessed from the Administrative Toolsmenu.
  2. Open Control Panel, double-click Administrative Tools, and then double-click Component Services to start the Component Services MMC snap-in.
  3. Expand the Component Services node in the left pane of the console. Expand the Computers node, expandMy Computer, and then click the DCOM Config node.
  4. Select the DCOM Config node, and then select SQL Server Integration Services 11.0 in the list of applications that can be configured.
  5. Right-click on SQL Server Integration Services 11.0 and select Properties.
  6. In the SQL Server Integration Services 11.0 Properties dialog box, select the Security tab.
  7. Under Launch and Activation Permissions, select Customize, then click Edit to open the Launch Permissiondialog box.
  8. In the Launch Permission dialog box, add or delete users, and assign the appropriate permissions to the appropriate users and groups. The available permissions are Local Launch, Remote Launch, Local Activation, and Remote Activation. The Launch rights grant or deny permission to start and stop the service; the Activation rights grant or deny permission to connect to the service.
  9. Click OK to close the dialog box.
  10. Under Access Permissions, repeat steps 7 and 8 to assign the appropriate permissions to the appropriate users and groups.
  11. Close the MMC snap-in.
  12. Restart the Integration Services service.
Reference: https://msdn.microsoft.com/en-us/library/aa337083.aspx