how to share database between computer in local area network

Question

how to share database between computer in local area network. How do i get access the databse in one computer from other computer in lan.

Selva Ganapathy · Answer

Hi Rahul you can simple made it by sharing folder option like the way keep you database folder in a drive/ folder Share it by its property with all permission set while referring the data base through an application use IP address or the computer name and full directory path as path Regards Selva Ganapathy K

Ranjit Powar · Answer

First enable Sqlsever and windows authentication mode from management studio. The enable TCPIP protocol from Sqlserver configuration manager. Then in connection string give the name of pc where sql server is installed as data source. And set integrated security false.