After install i receive the following error : how can i reset te password for the database in the /enterprise/web.config the password is encrypted?
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Login failed for user 'WebsitePanel'.<br> at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)<br> at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)<br> at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)<br> at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)<br> at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)<br> at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)<br> at System.Data.SqlClient.SqlConnection.Open()<br> at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)<br> at SolidCP.EnterpriseServer.DataProvider.GetSystemSettings(String settingsName)<br> at SolidCP.EnterpriseServer.SystemController.GetSystemSettingsInternal(String settingsName, Boolean decryptPassword)<br> at SolidCP.EnterpriseServer.SystemController.GetSystemSetupMode()<br> at SolidCP.EnterpriseServer.esAuthentication.GetSystemSetupMode()<br> --- End of inner exception stack trace ---
[SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Login failed for user 'WebsitePanel'. at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at SolidCP.EnterpriseServer.DataProvider.GetSystemSettings(String settingsName) at SolidCP.EnterpriseServer.SystemController.GetSystemSettingsInternal(String settingsName, Boolean decryptPassword) at SolidCP.EnterpriseServer.SystemController.GetSystemSetupMode() at SolidCP.EnterpriseServer.esAuthentication.GetSystemSetupMode() --- End of inner exception stack trace ---] System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +690429 System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +327 SolidCP.EnterpriseServer.esAuthentication.GetSystemSetupMode() +50 SolidCP.Portal.Login.Page_Load(Object sender, EventArgs e) +92 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178
Hello,
The serveradmin password is encrypted, however your error is about the mssql user password, this is simply in plain text in the web.config of Enterprise.
all it needs to do is match the mssql username, password, and mssql server instance.
Regards,
Marco