I reinstalled MS SQL Server 2008 after uninstalling it. I ran into an issue where two previous instances where still on my OS (Windows 7 Professional 64-bit); I could not remove those instances. I created a new instance and named it something different. The installation went fine and I installed the sample databases provided by MS here.
The databases show up fine and I can query them and view the tables. The problem occurs when I try to create reports on them. I right-click on a database and select Reports > Standard Reports > Disk Usage for example and I get the error message:
Could not load file or assembly 'Microsoft.SqlServer.Diagnostics.STrace, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.SqlTDiagM)
When I installed SQL Server 2008, I created separate Windows Users for Agent, Analysis, Engine, Integration and Reporting, as per the Lynda.com tutorial instructions. Could that have something to do with this error?
I also get the same error when I start SQL Server Management Studio.
