SharePoint SSO error and Window Server 2003 SP1

re: SharePoint SSO error and Window Server 2003 SP1

Robert Hankin — Tue, 12 Jul 2005 14:10:57 GMT

I have also had this problem when I tried setting up single sign on AFTER installing SP1. My initial error was the same as yours: "Failed to connect to the database server. Verify connectivity and rights for the configuration account and try again."
I have tried the RegEdit you have suggested which results in the new error message "A Single Sign-on error has occurred. Please contact an administrator. Details: Unspecified error" Any ideas? I don't really have the option of a full reinstall of the server.
Thanks
Robert Hankin (rhankin@richmond-foods.plc.uk)

re: SharePoint SSO error and Window Server 2003 SP1

James — Sat, 16 Jul 2005 01:16:31 GMT

Thanks for this, you saved me big yesterday.

re: SharePoint SSO error and Window Server 2003 SP1

allez — Mon, 18 Jul 2005 12:57:31 GMT

i did remove the quotation string at the imagepath in the registry..but the error still same as before which "failed to connect to database.."

pls help me..i spent a lot of time to solve this..

re: SharePoint SSO error and Window Server 2003 SP1

Cindy — Wed, 27 Jul 2005 00:52:28 GMT

Thank you very much for this information!

re: SharePoint SSO error and Window Server 2003 SP1

Gareth — Wed, 27 Jul 2005 16:43:19 GMT

We experienced the same error but found a different root cause.

We found that some of the various tables in the SP DB had <null> as the owner. We ran a SQL script to determine which tables had this issue and then changing the ownership to a service account.

NOTE: We do not have Win2003 SP1 installed, although we do have Windows Installer 3.1 installed. I did not find any quotes around the regestry values.

re: SharePoint SSO error and Window Server 2003 SP1

Edgar — Mon, 01 Aug 2005 22:22:33 GMT

I had this problem, i've Windows 2003 SP1, and SPS 2003 SP1 chang privileges to tempdb on SQL Server for my service account to db_owner and change de database name from SSO to SSO_DB and works

re: SharePoint SSO error and Window Server 2003 SP1

iuy — Wed, 03 Aug 2005 19:20:06 GMT

I'm also having the same problem but removing the quotation strings alone from the registry didn't work for me.

I also had to stop & start the service of Micrsoft Single Sign on before it worked.

Thanks for the registry information!

re: SharePoint SSO error and Window Server 2003 SP1

Rick King — Tue, 09 Aug 2005 21:30:08 GMT

Yes you do have to restart the Microsoft Single Sign-on Service before this works. Here is the KB Article: KB901203

re: SharePoint SSO error and Window Server 2003 SP1

Syed Adnan Ahmed — Sat, 10 Sep 2005 17:50:28 GMT

I restart the Microsoft Single Sign-On Service after updating the registry file, but still problem does not resolved.
Any body who face the same problem, please reply.
Adnan

re: SharePoint SSO error and Window Server 2003 SP1

SSOHell — Tue, 15 Nov 2005 02:18:59 GMT

if there is a heaven my friend.. you are there!
you saved me BIG. Thanks

re: SharePoint SSO error and Window Server 2003 SP1

Darryl Lowe — Tue, 22 Nov 2005 04:53:54 GMT

Yep. That did it! Be sure to bounce the SSO service before trying again!

re: SharePoint SSO error and Window Server 2003 SP1

Surdeep — Fri, 02 Dec 2005 11:48:06 GMT

Thanks a ton Dude this worked fine! You sure are going to get a nod at the Pearly Gates!

re: SharePoint SSO error and Window Server 2003 SP1

IKELoser — Tue, 06 Dec 2005 20:39:56 GMT

Similar story. Up down back forth no joy till the quotes were removed and restarted SSO service.
Many Thanks!

re: SharePoint SSO error and Window Server 2003 SP1

Perfect — Thu, 22 Dec 2005 01:10:15 GMT

This worked great! you are so cool!

re: SharePoint SSO error and Window Server 2003 SP1

Paul S — Thu, 29 Dec 2005 20:53:33 GMT

Wow! Stepping through the SPS Discovery kit and ran into this problem. The reg hack worked like a charm.

re: SharePoint SSO error and Window Server 2003 SP1

PTR — Tue, 21 Feb 2006 12:23:05 GMT

Thanks very much!

I was fiddeling with this problem for quite some time!

Works fine now!

re: SharePoint SSO error and Window Server 2003 SP1

Syed Adnan Ahmed — Mon, 27 Feb 2006 14:58:36 GMT

Hi,
I have MS SharePoint Portal Server 2003 installed with SP2 and WSS with Sp2 as well. I am using SQL Server 2005 to connect to DB. I have removed quotation marks from the registry as well. But still getting the following error: "You do not have the rights to perform this operation."

re: SharePoint SSO error and Window Server 2003 SP1

CHARPER — Thu, 02 Mar 2006 06:38:22 GMT

This worked like a charm! Removed the quotes and rebooted and works flawlessly now.

Syed -- for reference, I have the same setup as you including SQL 2005 and my setup works. Hope this helps!

re: SharePoint SSO error and Window Server 2003 SP1

Ted — Fri, 03 Mar 2006 03:51:16 GMT

thanks, I wasted several hours thinking I was a complete idiot until I looked up the problem on the internet.

Thanks. I can go home and not beat my kids tonight.

re: SharePoint SSO error and Window Server 2003 SP1

Dave Gregory — Thu, 09 Mar 2006 17:24:30 GMT

You won't believe this: Couldn't make any of the above fixes work until I made the single sign on domain user a local admin on the database box

re: SharePoint SSO error and Window Server 2003 SP1

Alex — Thu, 16 Mar 2006 07:30:16 GMT

Woooooooooo!
3+ hours of hurt before i found this blog.
SQL 2005 + SPPS sp2 + W2003 SP1 = pain.

THANK YOU.

re: SharePoint SSO error and Window Server 2003 SP1

chjohn — Wed, 22 Mar 2006 01:43:09 GMT

No problem ... it frustrated me for a long time before i figured it out. Glad it has helped.

re: SharePoint SSO error and Window Server 2003 SP1

David Baumann — Fri, 31 Mar 2006 11:07:53 GMT

I had the same Problem , i fix the Regkey then i become 0x80040E14 Error

I logon on the Server and login with the Service Account from "SSO Service" start the SSO Config Page, at me it works now.

Hope i can help someone

re: SharePoint SSO error and Window Server 2003 SP1

Rahul — Wed, 05 Apr 2006 15:36:29 GMT

Thank you very much for your article..
it helped us a lot

re: SharePoint SSO error and Window Server 2003 SP1

Nico De Nysschen — Thu, 20 Apr 2006 14:41:32 GMT

Read the article, thought it was a good shot after granting full access on all SQL db's etc. Then I used this article to remove the registry quotations from the imagepath but still nothing.. Only Musch later realised that you have to stop and start the Microsft Single-Sign-On service.

Thanks all, this helped a stack!!

re: SharePoint SSO error and Window Server 2003 SP1

Ambreen — Mon, 26 Jun 2006 19:02:56 GMT

hello Chris,

i'm having issues with this sso thing too, wondering if you can help. i have everything configured and i can add accounts to my db and if i go run the stored procedure to get all credentials it also returns me a row confirming that the application and credentials are there but i keep getting an error for the Credentials.getCredentials method call. i'm able to successfully call the setCredentials and setUserCredential methods, based on code samples on microsoft site but getCredentials seems to be failing. Any help would be greatly appreciated.

thanks,
ambreen

here's what it shows in event log

Event Type: Error
Event Source: Office SharePoint Server
Event Category: SSO
Event ID: 6492
Date: 6/26/2006
Time: 10:48:09 AM
User: N/A
Computer: mycomp
Description:
The Microsoft Single Sign-on (SSOSrv) service failed to retrieve credentials for user mydomain\myuser, enterprise application definition Northwind. The error returned was 0x80040e14. For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

re: SharePoint SSO error and Window Server 2003 SP1

Steve — Fri, 30 Jun 2006 03:54:15 GMT

After hours of pulling my hair thinking that I was doing something wrong!!! It blows my mind how the error message would suggest something so wrong. But thanks much, you saved the day!

Syed Aziz ur Rahman : Problem in configuring Single SignOn Service (SSO) on Windows Server 2003 with SP1

Tue, 11 Jul 2006 09:38:02 GMT

PingBack from http://weblogs.com.pk/aziz/archive/2006/07/11/4492.aspx

re: SharePoint SSO error and Window Server 2003 SP1

Andrew — Tue, 11 Jul 2006 14:17:26 GMT

I've tryed everything, but nothing worked untill I found a bug in "c:\Program Files\Common Files\Microsoft Shared\Microsoft Single Sign-on\sso_schema.sql". It seems to be because of that my SQLServer's default code page was case sensitive and a variable in this script did not met case in the declaration.
Procedure:dbo.sso_InsertUpdateApplication, variable @Numfields (@numfields and @NumFields).
Try to run SQL Query Analyzer, open this script and press Ctrl+F5 (Parse Query). After correcting case of those strings - try to run SSO configuration again.
If you want to ask about it - write to "anpal at bigmir dot net".

Good luck!

re: SharePoint SSO error and Window Server 2003 SP1

Andrew — Tue, 11 Jul 2006 14:18:35 GMT

I've tried everything, but nothing worked untill I found a bug in "c:\Program Files\Common Files\Microsoft Shared\Microsoft Single Sign-on\sso_schema.sql". It seems to be because of that my SQLServer's default code page was case sensitive and a variable in this script did not met case in the declaration.
Procedure:dbo.sso_InsertUpdateApplication, variable @Numfields (@numfields and @NumFields).
Try to run SQL Query Analyzer, open this script and press Ctrl+F5 (Parse Query). After correcting case of those strings - try to run SSO configuration again.
If you want to ask about it - write to "anpal at bigmir dot net".

Good luck!

re: SharePoint SSO error and Window Server 2003 SP1

Denis — Mon, 14 Aug 2006 10:04:39 GMT

I was also receiving all of the various errors reported above and ended with the 0x80040E14 Error.

I was already logged onto the Server as the SSO Admin Account so this didnt resolve my problem.

In my case I needed to delete the SSO database that had been created along the way. Once this was done it recreated it and started working like a charm.

Denis @ obs

re: SharePoint SSO error and Window Server 2003 SP1

sri — Tue, 07 Nov 2006 06:35:57 GMT

Hi,

I have MS SharePoint Portal Server 2003 installed with SP2 and WSS with Sp2 as well. I am using SQL Server 2005 to connect to DB. I have removed quotation marks from the registry as well. But still getting the following error: "You do not have the rights to perform this operation."

re: SharePoint SSO error and Window Server 2003 SP1

Mark Stokes — Fri, 10 Nov 2006 18:44:28 GMT

Just to add my 2pence to the discussion...

I tried all the suggestions above to no avail. I finally came across the fact that the SSO Service was running as the local system account.

I changed this to a domain account and it works perfectly.

Mark

re: SharePoint SSO error and Window Server 2003 SP1

ewan — Tue, 19 Dec 2006 21:48:51 GMT

I ran into this problem. Turns out I had a sql database without an owner -- that database was not even a sharepoint database, but it affected creating the SSO DB!! Grr...

check to see if you have any databases without an owner

use master select * from sysdatabases where suser_sname(sid) is NULL

user <name of database that does not have

sp_changedbowner 'sa'

re: SharePoint SSO error and Window Server 2003 SP1

ewan — Tue, 19 Dec 2006 21:49:13 GMT

I ran into this problem. Turns out I had a sql database without an owner -- that database was not even a sharepoint database, but it affected creating the SSO DB!! Grr...

check to see if you have any databases without an owner

use master select * from sysdatabases where suser_sname(sid) is NULL

use <insert database without owner>

sp_changedbowner 'sa'

re: SharePoint SSO error and Window Server 2003 SP1

lops — Mon, 16 Apr 2007 15:21:06 GMT

Mark Stokes thanx a lot!

Removing quotes didn't help for me as well, but your suggestion regarding changing local account to domain one for SSO Service did the trick. :)

Regards,

re: SharePoint SSO error and Window Server 2003 SP1

MikeK — Mon, 30 Apr 2007 18:39:32 GMT

It was the missing DB owner for me. I am using a shared SB server for SPS03 and I had one application's DB with no owner.

use <insert database without owner>

EXEC sp_changedbowner 'sa'

Is what i used...

Brutal, absolutely brutal.

re: SharePoint SSO error and Window Server 2003 SP1

Surgence — Fri, 04 May 2007 00:43:32 GMT

If you are getting the "0x80040e14" error, I found out that this could be caused by the SSO Encryption key that Sharepoint creates.

Goto

Central Administration > Operations > Manage Single Sign-On > Manage Encryption Key

Create a new key and make sure the Check Box IS checked! This seemed to do the trick for me after the registry trick didnt work! Hope this helps!

re: SharePoint SSO error and Window Server 2003 SP1

PKONSITE — Wed, 23 May 2007 14:10:46 GMT

Hi!

re: SharePoint SSO error and Window Server 2003 SP1

Jonathan Davey (TheJD) — Sun, 04 Nov 2007 00:56:23 GMT

Well done guys! I have no experience in SQL or programming but after removing speach marks, resetting MSSO snapin AND resetting MOSS/SSO bumf all works well!

However still dont understand why SP-Designer is throwing up same error when not using SSO ie domain/administrator....?

re: SharePoint SSO error and Window Server 2003 SP1

Vedanshu — Tue, 06 Nov 2007 15:47:19 GMT

Excellent articles on resolving SSO Issues with MOSS 2007.

http://chriscalderon.blogspot.com/2007/05/resolving-microsoft-single-sign-on.html

http://cakriwut.wordpress.com/2007/08/19/moss-2007-fixing-ssosrv-error-0x80040e14/

re: SharePoint SSO error and Window Server 2003 SP1

Bert Linders — Wed, 26 Dec 2007 18:47:59 GMT

Try logging on to the server with the account you want to use (but first make sure this account is an OSS admin). Make sure the account has all requirements for SSO and then complete the page. This solved the issue for me.

re: SharePoint SSO error and Window Server 2003 SP1

kjeld poulsen — Wed, 09 Apr 2008 08:56:37 GMT

I needed SSO to get SAP iView to work on MOSS 2007. I tried all the above steps without luck. Finally i installes the SPS SP1 and MOSS SP1, rebooted the share point 2007 frontend servers, generated new SSO keys, with check for update existing passwords, - that made the trick.

Tnx. a lot for the help.

Famous Funny Movie Quotes and Stuff » Chris Johnson : SharePoint SSO error and Window Server 2003 SP1

Thu, 01 May 2008 11:38:47 GMT

PingBack from http://famousfunnymoviequoteblog.info/chris-johnson-sharepoint-sso-error-and-window-server-2003-sp1/