Monday, March 19, 2012
Help : I Can't Re-installed RS !
My Database is on a distant Server.
I want to re-install Reporting Service and I have this message when I select
my Report Server Database (the same as before the uninstal) : "The Report
Server Database is a different version and cannot be used for this
installation."
Can you help me ?First you need to install RS and point to an new DB. After the install
upgrade RS to SP1. Once this is done you will need to run RSConfig to point
to the old DB. If you saved off your Symmetric key you will want to reapply
it using rskeymgmt.exe. If you did not you will need to run
rskeymgmt.exe -d. Doing this will delete all the encrypted content, meaning
you will have to reenter all of your report credentials.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> I uninstalled Reporting Services SP1 from the development environment.
> My Database is on a distant Server.
> I want to re-install Reporting Service and I have this message when I
select
> my Report Server Database (the same as before the uninstal) : "The Report
> Server Database is a different version and cannot be used for this
> installation."
> Can you help me ?
>
>|||Karine,
I have a step-by-step document that you may find useful:
http://prologika.com/blog/archive/2004/08/20/161.aspx
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com : http://tinyurl.com/3l49j
Home page and blog: http://www.prologika.com/
----
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23ymuy74iEHA.1040@.TK2MSFTNGP09.phx.gbl...
> First you need to install RS and point to an new DB. After the install
> upgrade RS to SP1. Once this is done you will need to run RSConfig to
point
> to the old DB. If you saved off your Symmetric key you will want to
reapply
> it using rskeymgmt.exe. If you did not you will need to run
> rskeymgmt.exe -d. Doing this will delete all the encrypted content,
meaning
> you will have to reenter all of your report credentials.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Karine" <Karine@.discussions.microsoft.com> wrote in message
> news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> > I uninstalled Reporting Services SP1 from the development environment.
> > My Database is on a distant Server.
> > I want to re-install Reporting Service and I have this message when I
> select
> > my Report Server Database (the same as before the uninstal) : "The
Report
> > Server Database is a different version and cannot be used for this
> > installation."
> >
> > Can you help me ?
> >
> >
> >
>|||Thanks.
I don't use your method because RS has allready uninstalled and so I can't
save my key.
I delete from my SQL Server the DataBase Report and the database
ReportserverTempDB. I run RS install, I select my SQL Server and I can
continu running the install.
I can deploy my reports so now ... all is good ...
"Teo Lachev" wrote:
> Karine,
> I have a step-by-step document that you may find useful:
> http://prologika.com/blog/archive/2004/08/20/161.aspx
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com : http://tinyurl.com/3l49j
> Home page and blog: http://www.prologika.com/
> ----
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23ymuy74iEHA.1040@.TK2MSFTNGP09.phx.gbl...
> > First you need to install RS and point to an new DB. After the install
> > upgrade RS to SP1. Once this is done you will need to run RSConfig to
> point
> > to the old DB. If you saved off your Symmetric key you will want to
> reapply
> > it using rskeymgmt.exe. If you did not you will need to run
> > rskeymgmt.exe -d. Doing this will delete all the encrypted content,
> meaning
> > you will have to reenter all of your report credentials.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Karine" <Karine@.discussions.microsoft.com> wrote in message
> > news:074B3037-396E-45D3-B245-1E6798FA1ED1@.microsoft.com...
> > > I uninstalled Reporting Services SP1 from the development environment.
> > > My Database is on a distant Server.
> > > I want to re-install Reporting Service and I have this message when I
> > select
> > > my Report Server Database (the same as before the uninstal) : "The
> Report
> > > Server Database is a different version and cannot be used for this
> > > installation."
> > >
> > > Can you help me ?
> > >
> > >
> > >
> >
> >
>
>
Wednesday, March 7, 2012
Help - Security Event Log Posts Error Event ID 560 every few seconds!
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!
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!
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
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
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 - Reportserver is not Responding Error
RS 2005 (sql 2005 SP1) on Windows 2003 SP1
The report server was running ok until this morning. Its just giving a "The
report server is not responding. Verify that the report server is running and
can be accessed from this computer." message when trying to open the report
manager.
Any ideas?
In the SQLDUMPER_ERRORLog.log file there is this..
05/22/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges
() failed (00000514)
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4
supplied
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 328
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr
= 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
05/22/06 12:53:36, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not
used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\LogFiles\SQLDmpr0001.mdmp
05/22/06 12:53:37, ACTION, w3wp.exe, Watson Invoke: NoCouldn't find a solution, ended up uninstalling and re-installing SQL 2005.
No problems now but that was a nightmare.
"NH" wrote:
> Hi,
> RS 2005 (sql 2005 SP1) on Windows 2003 SP1
> The report server was running ok until this morning. Its just giving a "The
> report server is not responding. Verify that the report server is running and
> can be accessed from this computer." message when trying to open the report
> manager.
> Any ideas?
> In the SQLDUMPER_ERRORLog.log file there is this..
> 05/22/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges
> () failed (00000514)
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4
> supplied
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 328
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr => 0x47405860
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr
> = 0x00000000
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr => 0x00000000
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName => <NULL>
> 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
> 05/22/06 12:53:36, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not
> used
> 05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
> 05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed:
> C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
> Services\LogFiles\SQLDmpr0001.mdmp
> 05/22/06 12:53:37, ACTION, w3wp.exe, Watson Invoke: No
>