title: Accessing SQL Server from Console application
body: <p>I have a simple Console Application which connects to SQL Server database.
  However it throws the following error while running. Any clues?</p>
  
  <pre><code>Unhandled Exception: System.Data.SqlClient.SqlException: Cannot open database "Database" requested by the login. The login failed.
  Login failed for user 'MYDOMAIN\MYUSERID'.
     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
     at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
     at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, BooleanignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
     at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
  </code></pre>
  
  <p>I use SQL Server 2005 Express Edition.
  However I am able to connect to SQL Server from Visual Web developer using Database Explorer.
  The code I used is given below:</p>
  
  <pre><code>using System;
  using System.Data;
  using System.Data.SqlClient;
  
      public class Test
      {
          public Test()
          {
  
          }
          static void Main()
          {
              Console.WriteLine("hello");
              string connectionString = "Data Source=localhost\\SQLEXPRESS;Database=Database;Integrated Security=true";
              SqlConnection conn = new SqlConnection(connectionString);
              conn.Open();
              Console.WriteLine("done");
          }
      }
  </code></pre>