In the SQL Server Configuration Manager (SSCM) enable the Remote Connections Option
Under the SQL Native Client Configuration enable TCP/IP protocol (see Figure below)

Welcome to VBA Tips & Tricks. All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too Happy reading