DB Connection to a Clustered SQL Server 2008 R2 fail

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
54x54
Ensign (ENS)
Ensign (ENS)
Posts: 16
Joined: Sun Jul 06, 2008 12:23 am

DB Connection to a Clustered SQL Server 2008 R2 fail

Post by 54x54 » 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

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: DB Connection to a Clustered SQL Server 2008 R2 fail

Post by jmestep » Fri Dec 21, 2012 6:38 am

Does SQL server allow remote connections? That's all I can think of.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

54x54
Ensign (ENS)
Ensign (ENS)
Posts: 16
Joined: Sun Jul 06, 2008 12:23 am

Re: DB Connection to a Clustered SQL Server 2008 R2 fail

Post by 54x54 » Fri Dec 21, 2012 4:34 pm

Thank you Judy for take you time to trying to help me with this.
Yes, the server allow remote connections, on WS2K8R2 it is activated by default with a timeout query to it of 600 sec.
I been putting some 60 hrs. or so doing troubleshooting, installed and configured a local WS2K8R2, a local WS2K5Expess alternatively pointing theAC7 install to the correspondent one, create a new user as dbo, ran portquery and hping on tcp 1433, I rdp from the webserver to the remote cluster with no problem.
What else could be authentication problem?
Keeping on digging
Thank you

54x54
Ensign (ENS)
Ensign (ENS)
Posts: 16
Joined: Sun Jul 06, 2008 12:23 am

Re: DB Connection to a Clustered SQL Server 2008 R2 fail-Solved!

Post by 54x54 » Tue Dec 25, 2012 2:46 am

Problem Solved!!
even better being able to migrated the DB from original to target with no errors
piece of advice to the no seasoned like me: read the instructions through and through, once and again!, little subtleties you took for granted 'boomerang around' to hit your unaware rear end.
do a:
1. mixed authentication with sa as dbo owner
2. on ssms check management->SQl Server Logs will inform you (live) what the errors are, then baby walked to what to do next, just an overlooked classic tool!
3. follow the toolbox troubleshooting techniques of your arsenal and you are done
Merry Christmas to all (check the 2010 Columbia Valley Cabernet Sauvignon, wash anything eaten down pretty good

Post Reply