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