How to run a command on boot or startup in Ubuntu.
How to run a command on boot or startup in Ubuntu.
List User Account Spn:
Get-ADUSer -Filter { ServicePrincipalName -ne "$null"} -Properties ServicePrincipalName | select
SamAccountName, ServicePrincipalName
List Computer Account Spn
Get-ADComputer -Filter { ServicePrincipalName -ne "$null"} -Properties ServicePrincipalName | select SamAccountName, ServicePrincipalName | Out-String -Width 4096
Setting SPN:
setSPN -A MSSQLsvc/sqlserver1.contoso.com:59302 contoso\serviceaccount
setSPN -A MSSQLsvc/sqlserver1:59302 contoso\serviceaccount
SQL error when connecting to server using servername\instance.
Error:
A network-related or instance-specific error occurred when establishing a connection to SQL server. the server was not found or was not accessible.Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)
Solution:
The UDP port 1434 on destination server was being blocked in the firewall.