Go to Microsoft.com and download MS SQL Server Express with tools
, unless you are licensed by Microsoft for the full SQL server. It is very important that you download the version with tools
because this includes the SQL Server Management Studio (SSMS) which will make managing the SQL server much easier and not require a separate download and install. Current, as of the writing of this kb, Microsoft naming for the installer will be something like SQLEXPRWT which breaks down to SQL Express With Tools. You may download the x86 or x64 version, this choice is up to you but the x64 version runs better on a x64 OS.
1.) Make sure you are logged into the server as the root local admin account.
2.) Double click the installer.
3.) Click the "New SQL Server stand-alone..." link
4.) Accept the licensing agreement with Microsoft.
5.) If after accepting the license agreement, it says that there are product updates to SQL server, check the "Include SQL Server product updates" and then next.
6.) Downloading the updates may take a while, so just let it download them.
7.) In the feature selection section, all that IMail requires are the Database Engine Services and the Management Tools. Anything else is entirely up to you.
8.) You can use the default instance name and install location or change it to what you want, just remember what you name it and where it is installed.
9.) The server configuration: The SQL Server Database Engine is fine with the default, so leave it as it is. You do want to change the SQL Server Browser from Disabled to Automatic so it will run as well.
10.) The Database Engine Configuration is very important. In the Specify SQL Server Administrators window, if you do not see the account you are logged in with, click the "Add Current User" button to add the user. Also click the add button to add the "Administrators Group" as admins.
If you fail to perform this step, you will only be able to install/modify IMail installations with the user that installed SQL Server.
This way, if you login with a user that is a member of the administrators group, that use will have SA rights to SQL Server.
11.) You can decide if you want to send Microsoft installation statistics or not, then let the installer install.
12.) When it completes, close the installer.
13.) Now open the SSMS, connect to the server, expand Security, and expand Logins, then right mouse click to add a login
14.) Next to Login Name text box, click search, and in the search box type "Network Service". Click "Check Names", then ok after it finds it.
15.) Then click OK again to close the new login dialog.
16.) The next step is to go into User Mapping select the WorkgroupShare database and give the Network Service Data Reader, Writer & Owner permissions.
17.) You may close the SSMS if you like, and you may now install IMail and select "Use Existing SQL Server" when the IMail installer asks where to place the Collaboration database. Make sure you use the Instance Name for the SQL Server you just installed in step 8. The instance name can also be found in the SSMS when you first connect to the SQL Server, or once logged in, at the top of the folder tree on the left.