First you need to make sure the SQL server is using
Mixed authentication instead of
Windows authentication method. To ensure this please follow the steps below:
- Download and install the SQL Server management Studio Express;
- Go to Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express
- Select Windows Authentication at the Authentication area and click Connect
- Right click on the instance's name and select Properties
- In the Server Properties window select Security and make sure the SQL Server and Windows Authentication mode option is checked.
Also you would need to make sure the server is allowing both local and remote connections. To check this follow the steps below:
- Go to Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration;
- Select Surface Area Configuration for Services and Connections
- In the Surface Area Configuration for Services and Connections window select the instance that will be used by BitDefender and then Database Engine -> Remote Connections and make sure the Using TCP/IP only or Using both TCP/IP and named pipes option is checked.