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 datab... [More]
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 ... [More]
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.