Active Directory Administration Cookbook

There's more...

In some environments, complex SQL connection strings might be returned by a SQL admin in response to the AD FS SQL scripts. In these cases, it is wise to test the SQL connection string manually on the AD FS servers before implementation. You can use the following lines of PowerShell for this purpose:

$conn = New-Object System.Data.SqlClient.SqlConnection$conn.ConnectionString = "Data Source=SQLSERVER:Port;Integrated Security=True"# If no error occurs here, then connection was successful.$conn.Open();$conn.Close();