Re: SP4 and SP3 interaction

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I'm not sure if there are any issues running DTS packages between SQL
Server versions, but there should not be any issues running SP4
relational with SP3 OLAP.

The 2 servers run independently. Unless you have your Olap repository on
your sql server you do not even need the relational server installed.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1141408115.920759.262040@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
aaron_kempf@xxxxxxxxxxx says...
Team;

I've got 15 olap servers that have SP3 relational and SP3 olap.

I'm concerned because we use SP4 relationally everywhere else.

Should i be concerned about making packages in SP4 and then executing
them in SP3?

I'm just super-apprehensive about mixing SP3 and SP4 so much. It seems
dangerous to me.

PS - We havent/can't upgrade to SP4 on the Olap side because we dont
want to update each of our 2,000 client machines. Putting SP4 on the
Olap servers would require that we update to SP4 PivotTable Service on
each of our desktops.. right?


Thanks

-Aaron



.



Relevant Pages

  • Re: Cannot load databases; version may not be valid
    ... I've installed the PTS from SP4 on the client and doesn't help. ... The thing is that I can't even see the OLAP databases. ... But on the server itself works fine. ...
    (microsoft.public.sqlserver.olap)
  • SP4
    ... Server with SP3. ... I try to upgrade to SP4 ...
    (microsoft.public.win2000.advanced_server)
  • How to convert MSDB from SP3 to SP4
    ... Is it possible to take the MSDB database bakup file from a SQL2000 SP3 ... server and convert it to SP4 so it can be restored to an SP4 server, ...
    (microsoft.public.sqlserver.setup)
  • Re: Mails in der Warteschlange
    ... auf unseren eigenen Server zugreifen. ... Die Mails hängen in der Queue von Popcon. ... dass SP3 und W2K SP4 etwas verstellt haben? ...
    (microsoft.public.de.exchange)
  • Win 2K SP4 and SQL 2K SP3 (or) SP3a - Any issues or problems.
    ... We are planning to upgrade from windows 2000 sp3 to sp4 and want to make ... sure that if we apply sp4 on the server we don't break anything on the sql ...
    (microsoft.public.sqlserver.server)