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 Services tool

Hello,
I was curious if anyone knows of a tool that can
1. Catalog/Document what web services are running on a server.
2. Catalog/Document method sigs, parms, references for each service
Thanks in advance
--
Rob SchieberHello Rob,
I believe Disco.exe (comes with Visual Studio) will do that for you:
disco.exe -
Utility to discover the URLs of xml web services located on a web server
and to save documents related to that xml web service on the local disk.
The results.discomap, .wsdl and .xsd files produced by this tool can be
used with wsdl.exe to produce web service clients and abstract web service
servers using ASP.NET.
brians
http://www.limbertech.com
"Rob Schieber" wrote:

> Hello,
> I was curious if anyone knows of a tool that can
> 1. Catalog/Document what web services are running on a server.
> 2. Catalog/Document method sigs, parms, references for each service
> Thanks in advance
> --
> Rob Schieber
>
brians[MCSD] wrote:
> Hello Rob,
> I believe Disco.exe (comes with Visual Studio) will do that for you:
> disco.exe -
> Utility to discover the URLs of xml web services located on a web serv
er
> and to save documents related to that xml web service on the local dis
k.
> The results.discomap, .wsdl and .xsd files produced by this tool can b
e
> used with wsdl.exe to produce web service clients and abstract web ser
vice
> servers using ASP.NET.
>
Thanks Brian,
I'll give that a try.
?t-

Web Services tool

Hello,

I was curious if anyone knows of a tool that can
1. Catalog/Document what web services are running on a server.
2. Catalog/Document method sigs, parms, references for each service

Thanks in advance
--
Rob SchieberHello Rob,

I believe Disco.exe (comes with Visual Studio) will do that for you:

disco.exe -
Utility to discover the URLs of xml web services located on a web server
and to save documents related to that xml web service on the local disk.
The results.discomap, .wsdl and .xsd files produced by this tool can be
used with wsdl.exe to produce web service clients and abstract web service
servers using ASP.NET.

--
brians
http://www.limbertech.com

"Rob Schieber" wrote:

> Hello,
> I was curious if anyone knows of a tool that can
> 1. Catalog/Document what web services are running on a server.
> 2. Catalog/Document method sigs, parms, references for each service
> Thanks in advance
> --
> Rob Schieber
brians[MCSD] wrote:
> Hello Rob,
> I believe Disco.exe (comes with Visual Studio) will do that for you:
> disco.exe -
> Utility to discover the URLs of xml web services located on a web server
> and to save documents related to that xml web service on the local disk.
> The results.discomap, .wsdl and .xsd files produced by this tool can be
> used with wsdl.exe to produce web service clients and abstract web service
> servers using ASP.NET.
Thanks Brian,

I'll give that a try.

--
?t-