I have a web app that when run locally runs as intended. Once published to my server it does not. The issue is related to sql's integrated security. The webservice/sql call is using "domain/machinename" as the login, instead of my active directory credentials. There is no sql security login for the sql server I am accessing. How do I get the web service to read my credentials instead of the servers?

it is not always recomended to use win auth, you need to create a user in sql for your app.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.