Hosting Sharepoint and SQL Server off same server

Is it possible to host Sharepoint and SQL Server off the same server for small time testing. Environment would be set up fo开发者_StackOverflow社区r purely education purposes. Non-production. Thanks.

Yes. We do this also. Works like a charm.

Your best bet would be to use a simple virtual environment (I quiet like VirtualBox) and then run a server operating system on there, install SQL Server (if it is only for testing SQL Server express would be sufficient) and then install SharePoint. When you have installed SharePoint you will be better removing the default web application it adds for you and then adding your own as you will be able to link the new application's database easily to the instance of SQL on your SQL server.

Don't forget that if you are looking at using SharePoint 2010 it all has to be 64bit...

Minimum development environment for sharepoint 2007 webparts

Hope this helps anyway...

It is possible, but SQL server likes to use up all the RAM, making sharepoint really slow, and sometimes with sharepoint 2010 it crashes the web application.

Try to limit how much RAM sql server takes

http://blog.stevehorn.cc/2007/10/limit-memory-usage-in-sql-server-2005.html