tags:

views:

14

answers:

1
Q: 

How to change authentication from SQL Server to windows in VB.NET Webservice(SQL Server)

Web service uses SQL Server based authentication how to change to windows based authentication both web server & Database service resides in different domain .

+2  A: 

Change your ConnectionString to use Integrated Security=true;

Ardman  2010-08-20 09:15:02
did the following but still doesn't work not familiar with windows authentication. 1)In Windows Server created user DomainA\UserA and added to GroupA 2)IIS configured with Windows authentication but runs in DomainB 3)SQL Server 2008 configured to allow windows authentication. and created login with DomainA\GroupA –
BMG  2010-08-21 05:05:41
BMG  2010-08-21 05:11:09
What version of IIS are you using?
Ardman  2010-08-21 08:09:48
IIS6 runs on windows server 2003
BMG  2010-08-21 23:32:06

related questions

Displaying Version Information in a Web Service
Example Web Service
SoapException: Root element is missing occurs when .NET web service called from Flex
Best practice for webservices
What is your preferred method of sending complex data over a web service?
.Net - Returning DataTables in WCF
Is it possible to return objects from a WebService?
How much extra overhead is generated when sending a file over a web service as a byte array?
Returning Large Results Via a Webservice
File Uploads via Web Services
best way to persist data in .NET Web Service
What is the difference between an endpoint, a service, and a port when working with webservices?
Calling REST web services from a classic asp page
Best way to write a RESTful service "client" in .Net?
Where can I find some good WS-Security introductions and tutorials?
ASP.NET Web Service Results, Proxy Classes and Type Conversion
Web Services -- WCF vs. Standard
C# WCF Service - Backward compatibility issue
Document or RPC based web services
How to easily consume a web service from PHP
Timer-based event triggers
How to pass enumerated values to a web service
Homegrown consumption of web services
How do I print an HTML document from a web service?
How do I fill a DataSet or a DataTable from a LINQ query resultset ?