MSSQL Error – Access to the remote server is denied because the current security context is not trusted

mssql-error-access-to-the-remote-server-is-denied-because-the-current-security-context-is-not-trustedWhen trying to load data from  database that is in AlwaysOn High Availability Group from Microsoft Excel the following error occurs:

Access to the remote server is denied because the current security context is not trusted Continue reading

SQL Error – The database owner SID recorded in the master database differs from the database owner SID

When trying to execute Stored Procedures on a particular Database we got the following error:

The server principal “domain\user” is not able to access the database “dbXYZ” under the current security context.

The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘dbXYZ’. You should correct this situation by resetting the owner of database ‘dbXYZ’ using the ALTER AUTHORIZATION statement. Continue reading

odbc_log: Unable to retrieve database handle. CDR failed.

Asterisk PBXI correctly configured ODBC connection on Asterisk server to MSSQL database in Always On cluster.

The working configuration was as follows: Continue reading

How to correctly stop/reboot Skype for Business server

skype-for-businessSkype for Business like any other service needs periodic maintenance and that’s when you need to know how to gracefully stop Skype for Business service without losing a quorum.

Before stopping Skype for Business service make sure you will have more than 50% of front end servers running. Continue reading

How to find all files containing specific text in Linux

Finding files containing text string in Linux is the easy task with the grep utility. grep also allows you to find files with specific text by searching directories recursively by defining -r key. Here are a few examples:

Continue reading

Asterisk crashes on res_odbc.so load

asterisk-invalid-pointerWhile loading res_odbc.so Asterisk crashes with “invalid pointererror like in the backtrace below:

Loading res_odbc.so. Continue reading

How to reset MySQL/MariaDB root password

mysql-logo-imageStart session ssh (using root if possible).

Edit my.cnf file using.

sudo vi /etc/my.cnf

Add line to [mysqld] block: Continue reading

Parse JSON in Asterisk: how to install res_json

Asterisk PBXIf you need to talk to external API and parse JSON in Asterisk dialplan you will need res_json installed. Unfortunately it’s not bundled in Asterisk installation yet but here is how you can install res_json in Asterisk: Continue reading

Calculate Difference between two Time Values in Asterisk Dialplan

Asterisk PBXFor calculating the difference between two times in Asterisk dialplan, the time values should be converted to an epoch value first. This  can be done using the asterisk function STRFTIME. Use the below dialplan to convert current time to an epoch value

Set(time=${STRFTIME(${EPOCH},,%s)}) Continue reading

New encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

odoo-logoDuring the step of database creation in Odoo database manager the following database creation error occurs:

New encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

Odoo-database-creation-error Continue reading

Load more