November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

can't attach sql express db to sql 2005?

sam grimmer
sam grimmer
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
Oct 31, 2007 2:20
Eric
Eric
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
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.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.