Products: IMail Server Premium, Collaboration WorkgroupShare, IMail Server

Installing SQL Server 2012 or newer for use with IMail Server

« Go Back

Information

 
Description
How to Install and configure MS SQL Server (full or express) for use with IMail server v12.xx
Solution
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
New
 
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.
DL updates
 
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.
Feature Selection
 
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.
Instance Configuration
 
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.
server configuration
 
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 do this step, THE ONLY  user that installed SQL Server will be able to install IMail or do any upgrades!

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.
security
 
11.) You can decide if you want to send Microsoft installation statistics or not, then let the installer install.
progress
 
12.) When it completes, close the installer.
complete
 
13.) Now open the SSMS, connect to the server, expand Security, and expand Logins, then right mouse click to add a login
newLogin
 
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.
network service
 
15.) Then click OK again to close the new login dialog.
complete
 
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.
 

 
Version12.0; 12.1; 12.2; 12.3; 12.4; 12.5
Attachment 

 
Customer Service Softwaresalesforce.comHome | Product