Management Studio 2005 - Reporting Services -- sql server reporting services

Nick
11/30/2005 8:17:02 PM

Also I forgot to mention that I lost all Business Intelligence options in SQL
Management Studio and VS.NET 2005 is there a way to get them back? Also,
recently I purchased a version of SQL 2005 for my work. From what I was
reading since I have a valid 2005 license even though I have not installed it
yet, I can upgrade to reporting services 2005 without changing the database
engine from SQL 2000...is this correct? I have some databases that I cannot
yet upgrade to 2005. Will reporting services 2005 report off of SQL 2000
databases also if I do not upgrade the database engine, can I still use the
ad-hoc reporting for some employees to design their own reports?

[quoted text, click to view]

v-mingqc NO[at]SPAM online.microsoft.com
12/1/2005 12:00:00 AM

Hi,

Welcome to use MSDN Managed Newsgroup!

From your descriptions, I am not sure "work with SQL Server 2000 Reporting
Services" exactly. If you want to connect to SQL Server 2000 Reporting
Services via SQL Server Management Stuido directly, I am afraid it is not
possible to do so. You are required to upgrade SQL Server 2000 Reporting
Services to SQL Server 2005 Reporting Services first and then using SQL
Server 2005 components to do the connection / configuration.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

v-mingqc NO[at]SPAM online.microsoft.com
12/1/2005 12:00:00 AM

Hi Nick,

[quoted text, click to view]

What are the Business Intelligence options? Would you please clarify more?

[quoted text, click to view]

Yes, you could. It is no problem if you upgrade SQL Server 2000 Reporting
Services to SQL Server 2005 Reporting Services only and using SQL Server
2000 databases.

Check the following topic for detailed information.

Migrating Reporting Services
http://msdn2.microsoft.com/en-us/library/ms143724.aspx

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Management Studio 2005 - Reporting Services