SBS 2011 Adding a second server.

So a customer wants new server, On the current server they run SQL 2003 Workgroup edition on the SBS 2003 server.

Now the company who support and provide the sql package say they would recommend 2 servers one for sql one for the rest of the stuff.

From research I’ve found that SBS 2011 PAO also comes with an additional 2008 licence.

Questions are once I’ve installed the second server OS how do i go about connecting it to the main server?

Does the second server have to be a DC?

Can i use a different version other then SQL 2008 Small business that come with SBS 2011 PAO?
Lewis1991Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sushil SonawaneCommented:
Questions are once I’ve installed the second server OS how do i go about connecting it to the main server?

Yes u can connect the main server using SQL server management windows.

http://technet.microsoft.com/en-us/library/ms190622.aspx
http://technet.microsoft.com/en-us/library/ms345332.aspx
http://technet.microsoft.com/en-us/library/ms345318.aspx


Does the second server have to be a DC?

It not require second server to be DC. Two SBS server as domain controller not work on same environment. You can add second server as member server.



Can i use a different version other then SQL 2008 Small business that come with SBS 2011 PAO?

You can use as per your requirement there is no issue.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Lewis1991Author Commented:
I've requested that this question be deleted for the following reason:

old
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.