SQL 2008 Database tuning advisor won't start
- by Andrew Hancox
For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying:
Failed to initialize MSDB database for tuning (exit code: -1073741819).
I'm pretty sure it's not a permissions issue since I've used profiler to capture what it's doing and all of the commands it's run so far look fine and are being run under my account which is associated with the sysadmin role, when I run them in sql management studio they go through fine. I'm pretty convinced that the problem is related to creating the objects in MSDB that are used by DTA but I tried creating these manually (I found scripts on the web) and it just seems to push the problem along the line slightly.
I'm going out of my mind - have even tried reinstalling SQL but that's not fixed it.
I'm using SQL 2008 with SP1 (10.0.2531) on windows server 2008 (patched up to date).
SAVE ME!!!!!