Upgrading ProGet as a different user fails

[rob.leadbeater_2457]

Hi,

I'm trying to upgrade an instance of ProGet Free from 2022.14 to 2022.17.
This is a default installation using the bundled SQL database.

The initial installation was done by UserA. I'm trying to perform the upgrade as UserB.

When UserB starts Inedo Hub, rather than seeing an Upgrade button, there's a View Error button, which indicates:

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "ProGet" requested by the login. The login failed.
Login failed for user 'DOMAIN\UserB'

Clearly UserB doesn't have access to the database, as (presumably) it's running with the Integrated Security enabled.

Data Source=localhost\INEDO;Initial Catalog=ProGet;Integrated Security=True

As a complete novice to MS SQL server, what steps need to be taken to give UserB the right permissions?

Cheers,
Rob

[atripp]

Hi @rob-leadbeater_2457 ,

It sounds like you'll need to grant yourself (UserB) "sysadmin" access. You should probably also grant the local Administrators group access as well while you're at it :)

The easiest way to do this is with the SQL Server management tools, since it's all gui-driven. That's a free download/install from Microsoft, and I would recommend installing it on the server anyways. But it's also possible to do it with the command line/scripts.

Microsoft has some guidance on how to do this;
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?view=sql-server-ver16

Once you've given yourself sysadmin, you should have no issues.

Alana

[rob.leadbeater_2457]

Thanks Alana,

I had tried giving myself sysadmin rights previously, but was still getting permission errors.
The trick from that article, to put the database in single user mode first, got things working.

Cheers,
Rob