Zdroje informací pro profesionály v oboru IT >
Domovská stránka fór
>
SharePoint - Setup, Upgrade, Administration and Operation
>
MOSS 2007 setup with SQL Server 2008
MOSS 2007 setup with SQL Server 2008
- Hi all,
I'm planning for a setup of MOSS 2007 where I plan to use SQL Server 2008.
* Should SQL Server 2008 be installed first and then MOSS 2007?
* Which version of SQL Server 2008 is recommended to use?
This is not a production setup rather a setup for me (I'm an independed Excel consult) to learn more about SharePoint, especially Excel services.
Thanks in advance.
Kind regards, Dennis (http://xldennis.wordpress.com/)
Odpovědi
- This sounds like an ideal scenario for a virtualised farm, especially as its for learning purposes. Get everything in place first, Domain Controller and the relevent accounts setup, then install SQL Server 2008 (Developer wil do) and then MOSS. Its a pain trying to run seperate SQL and seperate MOSS without an AD, so if you don't have the skills to do all this go for the stand alone version of MOSS enterprise which will give you all you need for learning about excel services.If you want to go for the whole farm, its a fun install - especially if you chose windows 2008. Andreas Glaser has a superb blog tutorial about the end to end install.RegardsJohn Timney (MVP)
- Označen jako odpověďDennis Wallentin 8. prosince 2008 11:55
- Typically if you are planning to use a stand-alone version of SQL Server (be it 2K 2005 or 2008) rather than the included (embedded) version of SQL Server 2005 Express with its 4GB limit, it's best to install SQL Server first so that you can specify it during the MOSS installation. This applies whether it is located on the same server or a separate server.
Make sure that you use the Advance Installation and full/complete. (Just in case you didn't know that)- Označen jako odpověďDennis Wallentin 7. prosince 2008 22:22
- Hi Dennis,
It is easier to have SQL installed before you install MOSS. Once the installation process is completed it will launch the Configuration Wizard and at that stage you need the database server.
You could install MOSS, elect not to have it run the wizard, and then install SQL but that's just a needless complication.
I'm not sure which version of SQL Server 2008 would be most appropriate, but MOSS will work with all flavours of SQL 2008 as far as I'm aware. If you have an Enterprise edition license available, go for that to start with as it will give you the best SQL Server features as well if you're investigating and exploring what you can get from it. Leastways, that's what I'd do.
One thing to be sure of - select to customize the SharePoint installation. You do not want the basic installation as that installs a default database server which is rather limited.
Regards,
Pascal- Označen jako odpověďDennis Wallentin 7. prosince 2008 22:22
Všechny reakce
- Typically if you are planning to use a stand-alone version of SQL Server (be it 2K 2005 or 2008) rather than the included (embedded) version of SQL Server 2005 Express with its 4GB limit, it's best to install SQL Server first so that you can specify it during the MOSS installation. This applies whether it is located on the same server or a separate server.
Make sure that you use the Advance Installation and full/complete. (Just in case you didn't know that)- Označen jako odpověďDennis Wallentin 7. prosince 2008 22:22
- Hi Dennis,
It is easier to have SQL installed before you install MOSS. Once the installation process is completed it will launch the Configuration Wizard and at that stage you need the database server.
You could install MOSS, elect not to have it run the wizard, and then install SQL but that's just a needless complication.
I'm not sure which version of SQL Server 2008 would be most appropriate, but MOSS will work with all flavours of SQL 2008 as far as I'm aware. If you have an Enterprise edition license available, go for that to start with as it will give you the best SQL Server features as well if you're investigating and exploring what you can get from it. Leastways, that's what I'd do.
One thing to be sure of - select to customize the SharePoint installation. You do not want the basic installation as that installs a default database server which is rather limited.
Regards,
Pascal- Označen jako odpověďDennis Wallentin 7. prosince 2008 22:22
- Hi Mike and Pascal,
Thanks guys for your prompt replies which is highly appreciated.
I'm still on the planning stage and I'm still waiting on my first SharePoint book. I will probably go with the standard version of SQL Server. Thanks also for the info about SharePoint's installation.
Kind regards, Dennis (http://xldennis.wordpress.com/) - This sounds like an ideal scenario for a virtualised farm, especially as its for learning purposes. Get everything in place first, Domain Controller and the relevent accounts setup, then install SQL Server 2008 (Developer wil do) and then MOSS. Its a pain trying to run seperate SQL and seperate MOSS without an AD, so if you don't have the skills to do all this go for the stand alone version of MOSS enterprise which will give you all you need for learning about excel services.If you want to go for the whole farm, its a fun install - especially if you chose windows 2008. Andreas Glaser has a superb blog tutorial about the end to end install.RegardsJohn Timney (MVP)
- Označen jako odpověďDennis Wallentin 8. prosince 2008 11:55
- John,
Thanks for Your input. Yes, in my case it's all about learning purposes (and in the long run make sure that my business is still competitive).
My basic configuration is a standalone server with Windows Server 2008 standard version where I have (managed to) installed DHCP, DNS and AD with a domain control. I have also created domain users account. The next step is to install and setup the SQL Server 2008.
I have at this stage only a basic understanding of what a farm but the blog by Andreas Glaser looks very promising so, once again, thanks for info about it.
Kind regards, Dennis (http://xldennis.wordpress.com/)
