Small organization Database Architecture (Network Steve Forum)

Small organization Database Architecture

We are standing up a Lync server for about 250 users and want to install it all on a single server. A lot of the documentation seems to suggest you need two or maybe three SQL server instances in order to stand up the Lync environment. Is it possible to have a single SQL Server instance for all of the Databases associated with Lync?

I have seen other products that have architecture drawings. The only one I can find for Lync relates to Edge. We are not even implementing Edge since all of our messaging will be internal. Are there any architecture drawings for the base components of Lync?

October 8th, 2013 5:45pm

what exactly do you want to give the users.

IM/presence

Enterprise voice

Archiving

Monitoring (if you are planning more then IM/Presence, this is a usefull option)

It leave monitoring and Archiving aside and going for the Lync standard edition it can be done with 1 server. Just 1 Frontend Server Standard edition (sql express installed by default)

Free Windows Admin Tool Kit Click here and download it now

October 8th, 2013 5:55pm

Agree with Joost

1 Lync Standard Server will be enough.

For 250 user, you could go with 8 GB of RAM, instead of the 32GB recommended by MS.

Lync Standard will automatically install the local SQL express for you.

http://technet.microsoft.com/en-us/library/gg398167.aspx

Good luck

October 8th, 2013 6:34pm

IM/Presence and Archiving are all we need. We only expect about 250MB of archives per year based on another network we have.

Free Windows Admin Tool Kit Click here and download it now

October 8th, 2013 8:59pm

Because of the need of Archiving you are going to need an separate Server for the Archiving role and SQL Database or instance, is there an SQL server already in the environment. it can be collocated on the archiving server.

Is there a specific reason why you are going to choose for Lync 2010 or is lync 2013 also in the picture.

I'm asking because you can install the Archiving and monitoring role collocated on the front end server.

Also have a look at the Lync 2010 planning tool, can be helpful to see it in picture. http://www.microsoft.com/en-us/download/details.aspx?id=19711

Marked as answer by Oldguard Tuesday, October 08, 2013 6:54 PM

October 8th, 2013 9:07pm

Is there a specific reason why you are going to choose for Lync 2010 or is lync 2013 also in the picture.

I'm asking because you can install the Archiving and monitoring role collocated on the front end server.

Also have a look at the Lync 2010 planning tool, can be helpful to see it in picture. http://www.microsoft.com/en-us/download/details.aspx?id=19711

Marked as answer by Oldguard Tuesday, October 08, 2013 6:54 PM

Free Windows Admin Tool Kit Click here and download it now

October 8th, 2013 9:07pm

Is there a specific reason why you are going to choose for Lync 2010 or is lync 2013 also in the picture.

I'm asking because you can install the Archiving and monitoring role collocated on the front end server.

Also have a look at the Lync 2010 planning tool, can be helpful to see it in picture. http://www.microsoft.com/en-us/download/details.aspx?id=19711

Marked as answer by Oldguard Tuesday, October 08, 2013 6:54 PM

October 8th, 2013 9:07pm

The current configuration on one of our networks is all three on the same server. We have three instances of SQL on the one box... Probably not recommended, but that is the way it is... Debating installing 2010 on the second network so we can use the first one as a template if we have issues. If I do 2013 on one network, I am committed to upgrading the other as well.

Free Windows Admin Tool Kit Click here and download it now

October 8th, 2013 9:55pm

Just wanted to follow up with what I ended up doing. I found an article that shows how to load the SQL servers manually. Link is here:

Blog About installing SQL for Lync

We were loading standard, so we needed three SQL servers instead of two. The following three lines installed all three instances of SQL into a directory on the S: drive:

SQLEXPR_x64_ENU.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE /ACTION=Install
/FEATURES=SQLEngine,Tools /INSTANCENAME=RTCLOCAL /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\NetworkService"
/SQLSYSADMINACCOUNTS="Builtin\Administrators" /BROWSERSVCSTARTUPTYPE="Automatic"
/AGTSVCACCOUNT="NT AUTHORITY\NetworkService" /SQLSVCSTARTUPTYPE="Automatic" /INSTANCEDIR=S:\LyncDB

REM #################

SQLEXPR_x64_ENU.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE /ACTION=Install
/FEATURES=SQLEngine,Tools /INSTANCENAME=RTC /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\NetworkService"
/SQLSYSADMINACCOUNTS="Builtin\Administrators" /BROWSERSVCSTARTUPTYPE="Automatic"
/AGTSVCACCOUNT="NT AUTHORITY\NetworkService" /SQLSVCSTARTUPTYPE="Automatic" /INSTANCEDIR=S:\LyncDB

REM #################

SQLEXPR_x64_ENU.EXE /QUIET /IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE /ACTION=Install
/FEATURES=SQLEngine,Tools /INSTANCENAME=LYNCLOCAL /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\NetworkService"
/SQLSYSADMINACCOUNTS="Builtin\Administrators" /BROWSERSVCSTARTUPTYPE="Automatic"
/AGTSVCACCOUNT="NT AUTHORITY\NetworkService" /SQLSVCSTARTUPTYPE="Automatic" /INSTANCEDIR=S:\LyncDB

I have not figured out how Archiving gets configured yet, so that is yet to come. The above SQL configuration worked great for Lync 2013 Standard on a single server. Currently up an running with this configuration.

Edited by Oldguard 20 hours 24 minutes ago

November 13th, 2013 10:40am

Just wanted to follow up with what I ended up doing. I found an article that shows how to load the SQL servers manually. Link is here:

Blog About installing SQL for Lync

We were loading standard, so we needed three SQL servers instead of two. The following three lines installed all three instances of SQL into a directory on the S: drive:

REM #################

Edited by Oldguard Wednesday, November 13, 2013 3:34 PM

Free Windows Admin Tool Kit Click here and download it now

November 13th, 2013 6:34pm

Just wanted to follow up with what I ended up doing. I found an article that shows how to load the SQL servers manually. Link is here:

Blog About installing SQL for Lync

We were loading standard, so we needed three SQL servers instead of two. The following three lines installed all three instances of SQL into a directory on the S: drive:

REM #################

Edited by Oldguard Wednesday, November 13, 2013 3:34 PM

November 13th, 2013 6:34pm

This topic is archived. No further replies will be accepted.