Attach DB Issue

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
mev
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Sat Oct 10, 2009 9:24 am

Attach DB Issue

Post by mev » Sat Oct 31, 2009 6:44 am

After installation of 7.0.3 eveything seemd to be working fine until I tried to attach the database in SQL Server Ent Mgr. I keep getting an error saying it is being used by another process. Then if I reboot I can attach the DB before running Able, but them Able fails to launch. I have setup the permissions as described in the documentation, and it all seesm to work until I try to attach the DB in SQL Server Ent Mgr. I use SQL Server Ent Mgr all the time for many Web Projects and have never encounterd this.

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

Re: Attach DB Issue

Post by jmestep » Sat Oct 31, 2009 2:45 pm

Did you use the default Able database? If so, it's a lot better to use one you created via Enterprise manager your self.
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

mev
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Sat Oct 10, 2009 9:24 am

Re: Attach DB Issue

Post by mev » Sat Oct 31, 2009 6:02 pm

Yes, I used the default DB. I knew it was a permissions thing between the ASPNET user and the local permissions, ...
So, what I finally did was create a SQL user and setup the connection using that account rather then being a Trusted Connection. This makes more sense for deployment anyways.

Post Reply