SQL Server Home
Unable to run Data Collection Reports when using SQL Server Logins
as Not Reproducible
5/13/2008 10:43:03 AM
User(s) can reproduce this bug
I am unable to run any of the Reports in the Data Collection (Disk Usage, Query Statistics, Server Activity) when logged in as a SQL Server Login.
SQL Server 2008 November CTP
Win2003 Standard Server (SP2)
Operating System Language
Steps to Reproduce
Connect to server using SQL Server Authenciation (SQL Server is configured in Mixed security mode)
Turn on Data Collection
Start Data Collection on any of the System Data Collection Sets
Right click on a Data Collection Set (Disk usage for example), choose Reports | DIsk Usage Summary
Failed to connect to server <Servername>. --> Login failed for user ".". The login is a SQL Server login and cannot be used with Windows Authenciation.
to post a comment.
Please enter a comment.
on 7/11/2008 at 4:41 AM
I re-ran my tests and was also not able to re-produce the problem. I noticed the changes that where made to Data Collection. MUCH better.
on 7/10/2008 at 2:22 PM
Thank you for your bug report. Can you please try to reproduce the problem with the RC0 build of SQL Server? A lot has changed and I can no longer reproduce the problem. We now have the ability to launch an overview report directly against the MDW so you don't even need to connect to the target server if the MDW is on a remote system.
on 5/13/2008 at 10:43 AM
This is a blocking issue for me.
to post a workaround.
Please enter a workaround.
© 2014 Microsoft