3 Layer architecture with program and website

It sounds to me like your internal program has already attached the database, and your website is trying to do the same.  Have you thought about just attaching the database and changing the connection string to use that database on both the internal application and website?  Essentially, the way you have it set up is you can use one or the other, but not both at the same time.