Cannot open database 'XXX' requested by the login problem

See more:

C#

SQL

Hi,

I've built this little stored procedure peice of code however when I run it it comes up with the error
"Cannot open database "Sales" requested by the login. The login failed Login failed for user 'MASTER\MyName'."
I know for a fact that the code works on another database with diffrent inputs but not this one. Im using the example from this Introducing Distributed Messaging using Service Broker in SQL Server 2005[^] i've just changed the variables slightly and have tried to run the stored procedure through my C# app. In the example it sets

CREATE MASTER KEY
ENCRYPTION BY PASSWORD = 'hellopassword';
GO

I'm not sure if that makes a difference. Anyway below is my C# please help!

SqlConnection conn = null;
          SqlDataReader rdr = null;

          string orderinfo = richTextBox1.Text;

          try
          {
              conn = new SqlConnection(
                  "Server=(local);DataBase=Sales;Integrated Security=SSPI");
              conn.Open();

              SqlCommand cmd = new SqlCommand("runorder", conn);

              cmd.CommandType = CommandType.StoredProcedure;

              cmd.Parameters.Add(new SqlParameter("@order", orderinfo));

              rdr = cmd.ExecuteReader();

          }
          finally
          {
              if (conn != null)
              {
                  conn.Close();
              }
              if (rdr != null)
              {
                  rdr.Close();
              }
          }

P.S Under the user mapping for the security of MASTER\MyName the user is set to 'dbo' and has the permissions of database owner.