Install security patch ms03-031 on sql2k sp3 server

Tried to install security patch ms03-031 on sql2k sp3
server, but got message said that there is no valid
instance for the patch. Anyone else had this problem?I would first run Select @.@.version from Query Analyzer to verify that the
version is 2000.8.00.760 (SP3)
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thanks for the response, Rand.
Yes, I did that and even tried to reapply sp3 but still
can't install that patch with same message. Any other
reasons?
>--Original Message--
>I would first run Select @.@.version from Query Analyzer to
verify that the
>version is 2000.8.00.760 (SP3)
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||Check the registry for the version number.
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CSDVersion.
Make sure it also say 8.00.760
Rand.
This posting is provided "as is" with no warranties and confers no rights.|||Thanks for the response, Rand. That was first thing I do
and it returned correct result. I even tried reapply sp3
but still got message said that can't find instance for
the patch. Any other reasons?
>--Original Message--
>I would first run Select @.@.version from Query Analyzer to
verify that the
>version is 2000.8.00.760 (SP3)
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||It says 8.00.534, I changed it to 8.00.760 but still
doesn't let me apply the patch.
>--Original Message--
>Check the registry for the version number.
>HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVer
sion\CSDVersion.
>Make sure it also say 8.00.760
>Rand.
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>

Install Security

Reguarding best practices: when I am installing s SQL
Server Database, best practice would say that I do not use
the Domain Admin or the BUILTIN Admin account to run the
database under. If I cannot use these accounts, what do I
use? My network has Active Directory installed and we are
running on Win2000 servers."Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:8b5201c3e9a2$dbf005a0$a401280a@.phx.gbl...

quote:

---

> Reguarding best practices: when I am installing s SQL
> Server Database, best practice would say that I do not use
> the Domain Admin or the BUILTIN Admin account to run the
> database under. If I cannot use these accounts, what do I
> use? My network has Active Directory installed and we are
> running on Win2000 servers.

---

For fairly high level of security you can use a domain account with user
level domain permissions, on the server grant the permissions (user rights,
registry & NTFS permissions) found in this document:
http://support.microsoft.com/defaul...1&Product=sql2k
Stevesql

Install fails on SQL2k5 because no IIS on Server

We have a new cluster that we are trying to install SQL 2k5 enterprise on and the security requirements will not allow us to install IIS on the same server as SQL. Is there a way around the requirement of having IIS installed on the server with SQL 2k5?It's not a requirement, unless you need RS on the cluster. You'll get a warning early on, but Setup will proceed if IIS is missing.|||The setup just closes itself down when it is doing the check for server components. There is no error at all. When we check the log file there is a statement about IIS not being installed or is disabled.|||Ugh. Well, the crash is likely due to another cause. Are you referring to summary.txt, or one of the detailed logs? If the former, I would proceed by looking at ...core.log and/or core(local).log. But at this stage there aren't going to be very many logs so check everything there for clues.

Install error Security Patch MS03-031

When I try to install Security Patch MS03-031 or the
alternative SQL2000-KB826161-8.00.0819-ENU.exe I get the
following error
"PackageForTheWeb Error Corrupt cabinet file!"
This happens if I run the file from the net or if I save
it and run it from a local directory.
What am I missing?
Thanks, MatthewMatthew,
Check if you have the following registry key..
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session
Manager\PendingFileRenameOperations
If its there, then delete the 'PendingFileRenameOperations' key or better
rename it , reboot and then try with the patch install.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Matthew Hile" <mhilem@.mimh.edu> wrote in message
news:477201c3761a$7e946eb0$a501280a@.phx.gbl...
> When I try to install Security Patch MS03-031 or the
> alternative SQL2000-KB826161-8.00.0819-ENU.exe I get the
> following error
> "PackageForTheWeb Error Corrupt cabinet file!"
> This happens if I run the file from the net or if I save
> it and run it from a local directory.
> What am I missing?
> Thanks, Matthew
>sql

install a security patch

Hi,
I accidentally installed twice on my sql server 2000
server the 'Microsoft Security Bulletin MS03-031:
Cumulative Patch for Microsoft SQL Server (Q815495)', the
most recent security patch for sql server.
The second time that I installed this patch, it simply
went through as if it's the first time install. Is this
gonna be a problem?
Any help will be greatly appreciated.
JJNormally not.|||thanks!!
JJ
>--Original Message--
>Normally not.
>
>.
>