Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

Installer Issue with 'SQL_Latin1_General_CP1_CI_AS’



  • the installer wants to set the database collation to ‘SQL_Latin1_General_CP1_CI_AS’.

    This step however fails with following exception: “The database could not be exclusively locked to perform the operation.”

    Manually setting the database to single user, i.e.:

    ALTER DATABASE [DbName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    

    resolved this issue.

    Product: ProGet
    Version: 3.5.8



  • Another quick way you can close all connections to the database:

    ALTER DATABASE [DbName] SET OFFLINE WITH ROLLBACK IMMEDIATE
    ALTER DATABASE [DbName] SET ONLINE

Log in to reply
 

Inedo Website HomeSupport HomeCode of ConductForums GuideDocumentation