the problem I am having is connecting to an account on my sql server (2005) from an ASP.NET application.

Ive tried using the default sa login and users ive created already also the setting of the sql management studio are set to mixed properties, I have the string connection in the webconfig as well but also doesnt work.

c# code

```
    //string conStr = ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString;
    string conStr = @"server=JAMES-PC\SQLEXPRESS; database=projectDB; uid=james; password=password;";
    string query = "SELECT [TaskID], [Task], [Start Date] AS Start_Date, [End Date] AS End_Date, [Priority], [Time Allowance] AS Time_Allowance, [Details], [Catagory] FROM [schedulerData0]";
    SqlDataAdapter dataAdapt = new SqlDataAdapter(query, conStr);
    DataTable table = new DataTable();
    dataAdapt.Fill(table);
    GridView1.DataSource = table;
    GridView1.DataBind();

```

The error message I receive is:

Login failed for user 'james'. The user is not associated with a trusted SQL Server connection.

Any help appreciated
James