Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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