...
Open SQL Server Management Studio and connect to the SQL Server instance where the PeopleSync database is located.
- Open a new query window
Run the following command:
Code Block sql sql EXEC xp_ReadErrorLog 0, 1, N'Server is listening on', N'any', NULL, NULL, 'DESC'
On our server, for example, this gives the following output "Server is listening on [ 'any' <ipv4> 1433]."
...
If "PingSucceeded" or "TcpTestSucceeded" is false, then probably the firewall hasn't been opened.
To have more details, run the following script in PowerShell and fill in the information as requested:
| Code Block | ||||
|---|---|---|---|---|
| ||||
$servername = Read-Host -Prompt "Enter SQL Server and instance name"
$database = Read-Host -Prompt "Enter database name"
$installtype = Read-Host -Prompt "Enter 'f' if you are testing the database connection for the frontend or 'b' for the backend"
$Error.Clear()
$connection = New-Object System.Data.Odbc.OdbcConnection
switch ($installtype.ToLower()) {
'f' {
$login = Get-Credential
$connection.ConnectionString = "Driver={ODBC Driver 17 for SQL Server};Server=$servername; Uid=$($login.UserName);Pwd=$($login.GetNetworkCredential().Password); Database=$database"
}
'b' {
$connection.ConnectionString = "Driver={ODBC Driver 17 for SQL Server};Server=$servername; Trusted_Connection=yes; Database=$database"
}
Default { Write-Error -Message "Invalid choice. Exiting." -ErrorAction Stop }
}
Write-Host "Connecting..."
$connection.Open()
$connection.Close()
if ($Error.Count -eq 0) {
Write-Host "Connected"
}
|
Multiple Instances, Dynamic Ports and Special Configurations
...