February 8, 2008 at 2:07 pm
We are currently on SQL server 2005 service pack 1 for our sql server installation here.
Our reporting services and the database services for the reporting is on one Server box.
The datasource used for the reporting is on a different server.
Since Microsoft support for sp1 is ending in April, I am planning to upgrade the server next month. However we are also planning to use a different server for reporting which may not be available by April.
My question is can I have the SQL Server which hosts the datasource on Service Pack 2, while the reporting services and its databases are on SP1? I don't want to spend time on upgrading a server that is to be retired if I don't have to.
Thanks
KR
February 18, 2008 at 1:50 am
Hi,
Don't see any issues with that. Should there be? :unsure:
Cheers,
Shiva.
---------
Cheers,
Shiva.
February 20, 2008 at 12:55 pm
My question is can I have the SQL Server which hosts the datasource on Service Pack 2, while the reporting services and its databases are on SP1? I don't want to spend time on upgrading a server that is to be retired if I don't have to.
I have been working with the reverse situation, ie. Report Server on SP2, datasource on SP1.
I have not had any problems.
You shouldn't need to upgrade the Report Server.
Thanks for the heads-up on the SP1 MS Support issue, I hadn't realized it was coming up so soon!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 20, 2008 at 1:03 pm
Thank you all for you input.
KR
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy