How do I grant permissions to ApplicationPoolIdentity in SQL Server 26 December 2013 Donovan-Brown Work (0) Problem: My IIS Application Pool is using ApplicationPoolIdentity and does not have permissions to my SQL Server database. Solution: Open Sql Server Management Studio (SSMS) and create a new login for "IIS AppPool\{YourAppPoolNam}". On the User Mapping page give the user access to the database and save and close the dialog.
I can't create a new backup plan in TFS 2012 after a hardware migration. 24 October 2012 Donovan-Brown Work (0) Problem I upgraded my TFS from 2010 to 2012 and moved to new hardware after my 2010 machine crashed. When I attempt to setup a new backup plan using the 2012 Power Tools I get the following error: A backup plan already exists for this TFS system on a different machine Solution Connect to SSMS and create a new query using Tfs_Configuration and execute the following command. EXEC sp_dropextendedproperty @name = 'TFS_BACKUP_PLAN_CONTROLLER' Explanation The database has an extended property that it stores the name of the machine used for the backups. This was set while running on the original hardware. You have to remove this value before the power tool will allow you to configure a new backup.
I can't run my scripts created by DBPro in SSMS 26 July 2011 Donovan-Brown Work (0) Problem When I try and run my deploy scripts from DBPro in SSMS I get syntax errors where variables are used. Solution Switch on SQL CMD Mode before you execute the SQL file. To enable the SQL CMD Mode select SQL CMD Mode from the Query menu in SSMS.