Re: Access SMS Issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry Kim but I just noticed your reply. The server is currently Win2K3 SP2
- is the membership still required?

"Kim Oppalfens [MVP]" <""Kim dot Oppalfen" wrote:

Carol Deavy wrote:
Testing the System Administrator Console from the XP SP2 workstation using my
admin account (which works fine directly on the SMS server) failed.

Next I thought maybe it was due to installing the console on the XP machine
using the SP3 upgrade download so I uninstalled and installed the original
SMS (without any service packs) and upgraded the console with the downloaded
SP3. Still not able to connect.

Found, on the XP workstation, in the adminui.log

:Info(ConnectServer): Connection to server. Network : \\SMS_002\root\sms
:Error(ConnectServer): Possible UI connection error code is -2147023174
(0x800706ba)

I've searched google and the news groups, so far, and have found no solution
to being able to connect to the SMS via XP workstation using the
Administrator Console. Anyone have a solution?

"Carol Deavy" wrote:

All good questions as I didn't think about trying to launch the System
Administrator Console with my admin account on the XP workstation until I
left the office for the day...

I do not remember seeing anything during the SP3 upgrade which asked which
mode I would like to use. How would I know which mode it is in at this time?

If I log onto the SMS server directly with my admin account, connection to
SMS works fine. If I log onto an XP workstation with the same account and
launch the SP3 installed System Administrator Console, I get the same results
"Connection Failed: \\sms_site\root\sms"

Could it be a component I am forgetting to install on the XP workstation?

Thanks for your help

"Steve Thompson" wrote:

Did you switch security modes by chance? In other words, change your
security mode from standard to advanced at time of upgrade? Also, does a
user with sms administrative rights have access to your reports?

Steve
"Carol Deavy" <CarolDeavy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A1AB2C32-7B42-4C91-A586-30B970104775@xxxxxxxxxxxxxxxx
I'm trying to set up a user to have access to reports only. I have added
the
user to the SMS Admins group and SMS Reporting Users on the SMS server but
continue to get the Connection Failed: \\sms_site\root\sms

What are all the components to provide access?
Membership of the SMS Admins group is one that I know of, membership of
the
SMS Reporting Users (I believe is required).

I have just upgraded the server to SP3 and performed the following again
(as
I did when SP2 was applied)

Run dcomcnfg.exe, expand Component Services, expand My Computer, expand
DCOM
Config, find and right-click on the SMS_REPORTING_POINT node and click on
Properties. Go to the Security tab and in the top section "Launch and
Activation Permissions" click on Customize and then click on the Edit
button. Once the Security window opens you want to verify that the "SMS
Reporting Users" group is listed in the Group or names window and that it
has Local Activation permissions. If not, make this change. SMS 2003 SP3
will lock down these DCOM permissions and give the error that you are
seeing.




Is the server running Win2k3 sp1 by any chance?
If so, add your account to the distributed com users group on the server.

--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx

.

Relevant Pages

  • Re: Unable to Install SMS 2003 R2
    ... Since SP3 is greater than SMS 2003 R2, this would make sense that you can't install it over top of SP3. ... Tool installer is asking for the SQL server information. ...
    (microsoft.public.sms.admin)
  • Re: Access SMS Issue
    ... Next I thought maybe it was due to installing the console on the XP machine using the SP3 upgrade download so I uninstalled and installed the original SMS and upgraded the console with the downloaded SP3. ... Administrator Console with my admin account on the XP workstation until I left the office for the day... ... If I log onto the SMS server directly with my admin account, ...
    (microsoft.public.sms.admin)
  • Sms server not responding
    ... When they open SMS concole they get a hourglass and the SMS sever is ... When these consoles disconnect the server ... SMS 2003 sp3 ...
    (microsoft.public.sms.admin)
  • SMS 2003 - 64-bit clients?
    ... it appears as if the only version of SMS ... is SMS 2.5 (SP3). ... Here's the full info taken directly form the server: ...
    (microsoft.public.sms.setup)
  • Cant see non-local cubes
    ... In using AS 2000 with sp3, I'm getting the message "errors occured while connecting to" server xxx. ... With the Admin account I can get 2 the Foodmart DB, ...
    (microsoft.public.sqlserver.olap)