Hello,
To Answer your question if the machines are connected internally through LAN it is possible.
Just host the application in one machine through IIS Refer this
How To Deploy a Web App in IIS
Copy the path..distribute to other machines and check the Intranet accessibility.
For Sql server connection :
Pls provide access to other users to the database and check the accessibility from other machines .
eg:)
- Create user windows Authentication
CREATE LOGIN [YourDomainName] FROM WINDOWS
WITH DEFAULT_DATABASE = [YourDatabase];
GO
USE YourDatabaseHere;
CREATE USER X FOR LOGIN [YourDomainNameJohnJacobs];
EXEC sp_addrolemember 'db_datareader', 'X'
EXEC sp_addrolemember 'db_datawriter', 'X'
Go
CREATE LOGIN X WITH PASSWORD = 'X'
,DEFAULT_DATABASE = [YourDatabase]
GO
USE YourDatabaseHere;
CREATE USER X FOR LOGIN X;
EXEC sp_addrolemember 'db_datareader', 'X'
EXEC sp_addrolemember 'db_datawriter', 'X'
GO
For your query for connectionstring:In the Web.config pls code like this
<connectionStrings>
<add name="yourconnectionstring" connectionString="Data Source=yourserverName\SQLEXPRESS;Initial Catalog=yourDatabaseName;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>
Wala!Your work is complete!
Pls write back if you need more support:)