Tag: AlwaysOn

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

Install-CsDatabase error: The network name cannot be found.

SQL-shared-storage-alwayson-listener

While publishing Skype for Business topology when new databases has to be created on Backend servers there may be an error publishing topology upon execution of Install-CsDatabase cmdlet: Error: The network name cannot be found. ▼ Details └ Type: IOException └ ▼ Stack Trace └ at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, …

Continue reading

MSSQL Server Error 67 and 17 SQL Server does not exist or access denied

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

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-trusted

When 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

Skype for Business. Move Central Management Store

add-database-to-high-availability-group

There is a need to move Central Management Server to a new pool as the existing one is going to be decommissioned. SQL Backend consists of two MSSQL 2014 Servers running in AlwaysOn Cluster. While running Move-CsManagementServer commandlet with –WhatIf key I got an error: Cannot move Central Management Server. The new Central Management Store …

Continue reading