SQL BIDS 2005 to access a SQL 2008 Database -Can this be done?

Question

SQL BIDS 2005 to access a SQL 2008 Database -Can this be done?

sqlolmy

SSC Journeyman

Points: 75
More actions
March 16, 2010 at 1:53 pm

#217897

We need to use SQL BIDS 2005 to access a SQL 2008 Database -Can this be done? After we create a new Project and datasource in BIDS 2005 we get an error when actually trying to add a report item and hit any data. We get incompatible version errors. Any Ideas?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 1

sqlolmy (3/16/2010)
We need to use SQL BIDS 2005 to access a SQL 2008 Database -Can this be done? After we create a new Project and datasource in BIDS 2005 we get an error when actually trying to add a report item and hit any data. We get incompatible version errors. Any Ideas?

What exactly are you trying to do? What kind of project are you working with that is causing you problems?

If you are trying to create a report using 2005 that is going to be deployed to 2008 - that won't work. However, if you are just connecting to 2008 as a data source there shouldn't be any issues.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

sqlolmy SSC Journeyman Points: 75 More actions · Answer 2

Just trying to create a simple BIDS Reports Project to run against a SQL2008 64 bit Database as my data source, Tried applying SP3 to BIDS but does did not help. Can not add any Report Items, you get version error.

veeren4urs SSCrazy Points: 2763 More actions · Answer 3

Hi ,

Can you please let us know what error exactly you are getting when u r trying to connect the SQL2008 DB.

Thanks

Veeren.:-)

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

mbricker-600840 SSCertifiable Points: 5468 More actions · Answer 4

I think I remember this happening to me when I was trying to gather some data from a SQL 2008 server using SSIS running on SQL 2005.

It seems I had to install SQL 2008 client on the 2005 server.

Mike

“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey

___________________________________________________________________

sqlolmy SSC Journeyman Points: 75 More actions · Answer 5

Further research has shown us that you can connect to a SQL 2008 database with Business Intelligence Design Studio (BIDS) 2005 but the query designer and other tools are now available. You can only connect and add tables via straight SQL code. Has anyone found away around this?

mbricker-600840 SSCertifiable Points: 5468 More actions · Answer 6

sqlolmy (3/22/2010)
Further research has shown us that you can connect to a SQL 2008 database with Business Intelligence Design Studio (BIDS) 2005 but the query designer and other tools are now available. You can only connect and add tables via straight SQL code. Has anyone found away around this?

I just tried to connect from BIDS 2005 to a SQL 2008 DB and had no problems using the query designer.

I did set the connections up using the SQLNCLI10.1 client. I don't know if that made any difference.

Actually, I tried again with the 2005 client and it still worked.

Mike

“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey

___________________________________________________________________

sqlolmy SSC Journeyman Points: 75 More actions · Answer 7

Interesting, a few ?'s. Are you on BIDS 2005 SP3 and what service packs are on your client? Are you creating a report server project? We can connect to datasource OK but when we go to add a report item, the generic query designer button is grayed out. You can add a query to pull data from the SQl2008 db but none of the GUI query designer functions are available

mbricker-600840 SSCertifiable Points: 5468 More actions · Answer 8

Sorry for the confusion. I am on SP3 both for BIDS and the SQL 2005 client. The SQL 2008 client is RTM version, although the server I was connecting to was 2008 SP1.

I was able to use query designer from an SSIS project (I already had one open), but I was NOT able to from

an SSRS project. It threw an error. You could build the query in an SSIS project and then copy it.

This does seem to be a limitation in BIDS. I think there is a patch if you have a full version of VS 2005.

Not sure why it worked in one and not the other.

Mike

“I know that you believe you understand what you think I said, but I'm not sure you realize that what you heard is not what I meant.”...Robert McCloskey

___________________________________________________________________