Re: SMS 2.0 - Remote tools being denied

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

From: Michael Griswold [MSFT] (Michgris_at_online.microsoft.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 07:33:21 -0700

Hi Karl,

    You have SMS 2.0, correct? You can confirm the problem by running the
SQL query "SELECT * FROM SecurityObjUsers" against your SMS DB. Make note
of the case used on the usernames and compare to that found in the
SMSProv.log on the line that looks like:
SELECT * FROM SecurityObjUsers WHERE UserName IN ........

    Any usernames that don't match can be removed from the SMS Security
under the admin UI and re-added by typing in, not browsing. Type the names
in as seen in the SMSProv.log. This should get the name passed by the OS at
RC time to match that in the database which has SQL case sensitive sort
order enabled. 

-- 
- Michael Griswold [MSFT]
- Microsoft Systems Management Server
-- This posting is provided "AS IS" with no warranties, and confers no 
rights. --
<Karl> wrote in message news:O8BrTqkNEHA.2876@TK2MSFTNGP09.phx.gbl...
> We have a few clients that when we try to remote into, we are being denied 
> access to.  MSKB 243300 (http://support.microsoft.com/?kbid=243300) lists 
> the issue but does not have a solution listed.
>
> Can anyone tell me how to verify the case sensitive sort order in the SQL 
> DB and if there is a fix for this isssue?  When it says it does not match 
> the user id of the workstation, what is it referring to?  The workstation 
> that I am working on or the client workstation I am trying to access?  I'm 
> thinking it's the client workstation.
>
> Thanks!
>

Relevant Pages

  • Microsoft SQL Server password cracking
    ... lists in order to halt some worries. ... The password cracker relies on getting access to the hashes that SQL ... It CANNOT work by simply pointing it at an MS SQL server. ... NT usernames and passwords. ...
    (NT-Bugtraq)
  • Re: Searching?
    ... replaced by SQL sometime in the late seventies. ... > What, totally redundant? ... efficiently and quicker than the client workstation. ... is unlikely to cause more network congestion than ...
    (microsoft.public.access.modulesdaovba)
  • Checking the uniqueness of data
    ... I wish to use SQL to interrogate this table to find out how many non-unique ... userNames there are for each accountName. ... I've no idea how to achieve this in SQL. ...
    (microsoft.public.sqlserver.programming)
  • Re: SMS 2.0 - Remote tools being denied
    ... SQL and the only way to change it is to reset and rebuild all the databases. ... > Can anyone tell me how to verify the case sensitive sort order in the SQL ... > am working on or the client workstation I am trying to access? ...
    (microsoft.public.sms.admin)
  • Re: Accessing a SQL DB from the web - IDs - more info
    ... Can these usernames be used as the same in SQL? ... for all our SQL DB's we are using Windows Authenication. ... > I should be able to create an ODBC connection, ...
    (microsoft.public.sqlserver.security)