The biggest pain in the world to set up… after starting to follow a nice Blog post detailing from step 1 how to set up SSO on SharePoint, linking it in with SQL, and getting it all running i hit a brick wall… i couldn’t set the newly created SSO admin account to have the correct permissions in SQL. This was solved eventually by logging on as the account that set up SQL originally and trying again… success! Next step… SP Central Admin… and a lovely error “cannot connect to configuration database”… 3 hours of internet searching, trying everything possible, i eventually find a SharePoint configuration wizard on the server, run that and bang it’s back up… another success… and only 5 hours into what should be an hour long job!
Next step, configure central admin for SSO… off i go into the correct page… type in all of the settings that are required, all is going well until i click “OK” and BANG another brick wall! Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Great! Another problem, no doubt another few hours spent trying to figure this latest in a long line of problems I'm encountering setting this up…
#UPDATE#
To solve this issue, you must log onto the machine holding your central administration application as the SSO admin account. Changing the user you’re signed in as within Central Admin does not cut it you have to be fully logged onto the machine as SSO Admin…
So far I've found SharePoint to be one of the most non user friendly systems to set up… try to do something… oh no, i don’t have permission to do that, find where to grant permissions, get to the next OK button and oh look, shock horror, more permissions problems.
Updates to follow once I've figured this out…
No comments:
Post a Comment