We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

View Complete Thread
  • Problem with dbFullSql

    Feb 17, 2012 07:47 AM|shanedhorlock|LINK

    I am getting an error trying to publish the database element of my DNN website to a new hosting service. All files copy ok, but database script generated / used by dbFullSql function of Web Deploy contains references to the old hosting service user id.

    Where do I find the script that was generated / used? How can I change it and execute it correctly?

    Webmatrix publish log extract follows: 

    Adding child sqlScript (MSDeploy.Continous/dbFullSql[@path='data source=ASPHOST75\SQL2008,777;initial catalog=Shanedhorloc_WLHG;user id=Shanedhorloc_host']/sqlScript).
    11:08:49: Opening SQL Connection with connection string 'data source=ASPHOST75\SQL2008,777;initial catalog=Shanedhorloc_WLHG;user id=Shanedhorloc_host;pooling=False'. The 'transacted' setting for this connection is 'True'.
    11:11:55: Unable to publish the database. For more information, see "http://go.microsoft.com/fwlink/?LinkId=205387"
    11:11:55: Unable to publish. Unable to publish the database. For more information, see "http://go.microsoft.com/fwlink/?LinkId=205387"
    11:11:55: Error detail:
    11:11:55: An error occurred during execution of the database script. The error occurred between the following lines of the script: "3856" and "3858". The verbose log might have more information about the error. The command started with the following:
    11:11:55: "CREATE SCHEMA [prvcsdvy_host] AUTHORIZATION [prvcs"