Troubleshooting BitDefender Management Console connection issues

Case A

If you already had an instance of the Microsoft SQL Server installed on the computer before installing BitDefender's Management Server, you should follow the steps below:

1. Go to Start, Run, type services.msc and click OK;
2. Locate and stop the BitDefender Management Server service;
3. Locate and open the C:\Documents and Settings\All Users\Application Data\BitDefender\Enterprise 3\Server\server.xml file;
4. Go to the tag and change the SERVER value:

from:
SERVER=server_ip\sqlserver
to
SERVER=server_ip

5. Start the BitDefender Management Server service;
6. Open the BitDefender Management Console. You should now be able to log in.

Additionally, you could force the Management Console to bypass the verification of the credentials required to connect to the database, by modifying the ConnectionString as shown below:

DRIVER={SQL Server};DATABASE=em3;SERVER=server_ip;integrated security=true;

Case B

In the Management Server connection window, when asked for the credentials and the connection parameters, change the address in the Management Server field from localhost or 127.0.0.1 to the real IP address of the machine (for example 192.168.1.10) or to its name.

Management Server's connection window


If you are still unable to connect to the Console, you may need to recreate the database used by BitDefender. To accomplish this, please follow the steps below:

1. Go to Start, Run, type services.msc and click OK;
2. Locate and stop the BitDefender Management Server service;
3. Go to the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder and delete all em3* files;
4. Open the SQL Server Management Studio Express (if it's not already installed on your computer, you can download it free of charge from here);
5. At the Connect to Server window, enter server_name\sqlexpress in the Server name field, choose Windows Authentication at the Authentication field and click Connect.
(Note: if you are requested to enter the credentials, you should provide those of an administrative account.)



6. Open the following file C:\Program Files\BitDefender\BitDefender Management Server\main.sql and execute it (at this step the em3 database is created);
7. Start the BitDefender Management Server service;
8. Open the BitDefender Management Console. You should now be able to log in.