How to resolve Shared Services Provider creation failure?

You may try this: http://blogs.officezealot.com/mauro/archive/2008/03/16/20907.aspx
or this: http://www.portalsolutions.net/Blog/Lists/Posts/Post.aspx?List=1fef67f0-70ca-4263-b683-f10c1958687a&ID=32&Web=2a4e9897-6530-44a1-80b5-4fac295c2c26

http://blog.rafelo.com/2008/04/shared-services-provider-creation.html

@rseabird: I can't follow fully the instructions from the link that you sent, it says some steps for me to delete database of Sharepoint from the SQL Server, but I'm having problem deleting some databases that was generated by Sharepoint through creating web app.

@Ach1lles: What will be next after doing the step by step instructions of the link that you sent? I already received Operation completed successfully. Reset the IIS too.
What's next? Do I need to delete the SSP again & create a new one?

yes.

@Ach1lles: still the same result:
Shared Services Provider creation failed  
Reason: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Check the event log for details.

Note: SSP provisioning will be retried periodically. If you correct the error that caused this failure, provisioning will subsequently succeed. To stop provisioning from being retired, delete the SSP.

Ok, so you've made headway.  Now you need to verify your permissions with the acount you are logged in as.  What permissions do you have on the SQL box?  Should be at least DBCREATOR and SECURITYADMIN.  You also need to be a Farm Admin, set in Central Admin.

@Ach1lles: Could u please advise on how to do check &/or know whether the account I'm using have at least be DBCREATOR & Security Admin? Where to check & how?
For being a Farm Admin, isn't enough to be the Domain Administrator?

Through SQL Server Manager on your SQL server

@Ach1lles: Got it already. I add our domain\administrator & 2 more account as being sysadmin server role, but still getting failure for the result of it.

ERROR MESSAGE:
Reason: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Note: SSP provisioning will be retried periodically. If you correct the error that caused this failure, provisioning will subsequently succeed. To stop provisioning from being retired, delete the SSP.

Would it be possible for you to advise a step by step in creating a SSP? I was thinking regarding the Usernames & Passwords involve in setup.

* If we'll not setup SSP to our Central Admin site, can we still continue working with the Team Site such as making some work flows using SP Designer & InfoPath, but we need to integrate it with SP at a later time. Or setting it up is a must? Please advise.

So you need to check your Farm Admin list, and specifically put your account in there.  This is under Central Admin - Operations - Update Farm Administtrators

@Ach1lles: Please see the attached file for the image captured from our Central Admin, Farm Administrators.
So what would be the next step that I need to do, in order for me to create a new SSP?
Farm-Admin-SP.jpg

which account are you logged in as?  click Shared Services Administration on the left and create a new SSP.  Post any errors you recieve.

In Windows, I'm logged in as local admin. But with Sharepoint, domain administrator.
So can I create a new SSP now?

@Ach1lles:
Here's there error result i received:

FAILURE!
Shared Services Provider creation failed  
Reason: Unable to connect to database. Check database connection information and make sure the database server is running.

Check the event log for details.

Note: SSP provisioning will be retried periodically. If you correct the error that caused this failure, provisioning will subsequently succeed. To stop provisioning from being retired, delete the SSP

You need to log into the machine as the domain admin.  Don't log in as any local account.  That is probably the reason you don't have access to the db's.

It's also the same. That's what I used before, create SSP & got failure, but got problem in deleting db in SQL Server. When I logged in as local admin, then that's the time I can delete the db in SQL. Anyway, I'm trying it again to create SSP as a domain admin, then let u know later for the result again.

sounds like your sql security is definately misconfigured.

So how can I configure it correctly? Please advise......

I suggest starting with this:  http://technet.microsoft.com/en-us/library/cc262243(office.12).aspx

Your install account should have DBCREATOR & SECURITYADMIN sql roles.  SharePoint will automatically grant these roles to your Farm Acct (db access acct) and your App Pool accounts.  THe Farm Acct should be the DB Owner of your config db and your Central Admin db.

I got this error result again:

Shared Services Provider creation failed  
Reason: Thread was being aborted.

Check the event log for details.

Note: SSP provisioning will be retried periodically. If you correct the error that caused this failure, provisioning will subsequently succeed. To stop provisioning from being retired, delete the SSP.

@Ach1lles:
Please see the attached image. I was thinking, would this be the reason why I can't create SSP? Now, I'm logged in as DOMAIN\Administrator in our Windows & in Central Admin as well, but when I checked the information from My Settings of this account, it shows SHAREPOINT\system.
That should be DOMAIN\Administrator. In whereas if I log in using other account, and check the info from My Settings, it shows DOMAIN\user_account

But I tried to logged in 1 of the farm admin & create SSP, still can't. This account has been added to the SQL Server be sysadmin too. But still failed to create SSP.
System-Account-Info.jpg

its operating as a system account, not a big deal.  can you post a screen shot of the site collection admins for your Central Admin site?  don't blank anything out.

also check:  http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/604fed5e-69d3-47c9-8505-b5384b4e55d3

Actually, the above may not help, unless your Office Search is running as network service.  Does the SSP show up under SSP Administration even after the error?

I'm attaching the captured image from our Site Collection List, as per your request from your ID:33635768
From the link that you gave, I think I've done it already, but still no work.
>>  Does the SSP show up under SSP Administration even after the error?
Do u mean the SSP with error result? Yes, it show up even after the error. What do u want me to do? Please advise...
Site-Collection-List.jpg

select the central admin web app and let me see the sc admin. the one above is for ste-sp.

Please see the attached photo.
Site-Collection-CentralAdmin.jpg

The domains in the two pictures are different.  Why?

I remember, when the time I created the Central Admin (Web App), the instructor (where I went for training) didn't told me that I'm working/creating the 1st web app @ the wrong side. I did that @ local admin, then the 1st site collection was done @ domain/administrator.

Sorry, actually just now I noticed it. Is it the problem why I can't create SSP?

So if I reinstall the Sharepoint, what should I do with the SQL Server? Do I need to uninstall it too? For a clean installation. Then you're advising me to install the Sharepoint in DOMAIN\Administrator side?

So it doesn't matter for the SQL if it was installed local admin or domain admin, as long as the domain admin is an admin on the box, am I right?

When I installed the Sharepoint, I selected the Advanced --> Complete, so I'll do it again.
So I'll reinstall the Sharepoint in Domain\Administrator side, please confirm.

Ok. We can stop this thread at this point as I'll reinstall the Sharepoint as you advised.
I'll just open a new thread when I have something to ask again.

BTW, what is WFE?

web front end :)