Re: WwK3 cluster + MSSQL sp3a upg.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rodney R. Fournier [MVP] (rod_at_die.spam.die.nw-america.com)
Date: 06/27/04 

Date: Sun, 27 Jun 2004 14:48:43 -0500

Tibi, you need to get SP3a on your SQL for it to be supported on Windows
Server 2003. I have not seen this error, but all you need to do is apply a
security template that does not lock it down as much. Then apply SP3a, when
done, put on your security template.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Tibi Baraboi" <tibi.baraboi@getronics.com> wrote in message
news:u6gHFf5WEHA.2176@TK2MSFTNGP11.phx.gbl...
> Hi,
> We have a W2k3 cluster with a group MSSQL 2000 sp2. Now when we try to
start
> the setup for MS SQL sp3a it stops saying that it cannot detect the satus
of
> a service. We have applied a security template which might conflict with
MS
> SQL sp 3a.
> In security log we get message as below :
>
> Does anybody encounter such error?
> Thank you in advance.
> Tibi Baraboi
>
> Event Type: Failure Audit
> Event Source: Security
> Event Category: Object Access
> Event ID: 560
> Date: 6/26/2004
> Time: 5:58:07 PM
> User: NT AUTHORITY\NETWORK SERVICE
> Computer: SPS3BEBR01
> Description:
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: RemoteAccess
> Handle ID: -
> Operation ID: {0,1119191}
> Process ID: 612
> Image File Name: C:\WINDOWS\system32\services.exe
> Primary User Name: SPS3BEBR01$
> Primary Domain: EXTRANET
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: NETWORK SERVICE
> Client Domain: NT AUTHORITY
> Client Logon ID: (0x0,0x3E4)
> Accesses: Query status of service
>
> Privileges: -
> Restricted Sid Count: 0
> Access Mask: 0x4
>
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
>

Relevant Pages

  • RE: Stored Procedure Slow
    ... happening at the time (at a level more granular than "when I access SQL ... Server 7.0"). ... I know that the section of> this stored procedure which takes so long to complete > is when the SQL 7.0 are being accessed. ... This Server also has the> Analysis Server 2000 installed and found that something like that could> happen when applying the sp3a. ...
    (microsoft.public.sqlserver.programming)
  • Re: Internal system DSN not seeing 1433 from ISA/SQL server
    ... I've loaded SQL2K with SP3A. ... server confirms it's SQL2K newer than SP3A. ... I wonder if I should remove and re-install sharepoint to direct it at SQL? ...
    (microsoft.public.windows.server.sbs)
  • Server wird langsam
    ... seit Montag habe ich das Problem, dass mein SQL 2000 Server mit SP3a ... ob während der Zeit Daten geschrieben ...
    (microsoft.public.de.sqlserver)
  • Re: SP3a not updating version
    ... >Are you sure you only have a single instance of SQL ... Server running? ... I've downloaded and installed the sp3a to my ... >> SQL 2000, however, when I restart the service the ...
    (microsoft.public.sqlserver.server)
  • Best Security Template for a Member Server level SQL server install
    ... from MS on which uplevel Security Template (file server, ... infrastructure server, etc.) is the best baseline starting point for a SQL ... Security settings to the install of SQL itself. ...
    (microsoft.public.sqlserver.security)