Reverting from SP2 to SP1

Hi all,
If i have installed SP2 for reporting services and need to revert back to
Reporting Services with SP1. Is this possible without inplications?
Am i able to remove SP2 and reinstall SP1 and have the normal functioanlity
of SP1 or would i have problems. If anyone has tried this please let me know
of your findings
--
Thanks in advance,
Dave HuntFrom the SP2 Readme:
3.5 Removing SP2
To revert to the version that you were running before installing SP2, you
must uninstall Reporting Services and then reinstall it without applying
SP2 afterwards. There is no separate uninstall program for SP2. If you
applied a Quick Fix Engineering (QFE) fix to your RTM or SP1 Reporting
Services installation, you must reapply that QFE fix to the instance. To
uninstall Reporting Services, use Add or Remove Programs in Control Panel.
Note that the report server database, upgraded to the SP2 format, is not
removed when you uninstall the product. You must manually remove the SP2
version of the report server database and restore the version that was part
of the pre-SP2 installation.
| Thread-Topic: Reverting from SP2 to SP1
| thread-index: AcVsG1EcmzbXYT1VSfKmwPFQnrbMDg==| X-WBNR-Posting-Host: 217.44.106.122
| From: "=?Utf-8?B?RHVzdHBhbkRhdmU=?="
<DustpanDave@.discussions.microsoft.com>
| Subject: Reverting from SP2 to SP1
| Date: Wed, 8 Jun 2005 04:15:03 -0700
| Lines: 12
| Message-ID: <59DDE962-4D36-4889-8106-58DDE3C8BD17@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45534
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi all,
|
| If i have installed SP2 for reporting services and need to revert back to
| Reporting Services with SP1. Is this possible without inplications?
|
| Am i able to remove SP2 and reinstall SP1 and have the normal
functioanlity
| of SP1 or would i have problems. If anyone has tried this please let me
know
| of your findings
|
| --
| Thanks in advance,
| Dave Hunt
|

Reverting From MSSQL 2005 to 2000-Help please....

I have installed MSSQL 2005 on my D: drive of my windows 2003 server, but now need to install MSSQL version 2000 b/c I realized I have one less license than I thought I had. I have build no databases, only the default information. Can I install another instance (being the 2000 instance) on the same drive? If I can't, can I install it on the Crive without a lot of issues? Or would it be easier to remove 2005 and just start from scratch? The sql version is 9.0. Any help or comments would be greatly appreciated.!!!!!

It 'should' be OK to have both versions.

However, if you are not planning to use the SQL 2005 because of licensing issues, it may prove easier to just remove it. (My attitude is that if there is no license for it, then it shouldn't be on a computer (who knows when the licenising 'police' may show up...)

|||There are no problems running SQL 2005 and SQL 2000 on the same machine and the same drive.

Reverting back to Windows Authentication

Hi,
Does anyone know if and how easy it is to revert back to just Windows
authentication on the sql server from Mixed Mode ?
Thanks,
Luke.Its all a switch you need to toggle to change to windows authentication mode
under the security tab in SQL Server Properties in EM.
Not too sure how to do the same without using the EM. But make sure you have
no apps using SQL authentication and can be confirmed using profiler.
"Luke Fields" <lfields228@.hotmaik.com> wrote in message
news:u0Yu4mylDHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone know if and how easy it is to revert back to just Windows
> authentication on the sql server from Mixed Mode ?
> Thanks,
> Luke.
>|||Be aware that it does require a SQL Service restart. If you don't have EM
look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285097
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e9hZmLzlDHA.2536@.tk2msftngp13.phx.gbl...
Its all a switch you need to toggle to change to windows authentication mode
under the security tab in SQL Server Properties in EM.
Not too sure how to do the same without using the EM. But make sure you have
no apps using SQL authentication and can be confirmed using profiler.
"Luke Fields" <lfields228@.hotmaik.com> wrote in message
news:u0Yu4mylDHA.2456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone know if and how easy it is to revert back to just Windows
> authentication on the sql server from Mixed Mode ?
> Thanks,
> Luke.
>