Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

User Profile service, really stuck here

  Asked By: Bennie    Date: Nov 28    Category: Sharepoint    Views: 1597

Cannot drop the procedure 'pSProcStandard', because it does not exist or you do
not have permission.

Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: 2ba74785-7c33-4076-9bfc-e9e7b3b5b9fd
Date and Time: 8/30/2010 6:18:03 PM

I have set up an entire farm, and this is the only service I can't get started,
google and bing are no help at all. I have deleted the service and tried to
recreated it but I keep getting this error.

SQL is running 2005 sp3 on windows server 2003 R2 64 bit. All other servers are
running windows 2008 R2 64 bit.

Just for fun I set up a small server with SQL 2008 and was able to get the
service running on the same domain, but everything I read tells me that SQL 2005
sp3 on any server should be fine.

this is so bad I am ready to pay someone to help.



5 Answers Found

Answer #1    Answered By: Xavier Hopkins     Answered On: Nov 28

There are three versions of SQL that are supported, 2005, 2008 and 2008
R2. This page lists the supported versions and the patches you need for
each, technet.microsoft.com/en-us/library/cc262485.aspx

If you haven't already, read this blog post by Spence Harbar on the User
Profile Service, http://www.harbar.net/articles/sp2010ups.aspx At the
bottom is an example scenario that walks you through configuring the UPS
step by step. Try those steps and see if it works for you.

Have you looked through your ULS logs for all of the activities with the
correlation ID listed below? There might be a clue to your problem

Answer #2    Answered By: Viviana Rollins     Answered On: Nov 28

I have done all of this, I am totally up to date on my servers and patches,
every time I try to do the configuration, bang, same thing. I will go look
though the log and see, but I think it is going to give me the same thing, proc
couldn't be installed. I have done this farm install a few times now, and never
had any problems before, I guess I should feel lucky that this is my first real
issue so far.

Answer #3    Answered By: Erika Price     Answered On: Nov 28

I read somewhere that the UPS does not support SQL
instances. Any word on if the June roll-up fixes that problem? What about
aliases - don't they work?

Answer #4    Answered By: Otis Blackwell     Answered On: Nov 28

I forgot to mention in my first post that we can't actually see the
error the original poster is getting. Non text is removed.

Answer #5    Answered By: Virendar Chaudhari     Answered On: Nov 28

The error I am getting is Cannot drop the procedure 'pSProcStandard', because it
does not exist or
you do not have permission. The proc is there, but it listed as
template.pSProcStandard all the other procs are dbo.Â

I have done everything right, under the correct account. I got it to run under a
SQL 2008 server, just not under the exitisting 2005 server.

Didn't find what you were looking for? Find more on User Profile service, really stuck here Or get search suggestion and latest updates.