Problem with connecting with the database RRS feed

  • Question

  • User271867911 posted

    I have installed sql server 2012 in my machine. I  have SA account which works fine with sql server management studio.

    But when i try to login from the same user SA in my application server explorer. I am getting error Login failed with the User SA

    In Server Explorer Trying to connect from uses SA

    I get the Login Failed with User SA Error Please See Image


    When I login from SQL Server Management Studio It works fine.

    Where is the problem



    Additionally I am using the connection string as below

    <add name="StudentManagementEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.;initial catalog=StudentManagement;user id=sa;password=abc12345;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />


    The password i used is the same for sa user which i used in sql server managment studio and it works fine there;

    Wednesday, March 15, 2017 1:34 AM


  • User-2057865890 posted

    Hi Farooqspecials,

    In SQL Server Management Studio, run this query to get the name


    then change data source in connection string

    data source= " name "

    Best Regards,


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, March 15, 2017 7:01 AM