how to share database between computer in local area network
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.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Selva GanapathyPosted Dec 15, 2014, 4:01 AM
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 PowarPosted Dec 13, 2014, 4:03 AM
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.