Share This Post

Business Intelligence Development Studio (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!

Share This Post

Glad to share something that I've gone through in my professional career. I've 12+ years of experience in Information Technology and since 2006 am working with SMS and then SCCM.

Leave a Reply