Could not find stored procedure 'sp_dboption' in SQL Server 2012 while configuring Sharepoint 2010?

Question

Hello all,
I couldn't find the store procedure sp_dboption within SQL Server 2012 .

while configuring the Reporting Services SharePoint Mode as a Single Server Farm 
http://msdn.microsoft.com/en-us/library/gg492276.aspx#bkmk_install_SSRS_sharedservice

I got the error  as Could not find stored procedure'sp_dboption' in SQL Server 2012.?
Does this issue will be solve if we install the SharePoint 2010 SP1 update or it is common issue.
Hope to hear from the one who knows better .

Thanks,
Anil Maharjan

Answer 1

This is solved by SP1, as SP1 for SharePoint 2010 adds SQL 2012 support.

http://support.microsoft.com/kb/2460045
http://technet.microsoft.com/en-us/library/hh231680.aspx

---

Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

Answer 2

Hello Marek,

Does this SP1 needs to be install for Standalone mode too .I have install SharePoint 2010 Standalone mode and while Configuring Report Server Integration in SharePoint Central Administration .I got the error as above.
Also ,while installing SharePoint 2010 SP1 the installation terminate in the middle ,I have tried 2 but it couldn't succeed the installation.
Is there any thing i am missing.

Thanks,
Anil Maharjan

Answer 3

Well the SP1 installation is required in any case. You have to follow some sequence of steps when installing the SharePoint SP1 - first install SP1 for Foundation 2010, then SP 1 for any foundation language packs if any used, then the same for Server 2010.

---

Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

Answer 4

Hello Marek,

Thanks for your response, well I have successfully installed SP1 but while configuring I got the issue as 

Error 

Login failed for user 'WORKGROUP\ServerName$'.

Troubleshoot issues with Microsoft SharePoint Foundation.

I am using user as admin which is local administrator so is that a problem or do we need to be a domain user? .I have just installed SQL server 2012 and SharePoint 2010 in Standalone mode within single windows 7 OS . So, how can we simply configuring the Reporting Services integrate SharePoint 2010 having standalone mode installed in windows7.

Hope to hear again.

Thanks,

Anil Maharjan

Answer 5

SQL and SharePoint are both running on the same server? If not, you shall use domain accounts and those machines should be domain members.

---

Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

Answer 6

I have the same issue. We installed SQL 2012 and SP2010 SP1. But When trying to run the Report Server Configuration, couldn't change the Report Server Database mode from Native.. I don't see the option.

SQL and SP are running on the same server.

Also when trying to connect to the SSRS Integration from Central Admin, couldn't  connect to the Valid Source .. Error

Are we missing something here. Please help. 

---

Vijay Ramisetti

Answer 7

So what can we do for other software that have the same issue?

They've broken MonoX portal (which is closed source but free to use product) and possibly lots of other s/w with that change.

Can one create the missing stored procedure by hand? What code should they put in there?                                       

---

Microsoft MVP J# 2004-2010, Borland Spirit of Delphi 2001

Answer 8

In SQL Server 2012 try:

ALTER DATABASE database_name
SET MULTI_USER;
GO

Answer 9

After some research , I have found the option that : Books online says the recommended alternative is to use the ALTER DATABASE command.

The link below shows some helpful option and Replacement for system stored procedure sp_dboption in SQL Server 2012.

http://beyondrelational.com/modules/2/blogs/28/Posts/15429/replacement-for-system-stored-procedure-spdboption-in-sql-server-2012-denali.aspx?utm_source=brdigest&utm_medium=email&utm_campaign=dailydigest

Thanks,

Anil Maharjan

Answer 10

Hi George,

do you have found any solution so far you can share?

unfortunately copy of the missing sp from SQL2008R and creation in sql2012 (master) database does not work. When you try to create you get this error:
The specified schema name "sys" either does not exist or you do not have permission to use it.

I also feel that this missing sp will break/block migration to sql2012 for MANY existing applications!

Even the actual 2013 preview of MIcrosoft ACM Server seems to have problems while trying to create a database in a sql2012 instance *lol*