Hi dis081278,
>>Is there a way that I can build an application which allows these hospital systems to install my software on hospital desktop computers but use the hospital system's 1.) domain accounts to login, and 2.) use the hospital system's own SQL server to
store patient data.
SQL Server provides an authentication method called Windows Authentication, it allows people using the Windows account (in your scenario, the domain account) to login to SQL Server. However, we need to add these domain accounts to SQL Server (in your scenario,
the hospital system's own SQL server).
After that, after we set the connection string (using Windows authentication) for these application, the application on the Windows will use the account of the Windows to login to SQL Server.
Here is a demo using asp.net as an example, please refer to it: https://www.codeguru.com/csharp/.net/net_security/authentication/article.php/c7725/How-to-Use-Windows-Authentication-to-Access-SQL-Server-Through-a-ASPNET-Web-Application.htm
Best Regards,
Teige
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.