Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

No

Posted on 2011-09-22
8
Medium Priority
?
239 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

730 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