Try our conversational search powered by Generative AI!
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.
