How to deploy a DB-using Webservice to a shared server??

[PocketDeveloper]

I am an experienced developer...but a novice at creating web services,
so please have mercy on me!

Here is my question: I developed a fairly simple Webservice that
returns a table from SQL Server.

It runs great on my development machine. Now, I must deploy it to my
website. My website is on a shared server holding lots of websites.

The websoervice will not run there. It cannot read my SQL Server
database that I have on the shared server. I do not want to pass in an
unencrypted username and password in the connection string.

The "technical support" is of no use. Seeing the Webservice
description page come up when they type in the asmx, they say "But
it's working fine!"

Can those of you with more experience tell me how you deploy a
webservice that uses SQL Server to a shared server?

Any web resources thay will tell me this? Microsoft documentation is
so THICK with detail I cannot find out what I want to know.

Thanks for any help telling me how YOU do it.

[Dale]

In the web.config of the app calling the service, add an identity element:
<identity impersonate="tr ue">.

Make sure that anonymous access is turned off and basic authentication is
off. Set the IIS app to use Windows authentication.

In your app that calls the web service, add:

myService.Crede ntials = System.Net.Cred entialCache.Def aultCredentials ;

With those three steps completed.... if your server isn't on a cluster!!!,
then your web service will have the correct identity object for windows
authentication to the SQL server with one last condition. If the SQL Server
is on the same machine as the web service! If they're on separate machines,
you're stuck with either authorizing the IIS service account to access the
SQL database, or passing a username and password in your connection string.

Dale

"PocketDevelope r" <gg****@mn.rr.c om> wrote in message
news:41******** *************** **@posting.goog le.com...

I am an experienced developer...but a novice at creating web services,
so please have mercy on me!

Here is my question: I developed a fairly simple Webservice that
returns a table from SQL Server.

It runs great on my development machine. Now, I must deploy it to my
website. My website is on a shared server holding lots of websites.

The websoervice will not run there. It cannot read my SQL Server
database that I have on the shared server. I do not want to pass in an
unencrypted username and password in the connection string.

The "technical support" is of no use. Seeing the Webservice
description page come up when they type in the asmx, they say "But
it's working fine!"

Can those of you with more experience tell me how you deploy a
webservice that uses SQL Server to a shared server?

Any web resources thay will tell me this? Microsoft documentation is
so THICK with detail I cannot find out what I want to know.

Thanks for any help telling me how YOU do it.

[PocketDeveloper]

"Dale" <da************ @msndotcomNot.N et> wrote in message news:<e2******* *******@tk2msft ngp13.phx.gbl>. ..

Thanks, Dale. Well, it IS complex I see. I'm glad it wasn't me being
dumb...it's a complicated situation when you have data access and a
SQL Server security to deeal with as well..

In the web.config of the app calling the service, add an identity element:
<identity impersonate="tr ue">.

Make sure that anonymous access is turned off and basic authentication is
off. Set the IIS app to use Windows authentication.

In your app that calls the web service, add:

myService.Crede ntials = System.Net.Cred entialCache.Def aultCredentials ;

With those three steps completed.... if your server isn't on a cluster!!!,
then your web service will have the correct identity object for windows
authentication to the SQL server with one last condition. If the SQL Server
is on the same machine as the web service! If they're on separate machines,
you're stuck with either authorizing the IIS service account to access the
SQL database, or passing a username and password in your connection string.

Dale