Do You Have Questions About SharePoint and the SQL Server?

Well here are some answers for you. Database services and Internet server on same box can be accomplished with a dedicated SQL server for SharePoint relying on your deployment scenario. This can be done at a relatively cheap cost. Further, if you're trying to change the drive letter that Sharepoint creates with a new database on in SQL server, then the SQL server 2005 default location for kind new databases is where you need to focus. At this point, you can create alternative database instances in SQL Server that homes the SharePoint databases. You can even create Remote SQL Server Deployment (Windows SharePoint Services 2.0) if you intend to host several Internet sites using Microsoft Windows SharePoint Services. Again, at this point it is recommended that you employ Microsoft SQL Server on a separate box. Using SQL Server on its own server conjointly permits your Windows SharePoint Services server to devote its processor, memory, and disk materials to providing pages and files. For a lot of information regarding SQL Server and Windows SharePoint Services, see Windows SharePoint Services 2.0 Architecture.