During the Windows setup,
- On the WiFi screen, press SHIFT + F10 or FN + SHIFT + F10
- This will open the command prompt window with administrator rights
- Type: start ms-cxh:localonly and hit Enter
“No problem can be solved from the same level of consciousness that created it.” Albert Einstein (1879-1955)
During the Windows setup,
We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly... link
# Run PowerShell as Administrator
Install-Module -Name UniversalDashboard.Community
# Check PowerShellGet version
Get-Module -Name PowerShellGet -ListAvailable
# If you do not have PowerShellGet version 2.0 or higher
Install-Module -Name PowerShellGet -Force
# Check PowerShellGet version
Get-Module -Name PowerShellGet -ListAvailable
# Delete old version of PowerShellGet
# for x64
Get-ChildItem -Path 'C:\Program Files\WindowsPowerShell\Modules\PowerShellGet'
Remove-Item -Path 'C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1' -Recurse -Force
# for x86
Get-ChildItem -Path 'C:\Program Files (x86)\WindowsPowerShell\Modules\PowerShellGet'
Remove-Item -Path 'C:\Program Files (x86)\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1' -Recurse -Force
# Copy new version from x64 to x86
Copy-Item -Path 'C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\' -Destination 'C:\Program Files (x86)\WindowsPowerShell\Modules\PowerShellGet\'
# Copy new version from x86 to x64
Copy-Item -Path 'C:\Program Files (x86)\WindowsPowerShell\Modules\PowerShellGet\' -Destination 'C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\'
# Close the PowerShell session and reopen it
# Install the universal dashboard community module
# If you run into a command already available error, explicitly allow the new module to override the existing commands by using the -AllowClobber
Install-Module -Name UniversalDashboard.Community -AllowClobber
# Check
Get-Module UniversalDashboard.Community
Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Framework Microsoft SqlClient Data Provider):
Sometimes when trying to access a linked server, you’d get an error saying “Login failed for user NT AUTHORITY\ANONYMOUS LOGON”.
This happens because you’re connected using Windows authentication, and SQL Server fails to “forward” your credentials to the linked server.
To check if SQL is using Kerberos:
USE [master]
GO
SELECT s.session_id, s.original_login_name, c.net_transport, c.auth_scheme, c.local_net_address, c.local_tcp_port, s.program_name
FROM sys.dm_exec_sessions s
LEFT OUTER JOIN sys.dm_exec_connections c on s.session_id = c.session_id
WHERE s.is_user_process = 1
To determine the authentication method of a connection, execute the following query:
SELECT net_transport, auth_scheme
FROM sys.dm_exec_connections
WHERE session_id = @@SPID;
Validating Authentication Properties Used by Connections
USE [master]
GO
SELECT COUNT(auth_scheme) as sessions_count, net_transport, auth_scheme
FROM sys.dm_exec_connections
GROUP BY net_transport, auth_scheme
To resolve this:
During the Windows setup, On the WiFi screen, press SHIFT + F10 or FN + SHIFT + F10 This will open the command prompt window with admini...