Impossible install cloud panel scheduler
Hello,
I can not install cloudpanel scheduler I have the error message that tells me that I do not have the rights to install, while I am admin of the domain.
You may be installing it on a domain controller and that user doesn’t have log on as a service. You probably get stuck in the part where it asks to retry starting the service and if you do open services.msc and try to manually start the service. If it doesn’t start and gives you an error about not having log on as a service rights, then open the properties, edit the user section, save, it will prompt that it now has log on as a service rights, and start it.
Then click retry on the installer.
I start the service well as administrator. here is the content of the service.log file :
[2018-10-09 07:54:03,360] | ERROR | CPService.CPService | Shutting down service because we could not retrieve the settings from the database. Please check your database connection string and try again
[2018-10-09 07:54:14,490] | INFO | CPService.CPService | Job GetSettingsTask was excecuted now and scheduled to run every 10 minutes
[2018-10-09 07:54:14,571] | INFO | CPService.Tasks.Settings.GetSettingsTask| Job Executed: Updating settings from database
[2018-10-09 07:54:29,191] | ERROR | CPService.Tasks.Settings.GetSettingsTask| Error getting settings: System.Data.SqlClient.SqlException (0x80131904): Une erreur liée au réseau ou spécifique à l’instance s’est produite lors de l’établissement d’une connexion à SQL Server. Le serveur est introuvable ou n’est pas accessible. Vérifiez que le nom de l’instance est correct et que SQL Server est configuré pour autoriser les connexions distantes. (provider: SQL Network Interfaces, error: 26 – Erreur lors de la localisation du serveur/de l’instance spécifiés)
à System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
à System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
à System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
à System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
à System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
à System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
à System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
à System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
à System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
à System.Data.SqlClient.SqlConnection.Open()
à System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user)
à System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe()
à System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode()
à System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
à System.Data.Linq.Table`1.GetEnumerator()
à System.Data.Linq.Table`1.System.Collections.Generic.IEnumerable<TEntity>.GetEnumerator()
à System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
à System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
à CPService.Tasks.Settings.GetSettingsTask.Execute(IJobExecutionContext context)
ClientConnectionId :00000000-0000-0000-0000-000000000000
Error Number :-1,State :0,Class :20
It appears the user you are using doesn’t have rights to the database. Just because it is a domain admin or administrator doesn’t mean it has rights to the SQL instance. In your case it looks like TCP/IP wasn’t enabled on the SQL instance most likely, so it is not accepting connections.
You can download a connection string tester to test with also: http://www.vadimtabakman.com/connection-string-tester.aspx
I can connect to the database from the server by microsoft sql server management studio. Connection tcp/ip is enable. my administrateur is db_owner
SQL Management Studio doesn’t use TCP/IP. Have you tried the a sql connection string tester?
I can connect to it with a sql connection string tester
Using the same settings that is in the Scheduler.exe.config for the connection string? During the install you can do Windows Authentication or SQL Authentication, which one did you choose and did you use that for the test?
Please email me at jdixon@knowmoreit.com and I can do a screen sharing with you.
- 5 Forums
- 714 Topics
- 3,630 Posts
- 0 Online
- 253 Members