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
#15847
Mar 25, 2008 19:07
Vote:
 
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
Mar 25, 2008 19:09
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.