I have a query that is taking too long to run. It take 14 seconds to return 6800 rows. However, if I move the query out of a stored proc, it takes 1 second. I want to understand this issue and ideally fix the stored proc case.
I've simplified my actual queries for readability.
-- @.filter is value to filter against or NULL to return all records.
CREATE PROCEDURE queryPlayerStations(@.filter INTEGER)
AS
SELECT * FROM MyTable
-- Other joins and query logic omitted for brevity
WHERE ((@.filter IS NULL) OR (MyTable.Column = @.filter))
GO
DECLARE @.filter INTEGER
SET @.filter = NULL
-- Takes 14 seconds to return 6800 rows. That's unacceptable performance
EXEC dbo.queryPlayerStations @.filter
When I run the query directly in Query Analyzer, it runs very fast.
DECLARE @.filter INTEGER
SET @.filter = NULL
-- Takes ~1 second to return 6800 rows. That's great performance
SELECT * FROM MyTable
-- Other joins and query logic omitted for brevity
WHERE ((@.filter IS NULL) OR (MyTable.Column = @.filter))
When I put the parameters in the stored proc it runs fast.
CREATE PROCEDURE queryPlayerStations
AS
DECLARE @.filter INTEGER
SET @.filter = NULL
SELECT * FROM MyTable
-- Other joins and query logic omitted for brevity
WHERE ((@.filter IS NULL) OR (MyTable.Column = @.filter))
GO
-- Takes ~1 second to return 6800 rows. That's great performance
EXEC dbo.queryPlayerStations
Anyone have any ideas what I can do to improve the stored proc case?Just a quick *guess* before I leave office for tonight...
The optimization in SQL Server works differently depending
on where the parameter is defined (as a procedure call argument or inside using DECLARE). In one of the cases,
it doesn't have enough info to optimize in the best way.|||As Coolberg implied, what happens if you do this:
ALTER PROCEDURE queryPlayerStations(@.filterIN INTEGER)
AS
DECLARE @.filter INTEGER
SET @.filter = @.filterIN
SELECT * FROM MyTable
-- Other joins and query logic omitted for brevity
WHERE ((@.filter IS NULL) OR (MyTable.Column = @.filter))
GO
DECLARE @.filterIN INTEGER
SET @.filterIN = NULL
EXEC dbo.queryPlayerStations @.filterIN
Showing posts with label seconds. Show all posts
Showing posts with label seconds. Show all posts
Monday, March 26, 2012
Friday, March 9, 2012
Help - View Trigger or Table Trigger
Hello All,
My application takes data readings every few seconds and stores a
couple of data values for piece of equipment in a table for historic
trending. The table is simlar to:
CREATE TABLE [DataTest] (
[DataID] [bigint] IDENTITY (1, 1) NOT NULL ,
[EquipmentID] [int] NOT NULL,
[DataTimestamp] [datetime] NOT NULL ,
[DataReading1] [decimal](18, 4) NOT NULL,
[DataReading2] [decimal](18, 4) NOT NULL
[DataReading3] [decimal](18, 4) NOT NULL
)
My application needs to alert users when data values fall outside of
acceptable thresholds. It also must allow users to view a history of
when these "alerts" have triggered.
I would like to utilize the database (SQL Server 2000) as much as
possible for this functionality. I originally thought I could create a
new View for each alert that users set. For example,
CREATE VIEW dbo.Alert_25
AS
SELECT * FROM DataTest WHERE DataReading1 > 200 AND DataReading2 < 500
WHERE EquipmentID = 1
Each view would then contain the history of when that alert triggered.
I then thought I could add a trigger to that View to notify the user
that the data has gone out of range. This is where things fall apart.
The inserts are happening on the main table not the view, so a trigger
on the view does not fire.
SO...here are my questions.
1. I would like to keep the trigger associated with the View if
possible. That way, if the user deletes the View the triggers can
easily be removed as well. Is there anyway for the trigger to fire if
it is on the View?
2. I guess my alternative would be to have both Views for the alert
histories and multiple triggers on the data table. Is this an
acceptable approach? Say the user where to create 100 different alerts.
What impact on the server would this have if this created 100 different
triggers on the same data table?
I appreciate your opinions and advice. If I am way off base all
together, I appreciate any other suggestions.
Thanks,
YofnikOn 15 Aug 2005 13:09:39 -0700, Yofnik wrote:
(snip)
>SO...here are my questions.
>1. I would like to keep the trigger associated with the View if
>possible. That way, if the user deletes the View the triggers can
>easily be removed as well. Is there anyway for the trigger to fire if
>it is on the View?
Hi Yofnik,
No. A view can have only an INSTEAD OF trigger defined on it, and that
will only fire when an insert, update or delete is executed with the
view as target.
>2. I guess my alternative would be to have both Views for the alert
>histories and multiple triggers on the data table. Is this an
>acceptable approach? Say the user where to create 100 different alerts.
>What impact on the server would this have if this created 100 different
>triggers on the same data table?
It would cause a dramatic slowdown of your data modifications. Keeping
it all in one trigger would also cause a slowdown, but not as much.
Anyway, I think you should also reconsider the first stetp. You mention
"alerting users" without going into the specifics, but I have a hunch
that you plan to send out an email. And sending email from a trigger is,
as Orwell would say, doubleplusungood practice. Not only because it will
slow down your inserts tremendously, but also becuase you are mingling
in-transaction and out-transaction actions. What happens if the
transaction fails and is rolled back immediately after the mail is sent?
Your best bet is probably to investigate what Notification Services can
do for you.
If NS can't be used in your case, then create your views, write a script
that checks for entries in each of the views without matching entry in
the "alert history" table and sends a mail if it finds one. Use Agent to
schedule this as a job that runs as often as you need it (depends on how
much time may pass between the measurement and the alert).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Sorry, I suppose I did not mention HOW the trigger would alert users. I
definitely was not planning on sending an email from the trigger. I
would like the trigger to simply put a new row in the AlertHistory
table with the AlertID and a flag indicating if it has been processed.
Then an external application can regularly poll this one table and grab
all alert IDs that have not been processed and send out an email. The
external application will then set the flag to indicate the alerts have
been processed.
With that said, is your last suggestion my best approach? Is there an
easy way to check for new rows in ALL views? I guess that would require
dynamic SQL then, huh?|||On 15 Aug 2005 13:42:25 -0700, Yofnik wrote:
>Sorry, I suppose I did not mention HOW the trigger would alert users. I
>definitely was not planning on sending an email from the trigger. I
>would like the trigger to simply put a new row in the AlertHistory
>table with the AlertID and a flag indicating if it has been processed.
>Then an external application can regularly poll this one table and grab
>all alert IDs that have not been processed and send out an email. The
>external application will then set the flag to indicate the alerts have
>been processed.
>With that said, is your last suggestion my best approach? Is there an
>easy way to check for new rows in ALL views? I guess that would require
>dynamic SQL then, huh?
Hi Yofnik,
If you only want to insert a row in the AlertHistory table, I'd probably
go for a trigger. But just ONE trigger - nod hundreds of 'em!
Either hard-code the limits that will cause an alert in the trigger (and
make sure that allchange requests go through one channel - i.e. you). If
you must have flexibility for the ussers to add, remove or change the
upper and lower limits for alerts, than create a second table to hold
all the limits, and join to that in the trigger to determine if any
alerts are generated. If you need more help on how to design this table
and how to code the trigger, give us some more information on your
current tables and data. Check out www.aspfaq.com/5006 to find out what
inforamtion we need to best address your question.
WRT your last question - steer clear of dynamic SQL! If you want to know
why, read http://www.sommarskog.se/dynamic_sql.html.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
My application takes data readings every few seconds and stores a
couple of data values for piece of equipment in a table for historic
trending. The table is simlar to:
CREATE TABLE [DataTest] (
[DataID] [bigint] IDENTITY (1, 1) NOT NULL ,
[EquipmentID] [int] NOT NULL,
[DataTimestamp] [datetime] NOT NULL ,
[DataReading1] [decimal](18, 4) NOT NULL,
[DataReading2] [decimal](18, 4) NOT NULL
[DataReading3] [decimal](18, 4) NOT NULL
)
My application needs to alert users when data values fall outside of
acceptable thresholds. It also must allow users to view a history of
when these "alerts" have triggered.
I would like to utilize the database (SQL Server 2000) as much as
possible for this functionality. I originally thought I could create a
new View for each alert that users set. For example,
CREATE VIEW dbo.Alert_25
AS
SELECT * FROM DataTest WHERE DataReading1 > 200 AND DataReading2 < 500
WHERE EquipmentID = 1
Each view would then contain the history of when that alert triggered.
I then thought I could add a trigger to that View to notify the user
that the data has gone out of range. This is where things fall apart.
The inserts are happening on the main table not the view, so a trigger
on the view does not fire.
SO...here are my questions.
1. I would like to keep the trigger associated with the View if
possible. That way, if the user deletes the View the triggers can
easily be removed as well. Is there anyway for the trigger to fire if
it is on the View?
2. I guess my alternative would be to have both Views for the alert
histories and multiple triggers on the data table. Is this an
acceptable approach? Say the user where to create 100 different alerts.
What impact on the server would this have if this created 100 different
triggers on the same data table?
I appreciate your opinions and advice. If I am way off base all
together, I appreciate any other suggestions.
Thanks,
YofnikOn 15 Aug 2005 13:09:39 -0700, Yofnik wrote:
(snip)
>SO...here are my questions.
>1. I would like to keep the trigger associated with the View if
>possible. That way, if the user deletes the View the triggers can
>easily be removed as well. Is there anyway for the trigger to fire if
>it is on the View?
Hi Yofnik,
No. A view can have only an INSTEAD OF trigger defined on it, and that
will only fire when an insert, update or delete is executed with the
view as target.
>2. I guess my alternative would be to have both Views for the alert
>histories and multiple triggers on the data table. Is this an
>acceptable approach? Say the user where to create 100 different alerts.
>What impact on the server would this have if this created 100 different
>triggers on the same data table?
It would cause a dramatic slowdown of your data modifications. Keeping
it all in one trigger would also cause a slowdown, but not as much.
Anyway, I think you should also reconsider the first stetp. You mention
"alerting users" without going into the specifics, but I have a hunch
that you plan to send out an email. And sending email from a trigger is,
as Orwell would say, doubleplusungood practice. Not only because it will
slow down your inserts tremendously, but also becuase you are mingling
in-transaction and out-transaction actions. What happens if the
transaction fails and is rolled back immediately after the mail is sent?
Your best bet is probably to investigate what Notification Services can
do for you.
If NS can't be used in your case, then create your views, write a script
that checks for entries in each of the views without matching entry in
the "alert history" table and sends a mail if it finds one. Use Agent to
schedule this as a job that runs as often as you need it (depends on how
much time may pass between the measurement and the alert).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Sorry, I suppose I did not mention HOW the trigger would alert users. I
definitely was not planning on sending an email from the trigger. I
would like the trigger to simply put a new row in the AlertHistory
table with the AlertID and a flag indicating if it has been processed.
Then an external application can regularly poll this one table and grab
all alert IDs that have not been processed and send out an email. The
external application will then set the flag to indicate the alerts have
been processed.
With that said, is your last suggestion my best approach? Is there an
easy way to check for new rows in ALL views? I guess that would require
dynamic SQL then, huh?|||On 15 Aug 2005 13:42:25 -0700, Yofnik wrote:
>Sorry, I suppose I did not mention HOW the trigger would alert users. I
>definitely was not planning on sending an email from the trigger. I
>would like the trigger to simply put a new row in the AlertHistory
>table with the AlertID and a flag indicating if it has been processed.
>Then an external application can regularly poll this one table and grab
>all alert IDs that have not been processed and send out an email. The
>external application will then set the flag to indicate the alerts have
>been processed.
>With that said, is your last suggestion my best approach? Is there an
>easy way to check for new rows in ALL views? I guess that would require
>dynamic SQL then, huh?
Hi Yofnik,
If you only want to insert a row in the AlertHistory table, I'd probably
go for a trigger. But just ONE trigger - nod hundreds of 'em!
Either hard-code the limits that will cause an alert in the trigger (and
make sure that allchange requests go through one channel - i.e. you). If
you must have flexibility for the ussers to add, remove or change the
upper and lower limits for alerts, than create a second table to hold
all the limits, and join to that in the trigger to determine if any
alerts are generated. If you need more help on how to design this table
and how to code the trigger, give us some more information on your
current tables and data. Check out www.aspfaq.com/5006 to find out what
inforamtion we need to best address your question.
WRT your last question - steer clear of dynamic SQL! If you want to know
why, read http://www.sommarskog.se/dynamic_sql.html.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Wednesday, March 7, 2012
Help - Security Event Log Posts Error Event ID 560 every few seconds!
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D
There are post-SP4 hotfixes that can be applied:
http://aspfaq.com/SQL2000Builds.asp
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180007534.344206.147240@.u30g2000hsc.googlegr oups.com...
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D
|||Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>
|||There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180013455.778429.265380@.h2g2000hsg.googlegro ups.com...
Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>
|||Thanks again, this the first I even heard of AWE... since I have 4
gig fo ram I better put in the fixes!
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
> --
> Tom
|||I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
> --
> Tom
>
|||I've scoured the MS website and came up with squat. You may need to call
Product Support and open a ticket.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180469042.970043.254730@.o5g2000hsb.googlegro ups.com...
I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend.
> ;-)
> --
> Tom
>
|||Thanks! If/When I get an answer I'll be sure to add it to the thread!
David
On May 29, 6:59 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> I've scoured the MS website and came up with squat. You may need to call
> Product Support and open a ticket.
> --
> Tom
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D
There are post-SP4 hotfixes that can be applied:
http://aspfaq.com/SQL2000Builds.asp
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180007534.344206.147240@.u30g2000hsc.googlegr oups.com...
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D
|||Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>
|||There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180013455.778429.265380@.h2g2000hsg.googlegro ups.com...
Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>
|||Thanks again, this the first I even heard of AWE... since I have 4
gig fo ram I better put in the fixes!
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
> --
> Tom
|||I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
> --
> Tom
>
|||I've scoured the MS website and came up with squat. You may need to call
Product Support and open a ticket.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180469042.970043.254730@.o5g2000hsb.googlegro ups.com...
I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend.
> ;-)
> --
> Tom
>
|||Thanks! If/When I get an answer I'll be sure to add it to the thread!
David
On May 29, 6:59 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> I've scoured the MS website and came up with squat. You may need to call
> Product Support and open a ticket.
> --
> Tom
Help - Security Event Log Posts Error Event ID 560 every few seconds!
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008DThere are post-SP4 hotfixes that can be applied:
http://aspfaq.com/SQL2000Builds.asp
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180007534.344206.147240@.u30g2000hsc.googlegroups.com...
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D|||Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>|||There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180013455.778429.265380@.h2g2000hsg.googlegroups.com...
Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>|||Thanks again, this the first I even heard of AWE... since I have 4
gig fo ram I better put in the fixes!
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
> --
> Tom|||I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
> --
> Tom
>|||I've scoured the MS website and came up with squat. You may need to call
Product Support and open a ticket.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180469042.970043.254730@.o5g2000hsb.googlegroups.com...
I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend.
> ;-)
> --
> Tom
>|||Thanks! If/When I get an answer I'll be sure to add it to the thread!
David
On May 29, 6:59 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> I've scoured the MS website and came up with squat. You may need to call
> Product Support and open a ticket.
> --
> Tom
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008DThere are post-SP4 hotfixes that can be applied:
http://aspfaq.com/SQL2000Builds.asp
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180007534.344206.147240@.u30g2000hsc.googlegroups.com...
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D|||Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>|||There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180013455.778429.265380@.h2g2000hsg.googlegroups.com...
Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>|||Thanks again, this the first I even heard of AWE... since I have 4
gig fo ram I better put in the fixes!
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
> --
> Tom|||I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
> --
> Tom
>|||I've scoured the MS website and came up with squat. You may need to call
Product Support and open a ticket.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180469042.970043.254730@.o5g2000hsb.googlegroups.com...
I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend.
> ;-)
> --
> Tom
>|||Thanks! If/When I get an answer I'll be sure to add it to the thread!
David
On May 29, 6:59 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> I've scoured the MS website and came up with squat. You may need to call
> Product Support and open a ticket.
> --
> Tom
Help - Security Event Log Posts Error Event ID 560 every few seconds!
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008DThere are post-SP4 hotfixes that can be applied:
http://aspfaq.com/SQL2000Builds.asp
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180007534.344206.147240@.u30g2000hsc.googlegroups.com...
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D|||Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>|||There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180013455.778429.265380@.h2g2000hsg.googlegroups.com...
Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>|||Thanks again, this the first I even heard of AWE... since I have 4
gig fo ram I better put in the fixes!
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;
-)
> --
> Tom|||I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;
-)
> --
> Tom
>|||I've scoured the MS website and came up with squat. You may need to call
Product Support and open a ticket.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180469042.970043.254730@.o5g2000hsb.googlegroups.com...
I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend.
> ;-)
> --
> Tom
>|||Thanks! If/When I get an answer I'll be sure to add it to the thread!
David
On May 29, 6:59 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> I've scoured the MS website and came up with squat. You may need to call
> Product Support and open a ticket.
> --
> Tom
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008DThere are post-SP4 hotfixes that can be applied:
http://aspfaq.com/SQL2000Builds.asp
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180007534.344206.147240@.u30g2000hsc.googlegroups.com...
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2039
We fixed one issue, but it brought up another. the fix we applied
stopped the ServicesActive access failure, but now we have a failure
on MSSEARCH. The users this is affecting do NOT have admin rights on
the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D|||Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>|||There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;-)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180013455.778429.265380@.h2g2000hsg.googlegroups.com...
Tom,
Thanks. I don't see any fix beyond SP4 that address' this issue, but
I appreciate the link. I'll try and get to the latest build over
Monthend!
On May 24, 7:56 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There are post-SP4 hotfixes that can be applied:
> http://aspfaq.com/SQL2000Builds.asp
> --
> Tom
>|||Thanks again, this the first I even heard of AWE... since I have 4
gig fo ram I better put in the fixes!
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;
-)
> --
> Tom|||I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend. ;
-)
> --
> Tom
>|||I've scoured the MS website and came up with squat. You may need to call
Product Support and open a ticket.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Hay" <david.hay@.gmail.com> wrote in message
news:1180469042.970043.254730@.o5g2000hsb.googlegroups.com...
I applied all the hotfixes over the weekend. I am still getting the
security error on MSSEARCH.
Any other idea's?
David
On May 24, 11:13 am, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> There was an issue with SP4 turning off AWE. Hotfixes are your friend.
> ;-)
> --
> Tom
>|||Thanks! If/When I get an answer I'll be sure to add it to the thread!
David
On May 29, 6:59 pm, "Tom Moreau" <t...@.dont.spam.me.cips.ca> wrote:
> I've scoured the MS website and came up with squat. You may need to call
> Product Support and open a ticket.
> --
> Tom
Help - Security Event Log Posts Error Event ID 560 every few seconds
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2187 (latest hotfix rollup)
We fixed one issue, but it brought up another. the fix we applied stopped the ServicesActive access failure, but now we have a failure on MSSEARCH. The users this is affecting do NOT have admin rights on the machine, they are SQL developers.
We were having
Restricted Sid Count: 0
Access Mask: 0x2008D
Sql Server 2000, SP 4, 8.00.2187 (latest hotfix rollup)
We fixed one issue, but it brought up another. the fix we applied stopped the ServicesActive access failure, but now we have a failure on MSSEARCH. The users this is affecting do NOT have admin rights on the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Restricted Sid Count: 0
Access Mask: 0x2008D
Please let us know if the problem has been resolved. If not, please let us know, we will need more information (if possible the SQL Server error message) in order to help.
Thanks a lot,
-Raul Garcia
SDE/T
SQL Server Engine
|||No this problem has not been resolved. All logs are/have been posted.
David Hay
|||I am afraid the information you included is not enough for us to determine the cause of these failures. I would recommend contacting Microsoft Premier Support.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
Help - Security Event Log Posts Error Event ID 560 every few seconds
Server 2003 SE SP1 5.2.3790
Sql Server 2000, SP 4, 8.00.2187 (latest hotfix rollup)
We fixed one issue, but it brought up another. the fix we applied stopped the ServicesActive access failure, but now we have a failure on MSSEARCH. The users this is affecting do NOT have admin rights on the machine, they are SQL developers.
We were having
Restricted Sid Count: 0
Access Mask: 0x2008D
Sql Server 2000, SP 4, 8.00.2187 (latest hotfix rollup)
We fixed one issue, but it brought up another. the fix we applied stopped the ServicesActive access failure, but now we have a failure on MSSEARCH. The users this is affecting do NOT have admin rights on the machine, they are SQL developers.
We were having
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 6:27:15 AM
User: domain\user
Computer: MACHINENAME
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,1623975729}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: Domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: User
Client Domain: Domain
Client Logon ID: (0x0,0x6097C608)
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
Applied the following fix
http://support.microsoft.com/kb/907460/
Now we are getting
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/23/2007
Time: 10:51:23 AM
User: domain\user
Computer: MACHINE
Description:
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSEARCH
Handle ID: -
Operation ID: {0,1627659603}
Process ID: 840
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: MACHINE$
Primary Domain: domain
Primary Logon ID: (0x0,0x3E7)
Client User Name: user
Client Domain: domain
Client Logon ID: (0x0,0x60D37C1A)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Restricted Sid Count: 0
Access Mask: 0x2008D
Please let us know if the problem has been resolved. If not, please let us know, we will need more information (if possible the SQL Server error message) in order to help.
Thanks a lot,
-Raul Garcia
SDE/T
SQL Server Engine
|||No this problem has not been resolved. All logs are/have been posted.
David Hay
|||I am afraid the information you included is not enough for us to determine the cause of these failures. I would recommend contacting Microsoft Premier Support.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
Subscribe to:
Posts (Atom)