Open the SQL Server Configuration Manager , navigate to SQL Server Network Configuration -> Protocols for SQLEXPRESS , right-click TCP/IP , and select Enable .
To obtain the offline installer, follow these steps on a machine that has internet access:
Double-click the standalone executable on your destination server to extract the setup files into a temporary directory.
But wait – that filename still looks like an executable. Double-check the file size. If it says , it's still a bootstrapper. The real offline media is larger.