If you work with Business Intelligence Development Studio (BIDS), on very rare occasions you may see the following two errors:
This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later.
When you click OK you get:
The query could not be loaded. Verify your connection string and query string.
How do you fix this problem?
That is a good question and the ONLY thing that I have found that will fix this is to edit the Dataset properties and copy the data into notepad. Then delete Datasets and re-create it. I can’t explain why it happens, but I seem to get these error messages about once or twice a year, and I use BIDS every day!