Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
can't attach sql express db to sql 2005?
Vote:
Hi,
I am getting the following error when trying to attach the sql express db to sql 2005:
Attach database failed for server (sqlserver.smo)
An exception occured while executing a transact-sql
Also, once I have attached the database what user\role do I need to create to connect to the database?
thanks
Oct 31, 2007 2:20
This shouldn´t be any problem to connect from an sqlexpress to a ordinary sql 2005 there is no changes in the db. You should use the same user that you used on the local machine or you create a new user that is dbowner for you db and uses the schema [dbowner]. Then you have to use that user in you connectionstring in web.config.
Best Regards
Eric Pettersson(EPiServer)
#16485
Nov 02, 2007 9:59
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
