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
One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.