Attach DB Issue
Attach DB Issue
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.
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Attach DB Issue
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
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
Re: Attach DB Issue
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.
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.