Re: SMS Administrator Console



Mark,

Thanks for the reply. In my case, my SMS server is also running SQL. It's
just one of those quirky “Windows” problems that occur from time to time. I
have 10+ workstations that connect and function just fine. Then I have 2 that
are somehow “different”. All of the workstations are the exact same hardware
and were created via the same Symantec Ghost image; cookie cutter to avoid
issues such as this. The machines are locked down via GPOs and no one is a
local admin or even a power user (at least on the 2 machines that are
broken). I plan on running SP2 for SMS 2003. This might magically fix the
problem. I’ll keep you posted.

Tim

"Mark Morrall" wrote:

Tim,

thanks for replying. I have been digging around a bit and have actually
resolved my issue. I am not sure if it's the same as yours but here's how I
resovled it:

I have 2 SMS site servers, the primary site & a Database server (SQL 2000)
on a 2000 Server. It turned out to be a problem on the SQL Server where the
site server couldn't query the DB tables. I noticed the following error in
smsprov.log

Microsoft SQL Server reported SQL message 229, severity 14:
[42000][229][Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission
denied on object 'SecurityObjs', database 'SMSSite1', owner 'dbo'.

After a lot of head scratching, this tunred out to be because the site
machine account did not have local Administrator rights on the SQL server. I
had originally added the MACHINE account to the group, but something in our
Group Policy was resetting it every so often and removing the entry.

Anyway, we got round that by adding the account at the Group Policy level
and it works a treat. Just got tons of other problems now!

Not sure if that will help you, good luck.

Mark.

"Tim Stockton" wrote:

Mark,

Not yet. Other, higher priority problems have pushed this one further down
the line. I will be sure to post something once I have a resolution.

Tim

"Mark Morrall" wrote:

Tim, did you ever figure this out? I am having exactly the same problem. Any
help would be greatly appretiated.

Thanks

"Tim Stockton" wrote:

Is this a case for Microsoft PSS?

"Tim Stockton" wrote:

The adminui.log does contain a few of errors. I will paste them here:

[FB8][Wed 02/15/2006 15:28:38]:Error(CheckForDisconnect1): Invalid service
pointer. WMI connection has been dropped. : -2147022986 [0x80070776]
[FB8][Wed 02/15/2006 15:28:35]:Error: CWbemAsyncNodeFactory::Enumerate:
ExecQueryAsync returns error code is -2147022986 [FB8][Wed 02/15/2006
15:28:35]:CWbemAsyncNodeFactory::Enumerate Failed

Nothing out of the ordinary in the event viewer. All machines are in the
same domain and receive the same GPOs. Also, all machines are on the same
subnet and nothing is blocked "inside" to "inside".

"Dave Halperin" wrote:

Forgot, check your ports:
http://support.microsoft.com/default.aspx?scid=kb;en-us;826852


"Dave Halperin" <Dave_Halperin@xxxxxxxx> wrote in message
news:OjHErCnMGHA.1536@xxxxxxxxxxxxxxxxxxxxxxx
Did you check C:\SMSADMIN\logs\adminui.log and see what errors show up?
Also check your event viewer, could be a setting on the machine. Lastly,
check your AD policies.
"Tim Stockton" <TimStockton@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7BF09B42-5032-45B7-A549-58A29DB3BBA5@xxxxxxxxxxxxxxxx
Allowing anonymous remote access rights in DCOM still did not resolve the
issue.

"Dave Halperin" wrote:

Even thought they are XP SP1, the SP2 fix might work:


http://www.microsoft.com/technet/prodtechnol/sms/sms2003/techfaq/tfaq03.mspx#EXGAC


At the bottom of the page.


"Tim Stockton" <TimStockton@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:14F470D3-9781-4EAF-855F-1F742EDBDDBE@xxxxxxxxxxxxxxxx
All XP systems are SP1.

"Greg Ramsey" wrote:

Are all the XP systems SP1? If XP SP2, maybe a firewall issue?


"Tim Stockton" <TimStockton@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:62787CEA-3BE6-4577-8C68-EF284D501DBC@xxxxxxxxxxxxxxxx
I have a Windows 2003 server running SMS 2003 SP1. All users are
running
Windows XP SP1 and an SMS Admin console that is SP1. Certain
machines
will
connect to the site database but when you click on "Collections",
the
console
merely states "There are no items to show in this view."
Apparently,
the
problem is machine specific and is not security related because it
doesn't
matter who is logged in. On certain machines, it always works. On
others,
it
never works. Any suggestions?











.



Relevant Pages

  • MP Control Manager Issue
    ... Windows 2003 Standard Server ... SMS 2003 SP1 ... MP encountered an error when connecting to SQL Server. ... If using a standard SQL security account, ...
    (microsoft.public.sms.admin)
  • Re: SMS 2003 and real-time replication
    ... I am using nsi double-take to replicate the SQL ... data in real time to another server. ... recover from a failure quicker than what is outlined in the SMS Backup manual. ...
    (microsoft.public.sms.admin)
  • Re: sms2003 installation in windows2003 two cluster sql node
    ... > Systems Management Server 2003 cluster support requirements ... >> SMS Questions should be posted over in a different newsgroup in the ... >> In the case of SQL on clusters though Microsoft doesn't support it (or at ...
    (microsoft.public.sms.installer)
  • Re: Backup and reinstall
    ... I played with this in my test lab, and the machines did not report in until ... You have laptops with SMS agents on them. ... > correctly provided site code & site server name. ...
    (microsoft.public.sms.setup)
  • Re: Fresh Install Doesnt Work...Again!
    ... I will verify the sql service account and get back. ... MVP Windows Server System - SMS ... I am attempting to install SMS 2003 SP1 in a production ...
    (microsoft.public.sms.setup)