SQL server could not be determined

I have connected to a Web Service, I have developed my code in C#, it debugs fully and recieves an error response, it gets this response from the Web Service - 'The appropriate Local authority SQL server could not be determined'.

There are three responses that are possible to get back from the web service,

Failure - in that it is not connecting to the SQL server (the error I am getting).

Error - Which means it is connected but in an incorrect format or va开发者_StackOverflow社区lues.

Stored - Which is a successful transfer of data (The one I want!) .

What are the possible reasons that the SQL server could not be determined?

Thanks for your time.

---

The specific error message that you reference

the appropriate Local authority SQL server could not be determined

Is not an error message that I am used to seeing, and after a quick search I'm guessing this is a custom error on your side.

There are numerous things that can cause you to not be able to connect to SQL Server. To help point you in the right direction I think we are going to need to see some code.

---

I am guessing here but I would say that the SQL Service is running as a domain user with some sort of restrictions on it. I would change the local SQL service to run as a local user such as the local "system" user, and see if that helps.