Today at 2:49 AM
Hi! I am stuck and Can't solve a problem. I've uploaded my ASP.NET MVC database project (Used Entity Framework).
Uploaded my project to Plesk. All the action results without DB works fine. But Database Connection fails. (My original Database is based on Microsoft SQL Server 2019)
Shows the error :
Server Error in '/' Application.
Cannot open database "FinalProjectDB" requested by the login. The login failed.
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 "FinalProjectDB" requested by the login. The login failed.
Login failed for user 'WIN-32F61D26AAM\IWPD_103(vmboyaus)'.
I tried this connection string :
<connectionStrings>
<add name="FinalProjectDBEntities"
connectionString="metadata=res://*/Model.Model1.csdl|res://*/Model.Model1.ssdl|res://*/Model.Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=.\MSSQLSERVER2019;user id=vmboyaus;Password=somepassword;Database=FinalProjectDB;initial catalog=FinalProjectDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework""
providerName="System.Data.EntityClient" />
</connectionStrings>
(My Default connection string was :
<connectionStrings>
<add name="FinalProjectDBEntities" connectionString="metadata=res://*/Model.Model1.csdl|res://*/Model.Model1.ssdl|res://*/Model.Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=DESKTOP-VJ3TLVQ\SQLEXPRESS;initial catalog=FinalProjectDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>)
Please I need urgent help !!! (I check my db name, username, password many times, they are fine)
Hi! I am stuck and Can't solve a problem. I've uploaded my ASP.NET MVC database project (Used Entity Framework).
Uploaded my project to Plesk. All the action results without DB works fine. But Database Connection fails. (My original Database is based on Microsoft SQL Server 2019)
Shows the error :
Server Error in '/' Application.
Cannot open database "FinalProjectDB" requested by the login. The login failed.
Login failed for user 'WIN-32F61D26AAM\IWPD_103(vmboyaus)'.
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 "FinalProjectDB" requested by the login. The login failed.
Login failed for user 'WIN-32F61D26AAM\IWPD_103(vmboyaus)'.
I tried this connection string :
<connectionStrings>
<add name="FinalProjectDBEntities"
connectionString="metadata=res://*/Model.Model1.csdl|res://*/Model.Model1.ssdl|res://*/Model.Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=.\MSSQLSERVER2019;user id=vmboyaus;Password=somepassword;Database=FinalProjectDB;initial catalog=FinalProjectDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework""
providerName="System.Data.EntityClient" />
</connectionStrings>
(My Default connection string was :
<connectionStrings>
<add name="FinalProjectDBEntities" connectionString="metadata=res://*/Model.Model1.csdl|res://*/Model.Model1.ssdl|res://*/Model.Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=DESKTOP-VJ3TLVQ\SQLEXPRESS;initial catalog=FinalProjectDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>)
Please I need urgent help !!! (I check my db name, username, password many times, they are fine)