can't attach sql express db to sql 2005?

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

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