System.Data.SqlClie...
 
Notifications
Clear all

System.Data.SqlClient.SqlException: Login failed for user 'WebsitePanel'

2 Posts
2 Users
0 Reactions
3,041 Views
Posts: 2
Topic starter
(@maverh)
Member
Joined: 8 years ago

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
1 Reply
Posts: 1967
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

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

Reply
Share: