User-1174608757 posted
Hi RoboDent,
According to your description, could you please tell me that whether these two applications are on the same server?
If they are on same sever, you could directly add connecting string for different application.You could add connection string in the web.config file of web application which you could see as below:
<connectionStrings>
<add name="mssqlserver" connectionString="Data Source=(localdb)\xxxx;Initial Catalog=Mydatabase;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
Else ,if this two web applications are in different servers.One way you could try is that connecting to server to realize a remote connection.You could follow the links as below:
https://blogs.msdn.microsoft.com/sqlexpress/2005/05/05/how-to-configure-express-to-accept-remote-connections/
What's more , you could also create a WebApI for sharing database connection for different server. Here is the link for how to create a Web Api for database.
https://medium.com/@maheshi.gunarathne1994/building-a-restful-api-with-asp-net-web-api-and-sql-server-ce7873d5b331
Best Regards
Wei