Dear All,

its that possible connect to sql server using windows authentication in different PC?

I want create web service that other people can use it.

but i only have 1 windows username.

How that i can connect my web service using that username and my web service can access from the other user?

I have tried this code:

"Database=Banana;Data Source=Minions;Integrated Security=SSPI;"

with this code i only can access with my own computer.

best regards,

Surbakti

• Moved by Jack-ZhaiMicrosoft contingent staff 1 hour 23 minutes ago move to a more appropriate forum

Hi Surbakti,

This forum is about Visual Studio IDE, as your issue is about how to connect SQL Server using windows authentication, Im afraid it is not related to Visual Studio IDE, it would be related to SQL Server Data Access, I help you move this case to SQL Server Data Access Forum for dedicated support: https://social.technet.microsoft.com/Forums/en-US/home?forum=sqldataaccess

Best Regards,

Jiayi Li

its that possible connect to sql server using windows authentication in different PC?

Hello Surbakti,

Of course this is possible, but only if both machine/logins are member of the same domain or at least of 2 trusted domains.

Which issues are you facing, which error message are you getting?