Allow remote machine access SQL Server
Common pitfall is cannot allow other machine access DB on my local SQL Server.
In .NET world, we used to use namepipe in connection string to the database. We have to allow namepipe in SQL Server Configuration Manager:
- Enable the Namepipe and TCP/IP protocol
- Restart the SQL Server service to take effect