December 15, 2007 at 8:32 am
here's a thread on the MS forums that ought to help...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=949426&SiteID=1
Edit: I see adam already posted this... Anyway - you should probably look at the middle where they tabl about what steps need to happen so that you can uninstall/reinstall all of these things to have what you need. First and foremost it sounds like the advanced install for WSS is required.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
December 15, 2007 at 9:00 am
I was able to connect to the default database with the named pipe. I still want to know if I should be running Sharepoint with the Embedded Edition, or if I should get it running on SQL Server 2005? Does Sharepoint NEED the Embedded Edition? Will I be able to install other applications that need SQL Server 2005?
SQL Server service is not running. If I install SQL Server 2005 again, will that service be installed, and if so, will it run parallel to the Embedded Edition?
December 15, 2007 at 9:29 am
Sharepoint does not require embeded version. If you want to install sharepoint on standard version of sql 2005, you have to backup the sharepoint database, uninstall everything, reinstall SQL 2005, restore sharepoint backup, install sharepoint and use an existing database.
In my mind, Microsoft's reasoning for minimizing connectivity to an embeded version is to protect it. Minimal connectivity ensures that configurations are correct. If you have the ability to modify configurations, you have the ability to make sharepoint non-functional.
December 15, 2007 at 9:57 am
The reason all this came about is because I need to move the Sharepoint database to a different partition on the same server. It's my understanding that I need to backup the database as part of that process.
I think I would rather run Sharepoint on the normal SQL Server service than the Embedded Edition because I'll be installing several other apps that will need SQL Server 2005.
So if I understand your last post, I need to do the following:
1) Backup the Sharepoint database. When I'm connected through the pipe name there are several databases that are related to sharepoint. Do I need to back them up individually, or is there a way to back up the whole thing at once?
2) Uninstall both Sharepoint and SQL Server 2005. (Correct?)
3) Reinstall SQL Server 2005
4) Restore the Sharepoint database
5) Reinstall Sharepoint and point it to the restored database
Do I have that right? Is there some sort of MS knowledge base article that addresses this?
December 15, 2007 at 11:30 am
Yes, you have everything correct. I would backup everything in the sharepoint instance, just to be safe. You can at this point restore everything back to the way it is now, if need be.
I found this article but I do not know what version of sharepoint you are using.
http://support.microsoft.com/kb/917446
If it were me, and the sharepoint instance is working correctly, I would install a new instance of SQL 2005 and have the apps point to it. This way you could leave the sharepoint instance alone and still connect to the other instance via SSMS.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply