[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

No

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
gotti777
Asked:
gotti777
  • 3
  • 3
  • 2
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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
 
vdr1620Commented:
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
 
gotti777Author Commented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
vdr1620Commented:
Yes, you will need to switch over to standard version..to use the features you mentioned
0
 
Kevin CrossChief Technology OfficerCommented:
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
 
gotti777Author Commented:
MAn This is going to be some work..   Not good thanks for the input
0
 
gotti777Author Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now