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!
Unable to upgrade ProGet
-
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
-
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 -
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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login