Our Step-by-Step Guide to Install Microsoft SQL Server 2005 Express Edition as a Host Database Server for Bopup Communication Server that is available on our websites has been updated. This guide helps to install and setup MS SQL Server 2005 Express Edition on a computer in order to use it as a database server. Since MSDE 2000 software (shipped with the setup package of Bopup Communication Server) is not supported by latest versions of Windows then you cannot install and use it on Windows 2008/Vista/7 operational systems and higher. In order to run Bopup Communication Server on these systems you should install MS SQL Server 2005 Express Edition first.
This guide has been appended with information about SQL Server Browser service. This service, part of the SQL Server 2005, should be started if you plan to connect and manage the IM server remotely. It is also required if the communication server is installed on another computer, i.e. if both the SQL Server and Bopup Communication Server are running on different workstations.
Below is the information that has been added to the guide.
You need to configure a little SQL Server 2005 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 2005" menu. Then open the "SQL Server 2005 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 2005 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.
Our guide on installing the SQL Server 2005 Express Edition is also valid and can be used for Microsoft SQL Server 2008. You can access the step-by-step guide at www.bopup.com/products/install_sql_server_2005_as_database_server.html