title: Go with SQL Server driver is unable to connect successfully, login fail
body: <p>I am trying to use Microsoft SQL Server with a Go program to connect to a database in SQL server and read some data from the database.</p>
  
  <p>However when I use <code>err=db.ping()</code> it causes an error which says: </p>
  
  <blockquote>
    <p>login failed for user 'sakhaloo'</p>
  </blockquote>
  
  <p>I downloaded the zip file of the driver package from this directory: <code>github.com/denisenkom/go-mssqldb</code> then I copy the files within the zipped file and paste them in the following address : <code>C:\Go\src\github.com\denisenkom\go-mssqldb</code> </p>
  
  <p>Another problem is when I try to open my SQL database with SQL Server 2014 Management Studio it doesn't accept my user name or password, actually it causes this error when I enter my username and password: </p>
  
  <blockquote>
    <p>A connection was successfully established with the server, but then an
    error occurred during the login process. (provider: Shared Memory
    Provider, error: 0-no process is on the other end of the
    pipe.)(Microsoft SQL Server, Error:233)</p>
  </blockquote>
  
  <p>i don't know what is wrong with all this process.</p>
  
  <p>This is my code:</p>
  
  <pre><code>package main
  import (
     //_ "code.google.com/p/odbc"
      _ "github.com/denisenkom/go-mssqldb"
      "database/sql"
      "fmt"
      "log"
      //"github.com/astaxie/beedb"
     // "github.com/weigj/go-odbc"
  )
  
  var (
      uName, pass string
      p *Person
  )
  
  type Person struct {
      userName string
      passWord string
      Email string
  }
  
  func main() {
      db, err := sql.Open("mssql", "server=SAKHALOO-PC;user id=sakhaloo;password=hoollehayerazi;database=webApp" )
      if err != nil {
          log.Fatal(err) 
      }
      defer db.Close()
      err = db.Ping()
      if err != nil {
          log.Fatal(err)
      }
      fmt.Println("Please enter your full name &amp; password:")
      fmt.Scanln(&amp;uName, &amp;pass)
      row := db.QueryRow("SELECT username, password, email FROM user WHERE username=? and password=?", uName, pass)
      fmt.Println(row)
      p := new(Person)
      err = row.Scan(&amp;p.userName, &amp;p.passWord, &amp;p.Email)
      fmt.Printf("%s , %s , %s \n", p.userName, p.passWord, p.Email)
      fmt.Printf("Hi %s, your email address is : %s", uName, p.Email)
  }
  </code></pre>