Unable to upgrade ProGet

[daniel.cooper_8892]

I am attempting to upgrade our ProGet install to the latest version (from 4.8.5) to try and resolve an issue (pushing new packages sometimes fails with 503 - Service Unavailable)

I downloaded and ran the InedoHub offline updater, but am getting the following:

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "ProGet" requested by the login. The login failed.

I have followed previous advice I've seen on this forum (https://forums.inedo.com/topic/2563/updating-proget-from-5-0-9-fails-with-cannot-open-database-proget-requested-by-the-login), but unfortunately I do not have access to the original user account it was installed under and the ProGet services are running as NT Service Accounts.

The database connection string is <add key="InedoLib.DbConnectionString" value="Data Source=localhost\ProGet; Initial Catalog=ProGet; Integrated Security=True;" />

I am unable to connect to this database remotely via SQL Server Management Studio.

As there any way of finding out which user I need to use to run the installer as (I have tried both Domain Admin and local Server Admin accounts, to no avail)

Dan

[atripp]

Hi @daniel-cooper_8892 ,

At first, please note you'll need to upgrade to v5.2 first, and then you can move to v5.3: please see Upgrading from ProGet v4.

Of course, you'll need access to your database. Please check out: Connect to SQL Server when system administrators are locked out

Once you do that, you can connect from SQL Management Studio, and then add yourself (and ideally the local Administrators group) as the sysadmin of sql server.

Cheers,
Alana

[daniel.cooper_8892]

Hi,

I have now been able to get into the database and add my own username. This has allowed me to upgrade to 5.2 and we are planning to upgrade to 5.3 once the devs confirm the breaking changes won't have an impact.

Thanks for your assistance.