System.Data.SqlClient.SqlException: Login failed for user ‘WebsitePanel’

Question

5.23K views17 - 02 - 2020

0

maverh 15 - 08 - 2016 0 Comments

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’. 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 —

[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

williamholding Answered question 17 - 02 - 2020

2 Answers

You are viewing 1 out of 2 answers, click here to view all answers.

score 0 · Answer 1 · 2016-08-15T12:50:40+00:00

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

System.Data.SqlClient.SqlException: Login failed for user ‘WebsitePanel’

2 Answers

Search questions

Question stats

Other Questions