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!
Allow networkservice to use the DB in Proget
-
Hello there,
After switching proget services to networkservice account, it seems we need to allow it in the database rights too. We've tried to use SSMS to do this, but we can't actually modify rights for the proget DB. Is there a safe way to perform this ?
-
Hi @reseau_6272 ,
Just to confirm, you've switched the ProGet service from a domain account to use Network Service, and when starting the service you're getting some kind of permission error from SQL Server?
The easiest solution is to simply switch to using a username/password instead of Windows Integrated Authentication and edit the connection string appropriately. Keeping in mind that, eventually, you will need to move away from SQL Server and migrate to PostgreSQL, which will not have these issues.
Otherwise, you will explicitly need to grant a login to the machine account. Network Service is represented in SQL Server as the machine account (e.g., DOMAIN\MACHINENAME$), and the identity needs to be explicitly created
CREATE LOGIN [MYDOMAIN\WEB01$] FROM WINDOWS;before you can assign permissions.Thanks,
Alana
-
@atripp We installed ProGet with the local Administrator account specified in InedoHub during installation (because with the NetworkService account, it didn’t work).
Then, we wanted to use the NetworkService account to start the ProGet services.
The services start correctly, but the web page is inaccessible.
After checking on the forum, it says to grant permissions to the NetworkService account on the ProgramData\Inedo and ProgramData\ProGet folders, which has been done.
But it also says to grant permissions to the NetworkService account on the database.
However, we are unable to connect to it with rights that would allow us to grant permissions to NetworkService.
Therefore, we would like to know how to connect to the database (and/or with which account having the necessary privileges to grant permissions to our NetworkService account).
We already try to create login DOMAIN\HOSTNAME$ and give sysadmin rôle and db.admin right on the projet database but this seem to not work
Thank you in advance.
