Page 1 of 1

Attach DB Issue

Posted: Sat Oct 31, 2009 6:44 am
by mev
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.

Re: Attach DB Issue

Posted: Sat Oct 31, 2009 2:45 pm
by jmestep
Did you use the default Able database? If so, it's a lot better to use one you created via Enterprise manager your self.

Re: Attach DB Issue

Posted: Sat Oct 31, 2009 6:02 pm
by mev
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.