Aug 01 2019
We are running Windows SQL Server 2016 Enterprise on Windows Server 2016. The server has an instance with databases in Always On High Availability group. People connect to the instance mostly from MS Access and MS Excel applications and from time to time they experience the following error: ————————— Microsoft SQL Server Login ————————— Connection …
May 22 2019
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 …
May 08 2019
I correctly configured ODBC connection on Asterisk server to MSSQL database in Always On cluster. The working configuration was as follows:
Feb 17 2017
There may be a situation when Skype for Business front end server despite of having enough memory performs very poorly and you can even see low memory errors in Event Log from SQL. In case the front end is hosted on virtual machine the first thing that has to be checked in such kind of …
