DB Connection to a Clustered SQL Server 2008 R2 fail
Posted: Thu Dec 20, 2012 3:59 pm
Hi everyone. I need some help with this issue.
My System is as follow:
Cart: AC7.0.3 Net Framework v 3.5
Web server: Virtual Machine Windows Server 2008 R2 SP1
Data base: Remote 2 node Cluster SQL Server 2008 R2 SP1 for HA (same domain as Web server)
Authentication: Integrated Windows (Domain Admin)
Root, Admin, App_Data, and Install folders owned by the Domain admin with full control
IIS_IUSRS full control granted
for the database connection I choose:
Specify database=>Server Name: Server\instance name
Database Name=> created empty Db named AbleCommerce
Database User=>domain\username
SQL cluster and SQL Servers added to the Web server administrator group
Testing an ODBC connection....
Microsoft SQL Server Native Client Version 10.50.2500
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
No matter how many times and different connections variations I try, the result are always the same:
The specified database connection could not be opened. followed by the generated connection string
Obviously something is misconfigured and I'm missing it!
Help please
Thank you
My System is as follow:
Cart: AC7.0.3 Net Framework v 3.5
Web server: Virtual Machine Windows Server 2008 R2 SP1
Data base: Remote 2 node Cluster SQL Server 2008 R2 SP1 for HA (same domain as Web server)
Authentication: Integrated Windows (Domain Admin)
Root, Admin, App_Data, and Install folders owned by the Domain admin with full control
IIS_IUSRS full control granted
for the database connection I choose:
Specify database=>Server Name: Server\instance name
Database Name=> created empty Db named AbleCommerce
Database User=>domain\username
SQL cluster and SQL Servers added to the Web server administrator group
Testing an ODBC connection....
Microsoft SQL Server Native Client Version 10.50.2500
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
No matter how many times and different connections variations I try, the result are always the same:
The specified database connection could not be opened. followed by the generated connection string
Obviously something is misconfigured and I'm missing it!
Help please
Thank you