Hi,
After I "successfully" installed SQL MSDE SP3, SiteProtector stops storing
new alerts. I was on SP2 before and used the following to update:
Setup /upgradesp SQLRUN INSTANCENAME=MSSQLSERVER SECURITYMODE=SQL
UPGRADEUSER=SA UPGRADEPWD=<my-sa-password> /L*V my-trace-file
I'm told that if I reinstall SiteProtector that things might start to work
again. This is going to be fun.
- John
> -----Original Message-----
> From: Wahyu Hidayat [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 8:04 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [ISSForum] Applying SQL patches to RealSecure
>
>
>
> Hi
>
> I guess the correct command to update the MSDE to SP3 is :
> setup upgrade=1 securitymode=sql
>
>
> But , how do we verify that SP3 is already installed ?
>
>
>
>
>
>
> Warm Regards,
> Wahyu Hidayat
> Strategic Outsourcing
> IBM Global Services, Singapore
> Phone: +65-6840-5378
> e-mail: [EMAIL PROTECTED]
>
>
>
>
>
>
>
> "Heald, Arian"
>
>
> <Arian.Heald@ibtc To:
> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>
> o.com> cc:
> "'Sommers,Brian'" <[EMAIL PROTECTED]>,
> "'[EMAIL PROTECTED]'"
> Sent by:
> <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>
> issforum-admin@is Subject: RE:
> [ISSForum] Applying SQL patches to RealSecure
>
> s.net
>
>
>
>
>
>
>
>
> 01/29/2003 10:17
>
>
> PM
>
>
>
>
>
>
>
>
>
>
>
> For SP2, open a command prompt and change directories to:
> sql2ksp2\msde.
>
>
> From there, type: setup /p setup\SQLRun01.msp
>
>
> Thanks to ISS Technical support for that one!
>
>
>
>
>
> Arian Eigen Heald
> Infrastructure Services
> Investors Bank & Trust
> [EMAIL PROTECTED]
> 617-330-6377
>
>
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 8:02 PM
> To: [EMAIL PROTECTED]
> Cc: 'Sommers,Brian'; '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Subject: RE: [ISSForum] Applying SQL patches to RealSecure
>
>
>
>
>
> I try to install the MSDE SP2 to the RS console. However, I
> got the following error when I run the setup which is
> extracted from SQL2KDeskSP2.exe
>
>
> "This installation package could not be opened. Verifiy that
> the package
>
> exists and that you can access it, or contact the
> application vendor to
>
> verifu that this ia a vialid Windows installer package."
>
>
> Should we install SP3 instead of SP2?
>
>
> Regards
>
> Kin
>
>
>
>
>
>
>
>
>
>
> "Heald, Arian"
>
>
> <Arian.Heald@ibtc To:
> "'Sommers,Brian'"
> <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'"
>
>
> o.com> <[EMAIL PROTECTED]>
>
>
> Sent by: cc:
>
>
> issforum-admin@is Subject: RE:
> [ISSForum]
> Applying SQL patches to RealSecure
>
>
> s.net
>
>
>
>
>
>
> 01/29/2003 03:00
>
>
> AM
>
>
>
>
>
>
>
>
>
>
>
> I've installed SP3 into my test environment with the following caveat:
>
>
>
>
>
> You must open a command prompt in the patch directory
> (C:\sql2ksp3\MSDE) and enter:
>
>
>
>
>
> Setup /p /upgradesp sqlrun
>
>
>
>
>
> If your SA password is blank, after this line you must type in:
>
>
>
>
>
> BLANKPWD=1
>
>
>
>
>
> If it is not blank (and you know it shouldn't be!!) after
> sqlrun and a space, enter
>
>
>
>
>
> Securitymode=1
>
>
>
>
>
>
>
>
> This worked for me.
>
>
>
>
>
> Arian Eigen Heald
>
>
>
>
>
> Infrastructure Services
>
>
>
>
>
> Investors Bank & Trust
>
>
>
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
> 617-330-6377
>
>
>
>
>
> -----Original Message-----
> From: Sommers,Brian [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 27, 2003 3:43 PM
> To: '[EMAIL PROTECTED]'
> Subject: [ISSForum] Applying SQL patches to RealSecure
>
>
>
>
>
>
>
>
> Does ISS list somewhere if it is OK (tested) to install the
> latest service
>
>
>
>
>
> pack (SP2) and patches (MS02-061) for MSDE 2000 or SQL Server
> 2000 to a
>
>
>
>
>
> RealSecure console?
>
>
>
>
>
>
>
>
>
> _______________________________________________
>
>
>
>
>
> ISSForum mailing list
>
>
>
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
> TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
> https://atla-mm1.iss.net/mailman/listinfo
>
>
>
>
>
>
>
> **************************************************************
> ************
> This message and any attached documents contain information
> which may be confidential, subject to privilege or exempt
> from disclosure under applicable law. These materials are
> solely for the use of the intended recipient. If you are not
> the intended recipient of this transmission, you are hereby
> notified that any distribution, disclosure, printing,
> copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.
> Delivery of this message to any person other than the
> intended recipient shall not compromise or waive such
> confidentiality, privilege or exemption from disclosure as to
> this communication.
>
>
> If you have received this communication in error, please
> notify the sender immediately and delete this message from
> your system.
> **************************************************************
> ***************
>
>
>
>
>
>
>
>
>
>
> **************************************************************
> ************
> This message and any attached documents contain information
> which may be confidential, subject to privilege or exempt
> from disclosure under applicable law. These materials are
> solely for the use of the intended recipient. If you are not
> the intended recipient of this transmission, you are hereby
> notified that any distribution, disclosure, printing,
> copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.
> Delivery of this message to any person other than the
> intended recipient shall not compromise or waive such
> confidentiality, privilege or exemption from disclosure as to
> this communication.
>
> If you have received this communication in error, please
> notify the sender immediately and delete this message from
> your system.
> **************************************************************
> ***************
>
>
>
>
>
>
>
> _______________________________________________
> ISSForum mailing list
> [EMAIL PROTECTED]
>
> TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo
_______________________________________________
ISSForum mailing list
[EMAIL PROTECTED]
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo
