BE 2012 Cannot connect to the SQL server
I am trying to install BE 2012 on a physical server and not getting it to work. The following is the message i get:
"cannot connect to microsoft sql server servername. on the remote sql server, verify that:
-the remote client connections are allowed. by default, sql server 2005 express, evaluation, or developer editions allow local client connections only. for more information refer to http://msdn2.microsoft.com/en-us/library/ms178763.aspx.
-the user who is currently logged on to this system is a member of the administrators group on SQL server servername\dbinstance"
where servername is the name of the server (removed for security)
I am using an external database server in a clustered configuration. I use one of the sql cluster members as the SQL (not the cluster name, though either the server name or cluster name doesnt work also). The instance name was used before for a previous server (VM) that has now been decommisioned. I moved the DB files away after stopping the instance (named), tried and still no luck.
I am using the same username on the BE server and on the SQL.