MOSS 2007 Server Installation and configuration problem

5 pts.
Tags:
Installation
Products and Technologies wizard
SharePoint
SharePoint 2007
SQL
Need to know how I can get SharePoint to recognize a second partitioned drive on the same server where I've installed SQL server 2005 and want the SharePoint configuration database and everything held. Server (Mars) is set up with local C drive where I've installed Server 2003 OS. Then I have another drive on same server set as D. I installed SQL Server 2005 on this. Now I want to install MOSS 2007 on C and go though the Products and Technologies configuration wizard so that it creates the initial database and Central Admin page. When I do this though there is no way to specify the D drive on Mars as the location to find SQL and build the database within. Instead the full MOSS installation also installs it's own version of SQL with folders on C and then creates the DB here. So I have 2 problems. One that it's using the SQL that comes with MOSS 2007 and not my SQL 2005 I've installed, and Two that I have no way of pointing it and linking it to D drive to store all this database for everything. I have the enterprise version and want the full installation so I can have room for future growth. How can I do this? Choosing Advanced doesn't allow you the option to not install the SQL piece that comes with MOSS and even if it did there is still no way of pointing the config wizard to see D drive. I'd really like to be able to use just the one server in this fasion but no one has been able to solve this for me. Any guidance is appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

This page should help walk you through the process of setting up MOSS to use an already installed SQL Server.

http://www.pptspaces.com/sharepointreporterblog/Lists/Posts/Post.aspx?ID=15

When you install MOSS it creates the databases in what ever the default location for the SQL Server is.

You can check this by opening the SQL Server Management Studio and opening the object explorer, and connecting to the SQL Server. Right click on the server name and select properties. On the “Database Settings” page you will see two boxes with paths in them. This is the folder that it will create the databases in.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following