Installing 7.0 Not Connecting to SQL 2005

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
gknecht
Ensign (ENS)
Ensign (ENS)
Posts: 1
Joined: Wed Jul 23, 2008 1:59 pm

Installing 7.0 Not Connecting to SQL 2005

Post by gknecht » Wed Jul 23, 2008 2:07 pm

Installing ablecommerce and enter correct db connection info on configuration1.aspx page. Upon submit, it appears a connection is made, but nothing happens and returned to page with following message.

The specified database connection could not be opened.

followed by my connection string.

I know connection string is correct, and have tested elsewhere. Any ideas.

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Installing 7.0 Not Connecting to SQL 2005

Post by mazhar » Sat Jul 26, 2008 6:05 am

Did you provided the user information properly.

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

Re: Installing 7.0 Not Connecting to SQL 2005

Post by jmestep » Sat Jul 26, 2008 11:06 am

I just had it happen on an install I did for someone and when SQL Server had been installed, it had been configured for Windows authentication only. Once I changed it to mixed mode, the install connected OK.
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

Post Reply