 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / July 2008VS2005 -- Bus Inteligence 2005 -- Sql Server 2000 will it work?
Hello, This IT person is building a new development workstation for me. He loaded VS2005 enterprise which contains Business Intelligence 2005. But we are currently running sql Server 2000 at my place. On my current workstation I have VS2003 and also VS2005. I use the Business Intelligence (Reporting Services 2000) from VS2003 to create Reports from Sql Server 2000. This works fine. However, when I tried to create a new report on the new workstation using VS2005 Business Intelligence - I could not invoke anything in the Layout - everything was grayed out. I had selected our Sql Server 2000 for the datasource. The connection tested OK. Do we need Sql Server 2005 for use with VS2005 Business Intelligence (Reporting Services 2005) ? Or is it possible to use VS2005 Business Intelligence (Reporting Services 2005) with Sql Server 2000? If yes - how to configure this? (I will guess we probably need sql server 2005). Thanks, Rich If you have Business Intelligence 2005 you should be able to create RS 2005 reports not RS 2000 reports. This environment is only for creating RS 205 reports. If you want to upgrade RS 2000 to RS 2005 it can still use SQL 2000 for its metadata/object cache. However, the server needs to have a SQL Server 2005 license. Keep in mind the data source has absolutely nothing to do with the version of report you are developing. Until you try to deploy you don't even need a connection to the RS server. The data source is where the data resides NOT where Reporting Services resides. I have data sources to Sybase, SQL Server 2005, In-SQL (a real time database) etc.  SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Hello, > [quoted text clipped - 21 lines] > Thanks, > Rich Yes. That is what I was thinking. We do have Sql server 2005 enterprise, but our win2003 server box may not have enough horsepower to run sql server 2000 and 2005. I am just the lowly DB developer/inhouse apps developer guy. We have a web guy off in another corner of the world who runs our web server box (which is yet in another corner of the world) and has replication set up between his (our other) box and our local (main) box. This is all on sql server 2000. He is reluctant to upgrade to our system to sql server 2005 because - not sure why - too much hassel for him to redo the replication maybe? We have several DB's on the web server box - I guess they would all have to go to sql server 2005 if we upgraded the main server to sql server 2005. Thanks for your reply. > If you have Business Intelligence 2005 you should be able to create RS 2005 > reports not RS 2000 reports. This environment is only for creating RS 205 [quoted text clipped - 33 lines] > > Thanks, > > Rich You have missed a point. You can upgrade to Reporting Services 2005 and leave the database at 2000. This is fully supported and I did it for quite awhile. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Yes. That is what I was thinking. We do have Sql server 2005 enterprise, > but our win2003 server box may not have enough horsepower to run sql [quoted text clipped - 62 lines] >> > Thanks, >> > Rich If I may ask - does having a sql server 2005 license mean we have to load sql server 2005 on our server computer? We have sql server 2005. Why would our web guy (he is the main front man of our little company - been with the Co for almost 10 years - me - about 3) be reluctant to upgrade to sql server 2005 if we can leave all the DBs as 2000? I think it would be great to upgrade to RS2005. I have had issues with RS2000 (but have always been able to work around them). > You have missed a point. You can upgrade to Reporting Services 2005 and > leave the database at 2000. This is fully supported and I did it for quite [quoted text clipped - 66 lines] > >> > Thanks, > >> > Rich You can install RS 2005 and leave the database at 2000. This is specifically because people are slow to upgrade the database but will want to upgrade RS. Note that this is different than licensing. A SQL 2005 license allows you to run 2005 OR any previous version. You have to have a SQL 2005 license for the box that run RS 2005. The DB can stay at 2000. He might not realize that this is an option (RS 2005 using a SQL 2000 database for the metadata/object store). I ran in this configuration for about 6 months. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > If I may ask - does having a sql server 2005 license mean we have to load > sql [quoted text clipped - 91 lines] >> >> > Thanks, >> >> > Rich I think I am almost getting it. My company has an MSDN subscription. So we have the sql server 2005 softwarre (I downloaded everything on the subscription including all the keys - took me a few days). How do I implement a sql server 2005 license on our server? Once this license is implemented do I then load the Sql server 2005 software and just select RS2005? > You can install RS 2005 and leave the database at 2000. This is specifically > because people are slow to upgrade the database but will want to upgrade RS. [quoted text clipped - 101 lines] > >> >> > Thanks, > >> >> > Rich MSDN subscription is for developing/testing purpose only. You cannot use any software from MSDN subscription to production. >I think I am almost getting it. My company has an MSDN subscription. So >we [quoted text clipped - 135 lines] >> >> >> > Thanks, >> >> >> > Rich How do I get a license for sql server 2005? How do I implement this license on the server? > MSDN subscription is for developing/testing purpose only. You cannot use any > software from MSDN subscription to production. [quoted text clipped - 138 lines] > >> >> >> > Thanks, > >> >> >> > Rich You need to buy SQL Server license from authorized dealer. You pay the money, you get the disk. Install it, if you call it "implement". > How do I get a license for sql server 2005? How do I implement this > license [quoted text clipped - 168 lines] >> >> >> >> > Thanks, >> >> >> >> > Rich |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.