+ Post New Thread
Results 1 to 7 of 7
Virtual Learning Platforms Thread, Storing AD User Credentials In SSO Database in Technical; Does any one know how to add active directory user credentials to Single sign on database,I am trying to implement ...
  1. #1
    azadsani's Avatar
    Join Date
    Mar 2009
    Location
    yorkshire
    Posts
    29
    Thank Post
    13
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Storing AD User Credentials In SSO Database

    Does any one know how to add active directory user credentials to Single sign on database,I am trying to implement SSO in our sharepoint 2007 farm and have configured the following in central administration > Operations >Manage Single Sign On

    manage server setting

    manage encryption key

    Created Enterprice Application

    But

    "Manage Account Information for an Enterprise Application Definition" Option lets you define one user at a time but what do you do if you have 100s to add.

    I have another problem and that I can 't seem to find microsoft single sign on service on my 2nd front end server It was used as database server but i have instlled WSS 3.0 on it and added it to farm as front end but there is no SSO service on it I have to run this service on every front end. Do I need to install Moss 2007 on the server to get the SSO service or is there any other way.

    I am really stuck please help

  2. #2

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    There's probably an easier way than this, but you could always use some PowerShell script.
    Code:
    foreach ($User in $Userlist) {
    
    $SPSite = New-Object Microsoft.SharePoint.SPSite($URL) $SPRoot = $SPSite.RootWeb $SPUser = $SPRoot.EnsureUser($User) $SPRole = New-Object Microsoft.SharePoint.SPRoleAssignment($SPUser) $SPRole.RoleDefinitionBindings.Add($SPRoot.RoleDefinitions["Read"]) $SPRoot.RoleAssignments.Add($SPRole) $SPSite.Dispose() $SPRoot.Dispose()
    }
    If you give that a username in DOMAIN\Username format as the value of $User, or rather an array of them as $UserList and a URL it'll loop through and assign read permissions to everyone in the list, to the site you've given the URL of.

  3. #3
    azadsani's Avatar
    Join Date
    Mar 2009
    Location
    yorkshire
    Posts
    29
    Thank Post
    13
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi, thanks for reply but may be I did,nt explain this right , I really need to connect the SSO database to active directory so SSO database reflects any changes to a user credentials,
    First I need to add all the users and then database should keep it uptodate, or I can run a script to update it.
    Sharepoint configuration database should have all the user credentials can we use that?

  4. #4

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    Sorry, I misunderstood. I thought you were trying to add the AD users into SharePoint.

    SSO isn't something I know much about, but this may help you: Microsoft SharePoint Designer Team Blog : An Introduction to Single-Sign-On (SSO) with Data Views

  5. Thanks to jamesb from:

    azadsani (10th August 2009)

  6. #5
    azadsani's Avatar
    Join Date
    Mar 2009
    Location
    yorkshire
    Posts
    29
    Thank Post
    13
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks that has really helped,
    I am still struggling to find the answer to second part of my question
    I can 't seem to find microsoft single sign on service on my 2nd front end server It was used as database server but i have instlled WSS 3.0 on it and added it to farm as front end but there is no SSO service on it I have to run this service on every front end. Do I need to install Moss 2007 on the server to get the SSO service or is there any other way.

  7. #6

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    After a bit of hunting I managed to find this: Re: Single Sign On

    Looks like WSS doesn't support single sign-on.

  8. #7
    azadsani's Avatar
    Join Date
    Mar 2009
    Location
    yorkshire
    Posts
    29
    Thank Post
    13
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thaks james ,Guess what I found the same page few minutes age, I have sorted the problem out by installing moss 2007 and enabled the SSO service,
    I have restarted the servers and reconfigured the Central SSO settings, But still it does,nt seems to be working
    It asks me to login when trying to open word documents ,does the same with email mail access from portal.
    not sure what else I acan do?

SHARE:
+ Post New Thread

Similar Threads

  1. NTLM, Samba, LDAP and SSO on Moodle
    By Mintsoft in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 4th July 2011, 06:52 PM
  2. Client images; creating, storing & deploying
    By klop in forum Windows Server 2008
    Replies: 0
    Last Post: 12th May 2009, 11:40 AM
  3. SSO NTLM RADIUS???
    By PWright in forum Wireless Networks
    Replies: 0
    Last Post: 3rd March 2009, 11:52 AM
  4. School's responsibilities for storing data
    By cheredenine in forum School ICT Policies
    Replies: 2
    Last Post: 10th June 2008, 12:53 PM
  5. Remote desktop and user credentials
    By localzuk in forum Thin Client and Virtual Machines
    Replies: 0
    Last Post: 17th March 2008, 01:08 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •