Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I've got 3 servers: - DB1 - SharePoint1 - SharePoint2

On SharePoint1 I've installed WSS, using DB1 as database. Now I want to install WSS onto SharePoint2 and use DB1 as database storage as well.

My question is: Does it conflict to have the databases from two SharePoint installations located on the same instance of the same SQL server?

The two SharePoint installations have nothing in common except they use the same SQL server (both not the same databases, of course). I can't create a new instance on the SQL server...

share|improve this question
add comment

3 Answers

up vote 2 down vote accepted

you can share the same database server in your scenario.

Are you buildning a new farm?

Make sure to rename your configuration database, during the installation, from the default one, so it differs from the one already there.

/WW

share|improve this answer
    
Yes, I'm building a new farm. Completely independant from the first SharePoint farm. So, my new installation won't overwrite any of the databases of the already existing installation? –  AndersBS Oct 21 '09 at 19:48
    
The SharePoint installer will prohibit you from overwriting the config db, since it contains info. It only allows using pre-created db's if they are empty. –  Wictor Wilen MCA MCM MVP Oct 21 '09 at 20:46
    
That's great. Thanks for your help. –  AndersBS Oct 22 '09 at 6:20
add comment

Make sure that you are have different names for Sharepoint_Config database. It shouldnt get conflicted.

share|improve this answer
add comment

Concur with everything above, but do remember that SharePoint is all about SQL Server for performance, watch all SharePoint Databases closely. As a general rule for any high band (say > 100 users Simultaneously on) SharePoint site, I typically dedicate the SQL Server to SharePoint.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.