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!
SQL Server permissions issue in ProGet installation
-
Hi,
I am trying to install Inedo ProGet. Both the ProGet Service and Web Server windows services run with a dedicated domain account.I have given this account dbo rights on a pre-created database, as well as the computer account on the SQL Server.
Failed to run Integrated Web Server.
Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user 'GLOBAL\GLOPROGET01$'.
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open() at Inedo.Data.SqlServerDatabaseContext.CreateConnection() at Inedo.Data.DatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters) at Inedo.Data.SqlServerDatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters) at Inedo.Data.DatabaseContext.<>c__DisplayClass34_01.<EnumerateTable>b__0()
at Inedo.Data.StrongDataReader.Read[TRow](Func1 getReader, Boolean disposeReader)+MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at Inedo.ProGet.Data.DB.Configuration_GetConfiguration()
at Inedo.ProGet.InternalConfig.ReadConfigValues()
at Inedo.LazyCached1.GetValue() at Inedo.LazyCached1.get_Value()
at Inedo.ProGet.ProGetConfig1.ReadFullyQualifiedValue(String scopedKey) at Inedo.ProGet.ProGetConfig1.ReadBoolean(String key)
at Inedo.ProGet.ProGetConfig.Web.get_IntegratedAuthenticationEnabled()
at Inedo.ProGet.WebApplication.Program.get_UseIntegratedAuthentication()
at Inedo.Web.AhWebHost.ConfigureServices(IServiceCollection services)
at Inedo.Web.AhWebHost.Startup.ConfigureServices(IServiceCollection services)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Span1& arguments, Signature sig, Boolean constructor, Boolean wrapExceptions) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.InvokeCore(Object instance, IServiceCollection services) at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.<>c__DisplayClass9_0.<Invoke>g__Startup|0(IServiceCollection serviceCollection) at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.Invoke(Object instance, IServiceCollection services) at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.<>c__DisplayClass8_0.<Build>b__0(IServiceCollection services) at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.UseStartup(Type startupType, HostBuilderContext context, IServiceCollection services, Object instance) at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass14_01.<UseStartup>b__0(HostBuilderContext context, IServiceCollection services)
at Microsoft.Extensions.Hosting.HostBuilder.CreateServiceProvider()
at Microsoft.Extensions.Hosting.HostBuilder.Build()
at Inedo.Web.AhWebHost.RunWithAutomaticRestartAsync(String[] args, CancellationToken cancellationToken)
ClientConnectionId:22e17356-7259-4cf5-a1a6-8bdc3487e8c2
Error Number:18456,State:1,Class:14What am I missing?
-
Hi @gurdip-sira_1271 ,
That message means that the Login for
GLOBAL\GLOPROGET01$does not exist at the SQL Server level; you can add this in SQL Server Management Stuiod, under Security > Logins.Cheers,
Alana
-
@atripp The wierd thing, this is there?
-
When you say Web Server Windows Service, I think you should put the account against the ProGetAppPool Identity. We are running as an integrated SQL connection, and the account is a DB Owner. Both the APP Pool and ProGet Service run as this account. We added the following to the connection string Persist Security Info=False;Integrated Security=true;
