{"action":"created","issue":{"url":"https://api.github.com/repos/denisenkom/go-mssqldb/issues/165","repository_url":"https://api.github.com/repos/denisenkom/go-mssqldb","labels_url":"https://api.github.com/repos/denisenkom/go-mssqldb/issues/165/labels{/name}","comments_url":"https://api.github.com/repos/denisenkom/go-mssqldb/issues/165/comments","events_url":"https://api.github.com/repos/denisenkom/go-mssqldb/issues/165/events","html_url":"https://github.com/denisenkom/go-mssqldb/issues/165","id":171896352,"number":165,"title":"Update the readme with SQL Server settings required and provide a better demo program","user":{"login":"RichardChambers","id":11844326,"avatar_url":"https://avatars.githubusercontent.com/u/11844326?v=3","gravatar_id":"","url":"https://api.github.com/users/RichardChambers","html_url":"https://github.com/RichardChambers","followers_url":"https://api.github.com/users/RichardChambers/followers","following_url":"https://api.github.com/users/RichardChambers/following{/other_user}","gists_url":"https://api.github.com/users/RichardChambers/gists{/gist_id}","starred_url":"https://api.github.com/users/RichardChambers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RichardChambers/subscriptions","organizations_url":"https://api.github.com/users/RichardChambers/orgs","repos_url":"https://api.github.com/users/RichardChambers/repos","events_url":"https://api.github.com/users/RichardChambers/events{/privacy}","received_events_url":"https://api.github.com/users/RichardChambers/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-08-18T13:07:10Z","updated_at":"2016-08-23T20:18:37Z","closed_at":null,"body":"Thank you for this SQL Server driver for Go's sql package. While it took me a bit of time to figure out how I could use it in a demo program, I now have something real to do with it.\r\n\r\nWould it be possible to update the readme file with some basic SQL Server configuration settings?\r\n\r\nI put together an answer to a stack overflow question about using this driver to document what I found while working on my demo program. http://stackoverflow.com/questions/32010749/go-with-sql-server-driver-is-unable-to-connect-successfully-login-fail\r\n\r\nPerhaps something like the following.\r\n\r\nThis driver package depends on several settings in the SQL Server configuration.\r\n - TCP must be enabled in the profile displayed in SQL Server Configuration Manager\r\n - SQL Server Authentication must be enabled along with Windows Authentication\r\n - the SQL Server user must exist and have the proper permissions set in SQL Server\r\n\r\nAnd could a demo program such as the one I provided in the stack overflow answer be provided that shows a bit more complexity? Comments in the source code of the example would be great as well.\r\n\r\nI raise the question because I spent a lot of time trying to piece together my prototype from various bits and pieces of information scattered about with none of them giving me a reasonably complete picture of a sample application and the SQL Server settings required to make it work."},"comment":{"url":"https://api.github.com/repos/denisenkom/go-mssqldb/issues/comments/241863314","html_url":"https://github.com/denisenkom/go-mssqldb/issues/165#issuecomment-241863314","issue_url":"https://api.github.com/repos/denisenkom/go-mssqldb/issues/165","id":241863314,"user":{"login":"RichardChambers","id":11844326,"avatar_url":"https://avatars.githubusercontent.com/u/11844326?v=3","gravatar_id":"","url":"https://api.github.com/users/RichardChambers","html_url":"https://github.com/RichardChambers","followers_url":"https://api.github.com/users/RichardChambers/followers","following_url":"https://api.github.com/users/RichardChambers/following{/other_user}","gists_url":"https://api.github.com/users/RichardChambers/gists{/gist_id}","starred_url":"https://api.github.com/users/RichardChambers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RichardChambers/subscriptions","organizations_url":"https://api.github.com/users/RichardChambers/orgs","repos_url":"https://api.github.com/users/RichardChambers/repos","events_url":"https://api.github.com/users/RichardChambers/events{/privacy}","received_events_url":"https://api.github.com/users/RichardChambers/received_events","type":"User","site_admin":false},"created_at":"2016-08-23T20:18:37Z","updated_at":"2016-08-23T20:18:37Z","body":"An additional thing that I discovered by accident is that to use Windows Authentication you must specify a domain name with the user id. If you do not specify a domain name then the behavior is to use SQL Server Authentication.\r\n\r\nFor example \"user id=domain\\\\usrname;password=usr_pw;\" or if you want to use the local domain or a local PC Windows user \"user id=\\\\usrname;password=usr_pw;\" that is without the actual domain name specified but with the leading slash on the user name.\r\n\r\nI have yet to find out how to use Windows Authentication with the current user and password so that an actual user name and password would not need to be specified."}}
{"actor":{"display_login":"RichardChambers"}}