Web Service & SQL Server Authentication

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 advanceIf you are trying to open a connection via sql server authentication (note: not windows), you need to grant access to that account in your db. If you are using windows authentication, you need to grant access to the asp.net account.
Sorry misread

Web Service and Flash 5

I have been asked to write my first web service to extract a number of records from an access database.

Creating a web service which extracts records isn't a problem but if the client application is a flash site then how can it make use of the dataset from the web service.

Does Flash support .net ?Yes, but not in the way you want to use it. .Net can render out OBJECT tags to a client browser, in which flash directives for the Flash plugin live. But, you don't want that. You want to get information from a .Net webservice (could be a Java webservice).

To do that, you need to use SOAP.

Flash supports XML documents though and that's all that is needed to communicate with a SOAP protocol like a .Net webservice.
http://www.flash-db.com/Translate/TranslateClient.php?page=1