Hi there

I have this weird problem. I created a Web Service that extracts data from the SQL Server and then return it as a XML document.

The problem is when the Web Service gets to the code to open the Connection to the server it gives this error.

System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.


Now my Win32 application works just fine, using the same code. Thus I believe the problem might be the settings of IIS.

But unfortunately I don't even know where to start looking.

Some help would really be appreciated.

Thanx in advance