无法连接到MS SQL

Question

I'm playing around with Golang and trying to connect to MS SQL. I'm using github.com/denisenkom/go-mssqldb package and sqlx for this purpose. But I'm getting error: Unable to open tcp connection with host 'localhost:1433': dial tcp [::1]:1433: connectex: No connection could be made because the target machine actively refused it.
I'm completely sure that everything with database itself since it's perfectly working with my.Net project. Here is is the code:

package main

import (
    "database/sql"
    "fmt"
    "log"

    _ "github.com/denisenkom/go-mssqldb"
    "github.com/jmoiron/sqlx"
)

type Excursion struct {
    Id   int            `db:"id"`
    Name sql.NullString `db:"name"`
}

func main() {
    db, err := sqlx.Connect("sqlserver", "server=localhost;user id=DESKTOP-H74S9IT\\andrey.shedko;database=Flex;connection timeout=30;")
    if err := db.Ping(); err != nil {
        log.Fatal(err)
    }
    rows, err := db.Queryx("SELECT Id, Name FROM dbo.Excursions")
    for rows.Next() {
        var item Excursion
        err = rows.StructScan(&item)
        if err != nil {
            log.Fatal(err)
        }
        fmt.Printf(
            "%d - %s:  %s
===================
",
            item.Id,
            item.Name.String,
        )
    }
    defer db.Close()
}

Could you advice please what is wrong with this?

Answer 1

Probably you need to activate TCP.

More info: Enable TCP/IP Network Protocol for SQL Server

^{Images source: https://docs.microsoft.com/en-us/azure/includes/media/virtual-machines-sql-server-connection-tcp-protocol/enable-tcp.png and https://docs.microsoft.com/en-us/azure/includes/media/virtual-machines-sql-server-connection-tcp-protocol/restart-sql-server.png}