I had problems installing SQL SP3 on my SP 1.2 box. So, I called Tech Support and asked them if there was something I was doing wrong; they said they recommend just applying the appropriate patches, NOT the full blown SP.
Just my two cents.... -----Original Message----- From: MENDONCA,JOHN (HP-Cupertino,ex1) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:02 AM To: [EMAIL PROTECTED] Subject: RE: [ISSForum] Applying SQL patches to RealSecure 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 _______________________________________________ ISSForum mailing list [EMAIL PROTECTED] TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo
