Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

No

Posted on 2011-09-22
8
Medium Priority
?
245 Views
Last Modified: 2012-05-12
I cant seem to get the option to Change my SQL Report server to Sharepoint Integration Mode

The option is not there
ScreenHunter-04-Sep.-22-13.25.jpg
0
Comment
Question by:gotti777
  • 3
  • 3
  • 2
8 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36582220
What edition of SQL Server is this? http://technet.microsoft.com/en-us/library/ms143761(SQL.90).aspx
You may not have the option in SQL Express Edition IIRC.
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 36582604
From the image, i am considering it as Express Edition. Is that right? option is not available in the express edition of SQL server
0
 

Author Comment

by:gotti777
ID: 36582747
Yes it Is the Express addtion,

So I have a few questions.  

1. I also have standered version of SQL Installed, But I think Sharepoint Attached it self to The Express versions of SQL
 1
Thats why I was trying to Run the reporting service with express. Do I need to switch the Sql database on this sharepoint to the standerd

I Do have the Standerd Version of SQl already installed on this machine can i use that to Run Report services?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 16

Expert Comment

by:vdr1620
ID: 36582771
Yes, you will need to switch over to standard version..to use the features you mentioned
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36583062
Yes, I agree. And Ha. I could not make out the image on my other device, but I see it clearly now it is SQLEXPRESS as instance name. Looks like you have what you need to get it working now. Good luck! ;)
0
 

Author Comment

by:gotti777
ID: 36583171
MAn This is going to be some work..   Not good thanks for the input
0
 

Author Comment

by:gotti777
ID: 36583227
I use Vmware.. I think my best bet to create a new server install Full version of sql then Sharepoint again. then try and move everthing over so theres no down time... Here goes 2 weeks of my life  
0
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 2000 total points
ID: 36583290
Good luck! By the way, http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/. Additionally, if you need to keep the current version up, you can restore a copy of the current database to the SQL Standard Edition or use http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_7251-Database-Copying-Wizardry.html. Once you are ready to cut over in either scenario, the first link has steps for getting Sharepoint to point to the new database.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question