Re: SMS 2.0 - Remote Tools being denied on some PC's

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Stan White [MS] (stanwh_at_microsoft.com)
Date: 07/22/04


Date: Thu, 22 Jul 2004 13:39:38 -0700

Taking offline with Karl

-- 
-- 
Stan [MSFT]
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
--
--
"-Karl" <dinodod27@hotmail.com> wrote in message 
news:d0dd1fcf.0407161116.4180e050@posting.google.com...
>I was informed a while back to compare what is in the SQL DB to that
> in my SMSPROV.log.  Here are the results:
>
> Now will someone please assist me.  I have been asking for help for
> several weeks now and I have not been able to get past this stage.
> New PC's that we are setting up are being denied access while the old
> systems are fine (regardless of OS) and repairing the agents does not
> work.
>
> Thank you!
>
>
> SQL DB
> ================
> 1 epmc38\cmcendree 0
> 1 EPMC38\Dante 8167
> 1 epmc38\dgutierrez 8163
> 1 EPMC38\Kalderson 5831
> 1 epmc38\sms remote admin 6145
> 1 EPMCNT3\Administrator 8167
> 1 NT AUTHORITY\SYSTEM 8167
> 2 EPMC38\Dante 1295
> 2 EPMC38\Kalderson 1039
> 2 epmc38\sms remote admin 1
> 2 EPMCNT3\Administrator 1295
> 2 NT AUTHORITY\SYSTEM 1295
> 3 EPMC38\Dante 1287
> 3 epmc38\dgutierrez 256
> 3 EPMC38\Kalderson 1031
> 3 epmc38\sms remote admin 1
> 3 EPMCNT3\Administrator 1287
> 3 NT AUTHORITY\SYSTEM 1287
> 4 EPMC38\Dante 1285
> 4 epmc38\dgutierrez 256
> 4 epmc38\sms remote admin 1
> 4 EPMCNT3\Administrator 1285
> 4 NT AUTHORITY\SYSTEM 1285
> 6 epmc38\cmcendree 0
> 6 EPMC38\Dante 1283
> 6 epmc38\dgutierrez 0
> 6 EPMC38\Kalderson 3
> 6 epmc38\sms remote admin 0
> 6 EPMCNT3\Administrator 1287
> 6 NT AUTHORITY\SYSTEM 1287
> 7 EPMC38\Dante 1287
> 7 EPMC38\DBay 0
> 7 epmc38\dcuizon 1
> 7 epmc38\dgutierrez 0
> 7 EPMC38\Kalderson 1031
> 7 epmc38\sms remote admin 1
> 7 EPMCNT3\Administrator 1287
> 7 NT AUTHORITY\SYSTEM 1287
>
>
> SMSPROV.log
> ========================
> AA][Fri 07/16/2004 09:02:35]:Checking users existence in security
> database: SELECT * FROM SecurityObjUsers WHERE UserName IN
> ("EPMC38\RPhelps","EPMC38\Domain Users","EPMCNT3\SMS
> Admins","BUILTIN\Users","EPMC38\Cisco56k","EPMC38\EPMC-IS
> Staff","EPMC38\Signin Program","EPMC38\epa_activcard","EPMC38\EPMC_NL
> - Admin","EPMC38\SMS Remote admin","NT AUTHORITY\NETWORK","NT
> AUTHORITY\Authenticated Users")
>
>
>
> Remote Tools Security
> ===========================
> Administrators
> epmc38\cmcendree
> EPMC38\DBay
> EPMC38\DCuizon
> EPMC38\DGutierrez
> EPMC38\kalderson
> EPMC38\RPhelps
> EPMC38\Sormsby
> EPMC38\Support 


Relevant Pages

  • Re: Passing IDs in SQL
    ... William (Bill) Vaughn ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >> Let's see how you're setting up the SQL in code. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Passing IDs in SQL
    ... William (Bill) Vaughn ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >> Let's see how you're setting up the SQL in code. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL SLAMMER
    ... that's named pipes but from the way SQL Server 7.0 did it... ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL security
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > We recently installed a new win2K server with SQL 7. ... I joined the Win2K server to the existing NT ...
    (microsoft.public.sqlserver.security)
  • Re: Maximum row size for SQLExpress
    ... Express has the extended row size functionality introduced in SQL ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > funcationality as SQL Server 2005. ...
    (microsoft.public.sqlserver.msde)