Installing Prerequisite
Please note that you must have administrative rights on the computer to
install the SQL Server. Before downloading and installing the SQL Server
make sure and verify that the following software is installed on your
computer:
- Windows Installer 3.1
- Microsoft .NET Framework 2.0
Download Windows Installer 3.1 using the following download page:
http://www.microsoft.com/downloads/details.aspx?FamilyID=889482fc-5f56-4a38-b838-de776fd4138c and install it using provided instruction there. Reboot your computer if needed after installation.
Windows Installer 3.1 is already included in Windows 2003 SP1 and higher
so there are no needs to download and install it on the latest versions
of Microsoft Windows.
There are 2 versions of Microsoft .NET Framework 2.0 available, for
32-bit and 64-bit platform. Please use the links below for your system:
Install the framework using instructions provided on the download page.
Microsoft SQL Server 2005 Express SP4
Microsoft SQL Server 2008 Express SP3
Microsoft SQL Server 2012 Express
Run the installation package and it will install the modules and packages that are required by the SQL Server setup.
 |
|
| Installing software components required by Microsoft SQL Server 2005/2008/2012 Express Edition |
Then the SQL Server setup will start.
 |
|
| Welcome page of the setup wizard of Microsoft SQL Server 2005/2008/2012 Express Edition |
The wizard checks your system configuration and verifies installed and required components.
On the
Registration Information you can uncheck the "Hide advanced configuration options" check box in order to specify an instance name of the SQL server.
 |
|
| Configure to show advanced options for the SQL server |
Otherwise the SQL server will be installed with "
SQLExpress" named instance and you must remember that and use this instance name in the Setup Wizard of Bopup Communication Server.
Click Next to forward the setup to the next page with a selection of features that will be installed.
 |
|
| Select features of the SQL server to install |
If you would like to use the SQL Server to host only Bopup Communication
Server database with no any other purposes you should deselect all the
features in the tree except the "Data Files" and "Shared Tools"
subfeatures under the "Database Services" feature.
Click Next button to proceed to the selection of Authentication Mode
that will be enabled on the SQL server. The Authenticatiom Mode tells
the SQL server how to accepts connections and which credentials to use
in order to authorize those connections, and you can select the "Windows
Authentication Mode" or the "Mixed Mode".
The "Windows Authentication Mode" tells the SQL server to use current
Windows user's credentials under which the connection is made. This is
most secure and simple method to handle connections and authorize users
on a Windows Domain architecture within Active Directory (LDAP) catalog.
Otherwise you can choose the "Mixed Mode" to allow the server to
authorize users using both Windows Authentication scheme and SQL Server
Authentication which enables for the SQL server to have it's own user
accounts.
 |
|
| Choose the Authentication Mode for Microsoft SQL Server 2005/2008/2012 |
Please note that you should remember which authentication mode you
select because you will be asked by the Setup Wizard of Bopup
Communication Server (when you will be installing it) on which
authentication is used on your database server.
Click Next to skip next few dialogs of the wizard with its default settings and to go to the
Ready to Install page. Click Install button to start installation process of the SQL Server.
 |
|
| Selected features and configuration of the SQL server are being installed |
You need to configure a little the SQL Server after it's installation
will complete. You should enable TCP/IP protocol for it, start the SQL
Server Browser service and add the SQL service to Windows Firewall
exceptions list.
Start the SQL Server Configuration Manager from the "
Start -> Programs -> Microsoft SQL Server"
menu. Then open the "SQL Server Network Configuration" and select the
"Protocols" in the left tree. You must enable TCP/IP protocol and then
start the SQL Server Browser service to allow connections from Bopup
Communication Server to the SQL server and also to support remote
connections to the database if you will install the Management Console
of the communication server to administrate the IM server remotely.
Select and right-click on the TCP/IP protocol in the list and select "
Enable" item from the popup menu.
To start the SQL Server Browser service click the "SQL Server Services"
in the left tree and double-click on SQL Server Browser, the Properties
window will show up. Move to Service tab and change Start Mode to
Automatic. Therefore, the service will be start automatically when the
computer starts. Click OK to apply changes. Back to SQL Server
Configuration Manager, right-click on SQL Server Browser on the right
window and select "
Start" to start the service.
Then restart the Microsoft SQL Server service from the console or reboot computer to apply changes.
 |
|
| Enable TCP/IP protocol on the SQL server |
If you have Windows Firewall running on your server computer you should
add the Microsoft SQL Server service to firewall's exceptions list to
allow to accept remote connections. Go to Windows Firewall settings by
opening "
Control Panel" and clicking on "Windows Firewall" shortcut there. In the opening dialog box switch to
Exceptions tab and then click the Add program... button. Navigate to "
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\" folder and select "
sqlservr.exe" file. Click Open and then OK to add the SQL service to the exceptions list.
