SQL 2012 CLUSTER compatibility?

Is Avast! Enterprise server compatible with a Microsoft SQL 2012 Cluster?

When setting Avast Enterprise Console up, I tried several different ways of entering SQL Server information during setup.

Server Name: CC-SQL12
Instance: Default Instance that SQL 2012 uses (should be MSSQL)

Tried Server name with and without instance name - CC-SQL12 and CC-SQL12\MSSQL

I sucessfully test connectivity outside the installer with Microsoft UDL Data Link Properties. It sees all our SQL cluster and lists available databases fine.

Inside the Avast! installer, it says it “Couldn’t locate SQL server CC-SQL12. You have specified incorrect SQL server name or login.” Login info was correct and connectivity was verified earlier outside of installer.

Since creating avast database failed, we tried creating an AVAST database instance ahead of time. This failed as well, so we decided to let the install continue without a connection and then use the Avast Maintenance tool to recreate the database with a proper config, but it still couldn’t see the database after we tried re-pointing the maint tool to it.

Any help would be appreciated!

-Jeff

Can you connect to the SQL instance via SQLCMD?

Try this in Command Prompt (CMD):

sqlcmd -S CC-SQL12\MSSQL -U sa -P SA-PASSWORD

You may also try with (local)\MSSQL or .\MSSQL

Also make sure that MSSQL is the correct instance name, not for example: MSSQLSERVER