WCF service returns 400 Bad Request

Question

I have this application that works locally both when deploying and using the SQL Express .mdf database file (which I usually use for testing purposes). However, when I change it to work with our SQL Server 2008, the application works, but the service does not work.

For example, if in my code behind the page I have a button that adds data to the table, for example, this works fine:

public static string connString = @"Data Source=server1;Initial Catalog=Project;Integrated Security=True";

protected void btnAddProj_Click(object sender, EventArgs e)
{
    using (var sqlc = new SqlConnection(connString))
    {
        sqlc.Open();
        var cmd = sqlc.CreateCommand();
        int intProjectID;

        // Add the project info to the database
        cmd.CommandText = "INSERT INTO tblProject VALUES(@ProjName,@ProjTeam,@ProjStart,@ProjEnd)";
        cmd.Parameters.Add("ProjName", System.Data.SqlDbType.NVarChar).Value = txtProjName.Text;
        cmd.Parameters.Add("ProjTeam", System.Data.SqlDbType.Int).Value = ddlTeamSupported.SelectedValue;
        cmd.Parameters.Add("ProjStart", System.Data.SqlDbType.NVarChar).Value = txtStartDate.Text;
        cmd.Parameters.Add("ProjEnd", System.Data.SqlDbType.NVarChar).Value = txtEndDate.Text;
        cmd.ExecuteNonQuery();
    }       
}

My web.config is configured to use impersonation on this server, and everything works fine. However, for my service, the request does not seem to return anything, and I get a 400 Bad Request error.

Code for jquery:

$.ajax({
    type: "POST",
    async: false,
    url: "Services/ProjectService.svc/test",
    contentType: "application/json; charset=utf-8",
    dataType: "json",
    success: function (data) {
        console.log(data);
        }
    });

And for the service:

[ServiceContract]
public interface IProjectService
{
    [OperationContract]
    [WebInvoke(ResponseFormat = WebMessageFormat.Json)]
    ArrayList test();
}


    public static string connString = @"Data Source=server1;Initial Catalog=Project;Integrated Security=True";

    public ArrayList test()
    {
        var sqlc = new SqlConnection(connString);
        sqlc.Open();
        var cmd = sqlc.CreateCommand();
        cmd.CommandText = "SELECT ProjectID FROM tblProject";
        var reader = cmd.ExecuteReader();

        ArrayList temparray = new ArrayList();


        while (reader.Read())
        {
            temparray.Add(reader[0]);
        }
        sqlc.Close();
        return temparray;
    }

, , . , , ?

Answer 1

WCF , , . Integrated Security = SSPI , , , , SQL.:)

Answer 2

, HTTP- , , , .

:

• , SvcUtil.exe.
• Fiddler, .
• .
• - .
• HTTP- Fiddler . . , AJAX , , .

Answer 3

, POST, GET.

, POST:

[WebInvoke(Method = "POST", UriTemplate = "", ResponseFormat = WebMessageFormat.Json)]

Another may be that you are using a reliable connection. This means that the security context is the application pool identifier (if the default values ​​are used). Then you will connect to the database using a local account that does not have access to the database on another machine.

The strange thing is that based on the error message this should be the first explanation, but based on your description, this will be the second.