Existing stand-alone web application executed within MS Teams does not access data in MS Sql Server.

Question

I am new with MS Teams development, I have a .NET web application. It has a page for user to enter user id and password that application sends to the backend to compare against a user table in MS Sql Server that lives on premises. When user is authenticated, the user is allowed to access dynamic forms to perform CRUD functions. I was wondering if I can integrate the application into MS Teams, that is, if I can run it in the MS Teams environment, either desktop or browser. I created a Teams app using App Studio and while at first it seemed like it is working, as it launches the web app and renders default.aspx page and the authentication page when the logon link in the default.aspx page is selected. However, once the user enters the user id and password and submits for authentication, form just posts back to itself clearing the user id and password values. All this is in development so I use ngrok services to tunnel into the local host. The web application works well if I run it in a browser, but I want it to work in MS Teams environment. I've looked everywhere and even tried registering the web app in AAD but cannot get the web app to go past the logon screen. I have the free tools from Microsoft (VS 2019 Community, MS Sql Server 2019 Developer, MS Teams, 365 Developer subscription) in an attempt to learn these technologies on my own as work does not provide training to all, despite the fact we are a Microsoft shop. 

Anyway, any and all help will be greatly appreciated!

Thank you,

Feruis

Answer 1

Hi Feruis,

Frankly speaking, our forum support team generally handles Teams feature questions and functional troubleshooting issues. We are not a dedicated development team, for your question, we suggest you redirect to Microsoft GitHub community. And maybe this article can help you a little: GitHub - pnp/teams-dev-samples: Microsoft Teams sample applications and related content

We truly appreciate your kind understanding.

Best Regards,

Linda

Answer 2

Thank you Linda for pointing me to the right direction.

Feruis