Microsoft KB Archive/944778

= Error message when you try to connect to a managed server by using Forefront Server Security Management Console on a backup server: &quot;It is not possible to establish a connection with the database&quot; =

Article ID: 944778

Article Last Modified on 12/27/2007

-

APPLIES TO


 * Microsoft Forefront Server Security Management Console

-



SYMPTOMS
When you try to connect to a managed server by using Microsoft Forefront Server Security Management Console on a backup server, you receive the following error message:

It is not possible to establish a connection with the database. Please check the connection logs and make sure that the database server is running.

Additionally, you experience the following symptoms:  You receive the following exception in the FSSMCInstall.log file on the computer that is designated as the Forefront backup server:

The column name &quot;rowguid&quot; is not valid.

 When you verify the backup Forefront Server Security database, no replication data is available.

These symptoms occur after you use one of the following methods to perform a backup installation of Forefront Security Server:
 * You use the Express installation method to install the product. Forefront Server Security Management Console is installed automatically.
 * You use the Enterprise installation method to install the product, and then you install Forefront Server Security Management Console.



CAUSE
This problem occurs because the primary database user on the Microsoft SQL Server server is not a member of the local Administrators group on the backup server.



RESOLUTION
To resolve this problem, add the primary database user on the SQL server to the local Administrators group on the backup server.

