• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Issue Login failed for user 'WIN-32F61D26AAM\IWPD_103(vmboyaus)'. Database connection failed.

mowsum

New Pleskian
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.
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=&quot;data source=.\MSSQLSERVER2019;user id=vmboyaus;Password=somepassword;Database=FinalProjectDB;initial catalog=FinalProjectDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;"
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=&quot;data source=DESKTOP-VJ3TLVQ\SQLEXPRESS;initial catalog=FinalProjectDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>)

Please I need urgent help !!! (I check my db name, username, password many times, they are fine)
 
Back
Top