Re: How to deploy a DB-using Webservice to a shared server??
From: Dale (daleDeletepres_at_msndotcomNot.Net)
Date: 07/21/04
- Next message: Mullin Yu: "can i set the cool-down time"
- Previous message: Dale: "Re: Getting through firewalls using HttpWebRequest"
- In reply to: PocketDeveloper: "How to deploy a DB-using Webservice to a shared server??"
- Next in thread: PocketDeveloper: "Re: How to deploy a DB-using Webservice to a shared server??"
- Reply: PocketDeveloper: "Re: How to deploy a DB-using Webservice to a shared server??"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 20:53:20 -0500
In the web.config of the app calling the service, add an identity element:
<identity impersonate="true">.
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.Credentials = System.Net.CredentialCache.DefaultCredentials;
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
"PocketDeveloper" <ggalen@mn.rr.com> wrote in message
news:41280774.0407191233.92a046a@posting.google.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.
- Next message: Mullin Yu: "can i set the cool-down time"
- Previous message: Dale: "Re: Getting through firewalls using HttpWebRequest"
- In reply to: PocketDeveloper: "How to deploy a DB-using Webservice to a shared server??"
- Next in thread: PocketDeveloper: "Re: How to deploy a DB-using Webservice to a shared server??"
- Reply: PocketDeveloper: "Re: How to deploy a DB-using Webservice to a shared server??"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
