#skype4b #powershell *-CsDatabase Common Error Messages (and Fix)

Even with the right administrative account and permissions, and proper network as well as firewall (port) settings provisioned, a number of common error messages when working with *-CsDatabase cmdlets in Skype for Business Server prove to be rather challenging to decipher and resolve:

PS C:\> Install-CsDatabase -SqlServerFqdn sql01.leedesmond.com -SqlInstanceName sql01inst01 -Update -ConfiguredDatabases
Install-CsDatabase : Parameter set cannot be resolved using the specified named parameters.
At line:1 char:1
+ Install-CsDatabase -SqlServerFqdn sql01.leedesmond.com -SqlInstanceName sql01inst01 -Update -ConfiguredDatabases
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:) [Install-CsDatabase], ParameterBindingException
+ FullyQualifiedErrorId : AmbiguousParameterSet,Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet

Continue reading

#skype4b/lync Hide Share/Presentation Meeting Window (Keyboard Shortcut)

In a conference call using Skype for Business 2016/2015 desktop client, an end-user is only allowed to toggle between Speaker and Gallery view using the left most icon on the top right hand corner of the meeting window. Until someone shares something or makes a PowerPoint presentation, you may have to stare at the (typically low-resolution) overblown photograph of the active speaker or a row of meeting participants’ pictures.

To go back to classic “telephone” audio voice calls with no visual cues of the person speaking whatsoever, you can hit Ctrl+Shift+P on the keyboard to move into Compact View for the Sfb desktop client. This functions apparently only if the Participants window is active otherwise the Gallery view will be shown.

REFERENCE
Keyboard shortcuts for Skype for Business

#skype4B/Lync #powershell Script: Compare User Policy (Update v1.10)

This revised version of Compare-Skype4BUserPolicy adds the option to include items that hold the same values. It is one of the many PowerShell functions/utilities in my personal script toolbox repository designed to help simplify the management and administration of just about any Lync / Skype for Business Server environments.

Have fun!

################################################################################
# Copyright (c) 201x-2017 leedesmond.com
# All Rights Reserved. Use at your own risk and responsibility.
# Compare-Skype4BUserPolicy.ps1
# Version 1.10
# Continue reading

#skype4b #powershell Compare (Any) Lync/Skype Policy

Compare-SfbAnyPolicy is one of the many PowerShell functions/utilities in my personal script toolbox repository designed to help simplify the management and administration of just about any Lync / Skype for Business Server environments.

Enjoy!

################################################################################
# Copyright (c) 201x-2017 leedesmond.com
# All Rights Reserved. Use at your own risk and responsibility.
# Compare-SfbAnyPolicy.ps1
# Version 1.00
# Continue reading

#skype4b #powershell Auto Enforce User-defined Lync/Skype Presence Status

Code sample to automatically maintain a user-defined Presence status in Lync / Skype for Business desktop client. Works even when the Windows computer is locked i.e. ignore PC lock and override Lync / Skype4b ‘s presence auto-reset.

Enjoy!
Continue reading

#skype4b #powershell Watch Those Temporary Files!

Certain cmdlets in the SkypeForBusiness PowerShell module appear to have the need to write temporary files to the $env:temp folder in order to correctly function.

Over time, disk space consumption can add up, particularly when this path points to the default location, namely on the same drive where the operating system is installed. Needless to say, regular manual or scheduled clean-up of the temp directory is generally recommended to ensure continuous and trouble-free operations.

#skype4b/office365 Cannot perform the action (password reset)

With the right credentials, you continue to fail to sign-in to Skype for Business / Office 365 (Skype Online):

Can’t sign in to Skype for Business
The user name, password, or domain appears to be incorrect. Ensure that you entered them correctly. If the problem continues, please contact your support team.

Still not working? See if you can fix it.
[OK]

On the main skype4b desktop application’s “Sign in” page, … Continue reading

#skype4b Uninstall-CsDatabase SQL Failure

To remove a Skype for Business Server backend SQL database, you execute the following and immediately hit a similar failure as depicted:

Uninstall-CsDatabase -SqlServerFqdn fesqlserver -DatabaseType Monitoring

Trying to connect to Sql Server using windows authentication…
Exception stack:
Type: System.Reflection.TargetInvocationException, Message: Exception has been thrown by the target of an invocation.
Type: Microsoft.Rtc.Common.Data.DbSetupSqlServiceNotInstalledException, Message: Failed to find Sql Service. Make sure that SQL server service (default instance) is installed in machine fesqlserver.

Uninstall-CsDatabse: Failed to connect to the SQL Server fesqlserver.
At line:1 char:1

For a setup with non SQL default instance (MSSQLSERVER), specify the -SqlInstanceName parameter and corresponding value to correct this issue.

#skype4b: SQL Mirror Database Failover Suspended (not synchronized state)

With SQL Database Mirroring setup in a Skype for Business Server infrastructure, the state of all databases should be uniform and not with “partial” cross over. That is to say, the status for both StateOnPrimary and StateOnMirror should either all be in the Principal or Mirror state when checked using Get-CsDatabaseMirrorState.

If that turns out otherwise, you can run Invoke-CsDatabaseFailover for the target Front-End pool to achieve this stable mirror state on both the primary and mirror SQL Database servers. Nevertheless, FailedWithError could happen where MirroringStatusOnPrimary and/or MirroringStatusOnMirror continue to show suspended and cannot reach a synchronized state.

Should a manual … Continue reading

skype4b: Get-CsUserDatabaseState – Show SQL Database Servers

Here’s a quick tip to display the names of associated backend SQL primary and mirrored (if any) database servers of a Standard or Enterprise Edition Lync/Skype for Business Server 2015 Front-End pool:

Get-CsUserDatabaseState -RegistrarPool fepool.leedesmond.com

The result lists the Identity, Mirror and Online status of the SQL database servers of the specified FE registrar pool. This works since only this pool type houses the user store (database) which keeps key user related information like presence and routing data.