Tag: MS SQL

Recover WSFC and AlwaysOn from Resolving State

There is a SQL Server Availability Group (AG) on a Windows Server Failover Cluster (WSFC) with 3 nodes using Node Majority quorum configuration. In an unforeseen circumstance, 2 nodes went completely offline at the same time causing the WSFC to go down. This caused the Availability Group to go into a Resolving state and all …

Continue reading

Skype for Business Server 2019 Monitoring Reports Error: Cannot get the ReportServerWebService URL

When deploying a recent Skype for Business Server 2019 deployment, I came across an issue when installing monitoring reports on a server. In previous editions of SQL Server, SQL Server Reporting Services (SSRS) was installed and configured by default. With the release of SQL Server 2017, this is now a seperate download that only installs …

Continue reading

Get Scheduled Skype for Business Meetings from SQL

The following SQL query will get scheduled conferences from the Skype for Business RTC database. From a Skype for Business Standard Edition server its in the RTCLOCAL instance, otherwise you’ll find it in the backend SQL server. To run the query you will need to open SQL Server Management Console, connect to the database, then …

Continue reading

MSSQL Server Error 67 and 17

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 …

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 …

Continue reading

odbc_log: Unable to retrieve database handle. CDR failed.

I correctly configured ODBC connection on Asterisk server to MSSQL database in Always On cluster. The working configuration was as follows: Be sociable 🙂 Share!

Continue reading

Skype for Business SQL Low RAM condition

skype-for-business-sql-memory-limits

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 …

Continue reading