Showing posts with label sql server. Show all posts
Showing posts with label sql server. Show all posts

Monday, January 16, 2017

Guide on installing Microsoft SQL Server 2012 Express

We have updated our instruction called Step-by-Step Guide to install SQL Server 2005/2008/2012 Express as a database server for IM server and now it contains details information on installing and configuring Microsoft SQL Server 2012 Express edition.

Installation Wizard of Microsoft SQL Server 2012 Express
The previus edition of the document contained step-by-step guide on installing Microsoft SQL Server 2005 but that software is too old and does not support by recent versions of Windows starting from Windows 8.

Friday, September 16, 2016

Tips & Tricks: How to fix issue if Bopup Communication Server is not started

From time to time we are reported by our customers and users that the IM service of Bopup Communication Server stopped to working. It is shown as Stopped in Management Console and cannot be started no more. At the same time the console launches normally and shows no errors on startup. Commonly a reason of this issue is simple and can be fixed quickly. See the possible resolutions below.

Trial peroid or software license has been expired

The most common reason is that 45-day trial of evaluation period of the communication server expired. If the IM server is registered version check information about the license from Help->About dialog box. It shows details on the license including the number of supported IM clients and also an expiration date. In case of expired trial the 45-day trial expired caption will be shown. Same information is shown on the right top corner of Welcome page in Management Console.

Check that the IM service is still registered in Windows services

Another problem that could suddenly occur is missing of core service of Bopup Communication Server from Services list in Windows system. Open services panel in Windows from Control Panel->Administrative tools->Services. It is also possible to open that panel directly from the console by clicking "Open Services lists" link on Welcome screen. Check that Bopup Communication Server service is shown in the list and having Automatic startup type.

If there is no such service in the list that means that it cannot be started and the server will not be operated correctly including accept connections from instant messengers. It must be registed in Windows system by the following way:

1. Open Windows Explorer and navigate to installation folder of the IM server. By default the communication server is installed to "\Program Files\Bopup Communication Server". On 64-bit versions of Windows default directory is "\Program Files (x86)\Bopup Communication Server".
2. Click Start button on Task bar in Windows and then type "run" in search box. Thex select Run to show a launch dialog box.
3. Select "bcssrvc.exe" file in previously opened Windows Explorer window and drag-n-drop it to Run dialog. A full path to the file will be shown in command line.
4. Type /unregserver parameter in the end of the path to the service module so a full command line has been changed to

"[PATH]\bcssrvc.exe" /unregserver

This will unregister the service from the system.

5. Type /service parameter in the end of the path to the service module so a full command line has been changed to

"[PATH]\bcssrvc.exe" /service

5. Click OK to launch the command. Then refresh Services list and try to start the service.

Find out what happens with the service when it brings errors

If the communication service is not started due to some troubles with SQL database server, for example, then it is possible to discover that. Open Event Log viewer in Windows from Control Panel->Administrative tools->Event viewer or click "Open Event viewer" link in Management Console to open same window. Then click Windows logs on the left to expand it and select Applications. Scroll-down to find last messages from top sent by Bopup Communication Server service.

Normally only Start and Stop events must be present, it is events #100 and #101 respectively. If there are any other warnings or errors then copy event description and send that report to Support Team or via Live Chat function on bopup.com website or directly from the console.

Wednesday, August 24, 2016

Known issue: An attempt to create a backup file gives SQL error #5

Many our users faced with an error on creation of a backup file from SQL database maintenance... dialog in Management Console. Once destination folder has been selected the console brings "Cannot open backup device. Operating System error 5" and no backup file is created.

This is a known issue of the IM server application but it does not relate to any error. Since backup files are created by Microsoft SQL Server directly then an account under which database service is running may not have appropriate write permission to chosen folder. Usually this error can occur when a target directory that has been chosen to save a backup file is located in current user's profile folder such as "My Documents", "Desktop", etc. In case of the error try to choose another location to create and save backup file.

We also updated and appended with this information our FAQ section available on the website that contains details on how to Create and restore backups of Bopup Communication Server.

Friday, February 13, 2015

Bopup Communication Server version 4.3.10

Today, 13th February we updated our instant messaging server applications and released version 4.3.10. New version of the IM server fixes possible issues with starting up of Management Console on Windows 2008 R2 edition. We also added an option to display time everywhere in the console in 12-hour clock format with AM/PM indicators. This would be a useful update for our US customers. Another addition is about displaying connection string used to connect to the SQL Server, that is now shown in the SQL database maintenance dialog. It's value can be requested by our technical support representer in some cases so it will not be necessary to open registry editor to retrieve that value in the future.

The new server package also includes the latest version of Setup.ini Configuration Tool that now lets set up custom colors for sender's/recipient's titles in conversation and block options in sending message dialog for users such as changing text font and color, inserting emotions and using the 'typing message' sound.

Download Bopup Communication Server version 4.3.10

Friday, June 20, 2014

The IM server improves the install of built-in MS SQL Server 2008

We released new update of the communication server that would be important to our new customers. Version 4.3.6 improves installation of built-in MS SQL Server 2008 R2 Express that is intended for install on latest versions of Windows including 8, 8.1 and 2012. We noticed that some users experienced issues and installation errors of the built-in SQL Server so we took some time to figure out what happened with it and fixed the setup.

Download Bopup Communication Server version 4.3.6

Sunday, April 6, 2014

Bopup Communication Server fixes issues with creation of user accounts from messenger clients

New version 4.3.3 of the communication server has been published. It is a minor update of the software that only fixes issues with creation of user accounts from instant messaging clients.

It is easy to update existing instance of Bopup Communication Server with keeping all settings, data and history. Just download and launch a new setup package of the server on a computer running the IM server. Even the communication server was installed with built-in SQL server it can be upgraded using a smaller installation file that comes with no SQL server.

Download Bopup Communication Server version 4.3.3

Wednesday, January 15, 2014

Download new setup package of the IM server with built-in MS SQL Server 2008 R2 Express

This is a useful information for new and existing clients about installation of Bopup Communication Server on latest Windows 8 and 2012 releases. We made a new setup package of the server software and integrated Microsoft SQL Server 2008 R2 Express edition that can be installed as a built-in database server. We know that our regular setup for the communication server comes with built-in Microsoft SQL Server 2005 Express for both 32- and 64-bit systems. But here is a trouble with it on Windows 8 and 2012 because that SQL version is not supported by latest operational systems from Microsoft. Since Windows 8 is a mainstream today we decided to be closer to users and released a new installation file.

Yes, the new setup package is much bigger, it's size is above 115Mb while the setup file with built-in SQL Server 2005 is only about 62Mb. Since SQL Server 2005 is not supported by Windows 8/2012 then now regular Setup Wizard now detects and shows a warning dialog page if the SQL server has been chosen for installation on a local PC. That page contains description and link to our Downloads Center that offers a download of a bigger package especially built for Windows 8 and 2012.

Sunday, December 15, 2013

Interact with a new version of the IM server smoothly!

We released a new version 4.3.0 of Bopup Communication Server which improved the Welcome page of Management Console and added other improvements.


See overall configuration progress of the IM server with helpful tips

It is a known thing that our IM server offers a huge number of functions and provides a lot of functionality. And new users can be in confusion and frustrated on a first start of the console: too many things must be performed like adding user contacts, enabling right authentication, etc. What to do first? And we understand how to important to support new users, allow them to configure the server with ease and smoothness. Thus now Management Console interacts with a user, it helps to move administrator through all required steps in order to get the communication server ready to accept clients and to enable communication for them.

The most important feature is the tooltips above each part of the server shown on the Welcome page, i.e. User Accounts, Messaging Groups, News Messages, File Distribution, Archiving & Logging and IM Client Updates & Branding. Of course users are the primary key to organize the server so the console shows only a single tooltip above User Accounts section on it's first startup if there is no accounts. This will force to create users first instead of other things and features.

Once at least a single user has been created or imported the console unlocks other general tasks and shows tooltips for them. Once a task completed it is marked with a check sign above it instead of the tooltip. Now no matter what task is performed first, Groups, News, File Distribution — it would be moved to the left and placed near User Accounts task. So general blocks on the Welcome page are now built dynamically!

Another great function is a progress bar that indicates an overall process of tasks completion. It has a green color and moves at bottom of the task blocks from 0% to 100%.


The Setup Wizard prevents installation of built-in SQL Server on Windows 20012/8

We also improved a setup package and now the installation wizard of the communication server recognizes latest Windows 2012 and version 8 if a user selects to install built-in SQL Server within the server. Since the IM server is shipped with MS SQL Server 2005 Express edition it is not supported by those versions of Windows. So the setup would bring an information dialog that explains how to avoid this issue and manually set up SQL Server 2008 or 2012, for example.


Added support for Android clients

Did you hear that we are working on Anroid clients in a past few months? Our first mobile messenger is going to a release soon and version 4.3 of Bopup Communication Server now officially supports it. Currently we are on alpha testing phase of Android software.


Download Bopup Communication Server version 4.3.0

Tuesday, October 8, 2013

"User is typing message..." event is now supported!

We glad to inform our customers that new versions of Bopup IM suite are now available for download. Both the come with major versions because we did a lot of work, added useful improvements and fixed many issues. See what is new below.

User typing event
Firstly we need to say about very useful function. Maybe it is known from public messenger when users can see in their conversations that another one is currently typing a message or reply. Year, this adds interactivity interactivity and improves usability. When we see that the reply is being typed we do not close chat window immediately. And now our software provides that support too!

Download and update both the server and client parts in order to be able to use this function. The "User is typing message..." event appears every time in a conversation dialog of Bopup Messenger client. Delivery of this instant notification event is controlled on Bopup Communication Server and you can disable it from the Options dialog box by switching to Messaging tab.

Displaying a huge amount of messages on the server history
Management Console of the communication server fixes issues with showing a great number of messages and file transfers selected from a Message History. That issue also related to displaying some profile pages for account, group and/or news messages. Now data is displayed quickly and with no error even you select thousands records.

Fixed installation of the IM server with built-in SQL Server
Another important issue was installation of Bopup Communication Server with it's built-in database server on latest versions of Windows. Sometimes the setup fails to complete because no connection to the SQL Server could be established. That was a security problem because Windows requires a stronger password for built-in 'sa' account for Microsoft SQL Server 2005 Express that shipped with the IM server package. We did that.

Forget about duplicate versions of the messenger software in Add/Remove Programs panel 
Our customers that distribute and deploy new updates of the IM client using the communication server faced with the problem that previous version of the software might not be properly removed from Add/Remove Programs if the update was initiated under non-administrator user account in Windows. That was too old problem that we know about. Now the messenger software removes it's previous version during an upgrade with keeping all settings and message history.


Adding File Transfers to a messenger local history
Both Bopup Messenger and Bopup Observer clients fix error with adding and saving received and sent transfers to Message History. Now al file transfers are properly archived for a future review.


Download Bopup Communication Server version 4.2, Bopup Messenger 6.3 and Bopup Observer 5.3

Monday, January 28, 2013

IM Server improves a restore of SQL backups and printing Message History

New version 4.1.4 of Bopup Communication Server has been released on January 27, 2013. It is a not mandatory update but it fixes and improves some useful features of the software.

What's new:

Added new option in the SQL Database Maintenance dialog to restore database backups created on another server

The SQL Database Maintenance dialog of the Management Console adds a new check box that says the console that a SQL database backup (that is intended for restore) was created on another SQL Server and/or another instance of the communication server. It is very important because in that case the backup will be restored with WITH REPLACE option.

Added UAC verification to control status of the IM service

Now the Management Console checks token of administrator account (UAC) under which it is running in Windows Vista and later. If there is no necessary rights to control the IM service from the Welcome page then appropriate message is shown and starting/stopping options for the service are unavailable. In order to control the service the Management Console must be launched with "Run as administrator" option selected from context menu in Windows.

Improved showing and printing Message History containing long messages

New version of Bopup Communication Server fixes issues with displaying and printing long text messages in Message History. We removed scrollbars in the edit boxes that contain the message text and now each conversation is shown and moved to a printing device in whole.

Download Bopup Communication Server version 4.1.4

Wednesday, November 28, 2012

New version 4.1.2 of Bopup Communication Server

We released new update of the communication server software, and it's version 4.1.2 is available for download. This latest release comes with minor improvements and changes and this is not a priority update for the software.

Are you still using "old" versions of the IM software?

If you still use old versions of the communication server and messenger clients then it is a good time today to upgrade to the latest versions. Even you have oldest versions like version 3.3 installed you can easily and quickly migrate to the latest software. We have a document that overviews all the steps you need to follow on upgrade, check it out here http://updates.bopup.com/upgrading_to_version_4.0_instruction.html

Summary:
  1. Install new version of the IM server over existing software
  2. Upload new versions of the messengers (MSI packages) on the server through Management Console in order to update the IM clients
  3. Enjoy with functions available in new versions

Download Bopup Communication Server version 4.1.2

Thursday, May 31, 2012

The Setup Wizard of the communication server fixes issues with installing product on existing MS SQL Server

New update is available for Bopup Communication Server software. Latest version 4.0.13 fixes issues with installing the communication server on existing Microsoft SQL Server software. The main issue was that the Setup Wizard of Bopup Communication Server could not properly recognize an existing instance of the SQL Server running locally or on remote computer. Even a valid address of the SQL Server was entered. We found that this problem primary depended on a new version of InstallShield software which was changed a few versions ago and now is used to build setup packages of our IM software.

Download the latest version 4.0.13 of Bopup Communication Server 

Monday, April 16, 2012

Bopup Communication Server is now shipped with MS SQL Server 2005 Express

We have good news regarding our communication server product. Now it's full setup package comes with built-in Microsoft SQL Server 2005 Express for both 32- and 64-bit Windows systems. The new SQL Server replaced MSDE 2000 software which was included to all previous versions of Bopup Communication Server.

What are benefits of using the new SQL Server software? We agree that size of the new setup package becomes bigger. But the main benefit is that Microsoft SQL Server 2005 Express is supported and can be installed on latest versions of Windows, i.e. Vista, 7 and later. This was the primary issue with the built-in MSDE 2000 software because it is not supported starting from Windows Vista.

Now there are no needs to learn our online guide and to manually install Microsoft SQL Server 2005/2008/2012 Express editions as a host SQL Server for the communication server software. The new setup package solves all these issues and Bopup Communication Server can be easily installed with the built-in SQL Server on all major Windows systems starting from Windows 2000.

Download Bopup Communication Server version 4.0.11

Friday, April 13, 2012

Microsoft SQL Server 2012 is fully supported by Bopup Communication Server

We glad to inform our users and partners that the setup of Bopup Communication Server has been tested on Microsoft SQL Server 2012 Express edition. Since that is the latest version of the SQL Server software from Microsoft then it is important to ensure that the server is fully supported by our IM server. The setup went fine with no issues.

We also updated our Step-by-Step Guide to Install Microsoft SQL Server 2005/2008/2012 Express Edition as a Host Database Server for Bopup Communication Server and added SQL Server 2012 to the list of supported versions. The download links for SQL Server 2005 and 2008 were also changed and now point to Microsoft SQL Server 2005 SP4 and Microsoft SQL Server 2008 SP3 setup packages.

Monday, March 5, 2012

Tips & Tricks: How to reinstall Bopup Communication Server

This post explains issues and describes how to reinstall Bopup Communication Server software on the same computer. Since the communication server uses a SQL server database and can be also installed with built-in MSDE 2000 package (Microsoft SQL Server Desktop Engine) then it is required to do some operations manually after uninstall of the IM server software and before installing it again.

Below is a step-by-step instruction that helps to reinstall Bopup Communication Server on the same machine. Please note that this guide is valid only if the IM server was installed with MSDE 2000 software:

Step-by-step instruction on reinstalling Bopup Communication Server using built-in MSDE 2000: 
  1. Uninstall Bopup Communication Server from "Add/Remove Programs" panel.
  2. Uninstall Microsoft SQL Server Desktop Engine from "Add/Remove Programs" panel.
  3. Go to "Program Files" directory and remove "Microsoft SQL Server" subfolder from there.
  4. Reboot the computer if needed or to ensure that no any existing data will remain.
  5. Start the setup package of Bopup Communication Server.
There some differences if the communication server uses existing Microsoft SQL Server that is running on the same computer or externally. In that case both "BCS40" database and "bcsadmin" user login must be removed from SQL server using management tools. The subsequent installation of Bopup Communication Server will create the database and SQL login again otherwise if that data remains on the SQL server this will cause errors.

Step-by-step instruction on reinstalling Bopup Communication Server using external SQL server:
  1. Uninstall Bopup Communication Server from "Add/Remove Programs" panel.
  2. Remove "BCS40" and "bcsadmin" login name from the SQL server.
  3. Reboot the computer if needed or to ensure that no any existing data will remain.
  4. Start the setup package of Bopup Communication Server.

Wednesday, November 9, 2011

Minor update of Bopup Communication Server. It's version 4.0.1 released.

A new small update of Bopup IM Server software is available for download.

New version 4.0.1 fixes issues that are affected to new users of the . Thus some bugs were resolved in the Setup Wizard of the communication server which does not open a link to our Guide on installing MS SQL Server 2005/2008 Express Edition instead of built-in MSDE 2000 software. Another important error in the installation was incorrect name of the SQL database written into system registry. If the setup package without MSDE 2000 software was used (bcserver.msi setup file) then that problem affects to all users that tried to set up the communication server version 4.0.0 using an existing SQL server.

Download Bopup Communication Server version 4.0.1

Friday, December 3, 2010

Guide on installing MS SQL Server 2005 has been updated and appended

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

Saturday, August 7, 2010

SQL database maintenance options added to the latest release of Bopup IM server

Version 3.3.17 of Bopup Communication Server adds new options to manage SQL database used by the IM server. The new version has added a new "SQL database maintenance" tab in the Options dialog box.


Now the Management Console includes functionality to backup SQL database to a file or restore the database from a previously saved backup file. A function to clean up the database has been also added. It deletes unnecessary data such as message and file transfer archives, user's session activities history that is older than 30 days. This function reduces a size of the SQL database that affects to a memory size used by MS SQL Server.

Sunday, July 25, 2010

Major update of Bopup Communication Server 3.3.16 is available

New version of the communication server has been released. Version 3.3.16 adds a lot of improvements and fixes amount of bugs.

Increased speed and performance of the server on MS SQL Server 2005 Express Edition.
This version adds "AUTO_CLOSE" option set to OFF for SQL database which increases a performance of the IM server because it tells the SQL Server to do not close the database if last connection has been closed. This issue appears only on MS SQL Server 2005 Express Edition that can be installed as a host database server using our guide at Step-by-Step Guide to Install Microsoft SQL Server 2005 Express Edition as a Host Database Server for Bopup Communication Server.

Fixed and improved option of rebuilding users' Contact List on the server.
If the server enables option to automatically rebuild Contact Lists for all users and there are several Organizational Units in which users are located then the service and console might bring an SQL error while rebuilding contacts. The new version of the communication server fixes this problem.

Fixed issues with stopping the service.
Sometimes the service could not be properly stopped and it stayed in memory. This caused a problem with starting the service again and the service's process must be removed from Task Manager (bcssrvc.exe module) first. We improved the code and now the service should be stopped without issues.

The Management Console added a section to view www.bopup.me blog.
The console added a new item in the left tree called "Our blog at www.bopup.me". That item opens and displays this blog and we hope that it will help our customers to stay updated and informed on our development process and news.


Update your Bopup Communication Server software by downloading new installation package from Download Center at www.blabsoft.com

Tuesday, July 20, 2010

AUTO_CLOSE option for the SQL database should be turned off

New issue with MS SQL Server 2005 Express Edition has been discovered by us. We noticed that the SQL Server service logs a lot of "Starting up database bcs30" messages with event ID #17137 to Event Log. This occurs only on SQL Server 2005 Express Edition and may cause problems with Bopup Communication Server performance and stability. This issue doesn't appear if the communication server was installed with built-in MSDE 2000 (Microsoft SQL Desktop Engine).

We found that in order to avoid closing and starting up the database we must use AUTO_CLOSE option set to OFF. This bug fix will be included to the next release of Bopup Communication Server.

More information on this issue: SQL Server Best Practices: AutoClose Should be Off