I need install and use SQL Server 2017 Express Edition.
I downloaded it from this link: Microsoft® SQL Server® 2017 Express and installed basic version to
C:\Program Files\Microsoft SQL Server.
I can run it and have access to
http://localhost, but I should use
http://127.0.0.1. And when I use http://127.0.0.1. I see the following:
Bad Request - Invalid Hostname HTTP Error 400. The request hostname is invalid.
I tried to edit my
hosts. I went to
hosts and uncomment the following line:
# Copyright (c) 1993-2009 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be inserted on individual # lines or following the machine name denoted by a '#' symbol. # # For example: # # 126.96.36.199 rhino.acme.com # source server # 188.8.131.52 x.acme.com # x client host # localhost name resolution is handled within DNS itself. 127.0.0.1 localhost # ::1 localhost
But it has no effect. I have access to
localhost, but hasn't on
127.0.0.1. The bad request.
I tried a reboot.
What am I missing?
Windows 10 Pro 64 Visual Studio 2017 SQL Server 2017 Express Edition 14.0.1000.169, RTM