Re: Password required for Reports

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Mar 1, 11:05 am, Stan <thesta...@xxxxxxxxx> wrote:
Can't run the report from the server (wants user ID and password).
No errors in the server logs.
smsprov.log - StatusMessage.MessageID, StatusMessage.ModuleName,
StatusMessage.RecordID, StatusMessage.Severity, StatusMessage.SiteCode,
StatusMessage.TopLevelSiteCode, StatusMessage.Win32Error from SMS_StatMsg as
StatusMessage join SMS_R_System as System on
StatusMessage.MachineName=System.NetbiosName join SMS_Site as Site on
StatusMessage.SiteCode=Site.SiteCode where (Site.Version like "2.5%")
(This is not the entire log just the only error?)

Reapplied security rights - no luck
Not sure what you mean by reading the SMS keys in WMI - more information
please

Thanks
--
Stan



"Tweak" wrote:
On Feb 28, 11:00 am, Stan <thesta...@xxxxxxxxx> wrote:
JC,
Thanks for the input but I've already checked all those and that's what's
driving me NUTS!! All the permissions are correct, nothing was changed, no
updates were made other than the monthly security patches, it just started
asking for a user id and password!!

--
Stan

"jocarr" wrote:
On Feb 27, 3:54 pm, Stan <thesta...@xxxxxxxxx> wrote:
We are running SMS 2003 w/SP2 on Server 2003 SP1. Three days ago we could
access our reports with no problems then suddenly two days ago it started
prompting for a user name and password and nothing we put in works. I have
read all the inputs from the group I could find and tried all the fixed that
were mentioned but none work. The admins are all running XP Pro sp2 with IE7
and yes it was working with IE7. I have another workstation with IE6 that I
brought up to see if it was an IE7 problem but it asks for a user ID and
password also. I really need to get this fixed as we are in the middle of a
major upgrade involving 8 cities.

Thanks
--
Stan

Hey Stan,

I'm guessing that you tried the your local admin account as well as
your own domain username/pass? Also in the security settings make
sure that all users have rights to view the reports. Also, take a
look at the SMSreporting_xxx web directory permissions, and the
directory security (on ours integrated windows authenication is the
only one checked).

Jc- Hide quoted text -

- Show quoted text -

What happens if you try to access teh report from the SMS server? Did
you check the Security log on the SMS server for any errors? Did you
check the smsprov.log for errors? Did you try to un-installing the
patch on a machine to see if it corrects the problem? Di you re-apply
the security rights for the SMS report in the SMS console? Did you
check to see if you read the SMS keys in WMI?

Tweak- Hide quoted text -

- Show quoted text -

No errors in the Server security log..... You should see something in
the security log loggon/logoff etc....

What i mean about WMI is sometime the WMI go nuts and the security
permision on WMI get corrupt.

So my Computer> manage> WMI Control> Properties> security> Root>sms
and sms>site_yoursitecode

Your SMS admin group should have permissions here, a good indication
that there is a problem is that when you open this up it take a long
time to read the keys.

PS When was the last time you rebooted?

Tweak

.

Relevant Pages

  • Re: Setting Site System Connection Account disabled
    ... the sms is installed in advance security mode. ... But i still have the problem with the distribution point on other server. ... VDABDC002$ account on other server), still the sms says access to the remote ...
    (microsoft.public.sms.admin)
  • Re: Post Windows 2003 Update Errors
    ... > down to a member server later). ... > Everything appears to be fine following the upgrade except that the SMS ... > or local security authority server was in the wrong state to perform ...
    (microsoft.public.sms.setup)
  • Re: Obsolete objects in the Attribute Class drop-down
    ... When you say you ran WBEMTEST to check for the obsolete classes, ... server as well as the clients by updating your sms_def.mof (which i think ... If you've cleaned out the WMI on the site server, ... Windows Server System SMS - MVP ...
    (microsoft.public.sms.admin)
  • Re: Management Point Install
    ... If your site is running in advanced security you have to add the site ... server machine account to the local administrator group of all DP's. ... To determine the security mode of your site, open the sms admin console. ...
    (microsoft.public.sms.setup)
  • Re: New to SMS - have a Collections question.
    ... Windows Server System SMS - MVP ... However this is a security problem. ... Access to objects is based on Security Rights (if you scroll down the ...
    (microsoft.public.sms.admin)