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…