< Blog

BIDS Error

By Garth Jones

If you work with Business Intelligence Development Studio (BIDS), on very rare occasions you may see the following two errors:

BIDS Error 1

This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later.

When you click OK you get:

BIDS Error 2

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!