how to use SQL Server in Web Service?

I'm building a web service which needs check the SQL Server. Now, I finished the code for SQL Server. Everything is ok if it is a windows form application. I simply copied the code to a function in the Web Service, however, it reports error when I invoke the service function. Where can I find some examples like that?

thanks

Do you have a description of the error message?

Are you using an integrated security connection string? - in a windows app it would be the client credentials, but on the server it would be who ever is logged into the server so those permissions might not be set in SQL Server.

Quote:

---

Originally posted by VBCrazyCoder
Do you have a description of the error message?

Are you using an integrated security connection string? - in a windows app it would be the client credentials, but on the server it would be who ever is logged into the server so those permissions might not be set in SQL Server.

---

these are two strings I tried:

Dim SqlPubsConnString As String = "Data Source=.;" _
& "Integrated Security=SSPI;Initial Catalog=pubs"
Dim SqlPubsConnString As String = "Data Source=(local);" _
& "User ID=sa;Initial Catalog=pubs"
both failed when I open the connection.

the SQL Server is on local machine.

thx