Cannot open database asp.net
Posted by Faiyaz, 09-22-2008, 03:02 PM Cannot open database "DATABASENAME" requested by the login. The login failed. Login failed for user 'SERVERNAME\IWAM_plesk(default)'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot open database "DATABASENAME" requested by the login. The login failed. Login failed for user SERVERNAME\IWAM_plesk(default)'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): Cannot open database "DATABASENAME" requested by the login. The login failed.Login failed for user SERVERNAME\IWAM_plesk(default)'.] _Default.FindDuplicateUserName(String UName) +154 _Default.btnOk_Click(Object sender, EventArgs e) +31 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565 Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
Posted by Faiyaz, 09-22-2008, 03:05 PM Sorry, I just forgot to describe the problem. I have a plesk ( Parallels ) server, I am able to connect to database locally from plesk but when I try to connect using connection string on my site I am getting above given error. I already added user IWAM_plesk to " SQLEXPRESS " mssql server. Is this permission issue or whatever please help