C# SQL Server Connection Issue

Question

I am having problems connecting to a SQL Server database from C#.

The exception that returns is the login has failed for the specified user, which is clear enough. However, I am not sure why it fails as the username and password are definitely correct. Are there any settings I need to enable on the SQL Server to allow this to happen, as it is a default express install,

Thanks,

Below is my connection code if I'm missing anything obvious.

static void Main(string[] args) {
    try
    {
        SqlConnection con = new SqlConnection(@"Data Source = .\SQLEXPRESS;Initial Catalog=furniture_display;User ID=login;Password=login");
        con.Open();
        Console.WriteLine("all ok");
        con.Close();
    }
    catch (SqlException err)
    {
        Console.WriteLine(err);
    }
}

Answer 1

According to your code Data Source = .\SQLEXPRESS, you'r trying to connect to a local server. If so you don't need any ID and Password. And be aware of using Catalog, it's somehow tricky and I hate it. To know how it's working, check this out.

Actually I'm using this code and it works like a charm:

SqlConnection con = new SqlConnection(@"Server = localhost; Database = furniture_display; Integrated Security=True;");