Showing posts with label sql. Show all posts
Showing posts with label sql. 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.

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.

Thursday, November 26, 2015

The IM server fixed issues with sending messages from command line

New version 4.4.2 of Bopup Communication Server has been released and is available for download. This is a minor update of the product that fixed errors with sending instant messages from command line interface using BCSCMD.EXE module of the communication server. Previously it brought errors related to SQL Server on Windows XP and 2003 systems.

Version 4.4.2 also includes the latest release of Setup.ini Configuration Tool that supports the option to show date of messages in client conversations.

Download Bopup Communication Server version 4.4.2 — Enterprise-level IM server for office and business use

Thursday, October 29, 2015

Bopup IM software added support for IPv6 protocol

We are proud to announce that both the communication server and IM client software now support IPv6 protocol that is the most recent version of the Internet Protocol (IP). It is intended to replace current version IPv4. The IM server supports also IPv4 so the software can accept connections using different protocols at the same time from messenger clients.

Bopup Communication Server also added new option to Messaging Group profiles that allows to hide a list of assigned users to the group and to do not show them in user's Contact List. So the displayed group cannot be expanded.

Another improvement is related to sorting messages and file transfers shown in Pending, Sent and Deleted/Declined views under Message History in the console. Now the server uses DATETIME SQL data type instead of SMALLDATETIME type used previously that includes seconds within hour and minutes.

Download Bopup Communication Server version 4.4, Bopup Messenger version 6.7 and Bopup Observer version 5.6

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

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