{"action":"created","issue":{"url":"https://api.github.com/repos/cvent/octopus-deploy-cookbook/issues/105","repository_url":"https://api.github.com/repos/cvent/octopus-deploy-cookbook","labels_url":"https://api.github.com/repos/cvent/octopus-deploy-cookbook/issues/105/labels{/name}","comments_url":"https://api.github.com/repos/cvent/octopus-deploy-cookbook/issues/105/comments","events_url":"https://api.github.com/repos/cvent/octopus-deploy-cookbook/issues/105/events","html_url":"https://github.com/cvent/octopus-deploy-cookbook/issues/105","id":259329312,"number":105,"title":"Document database assumptions for server","user":{"login":"spuder","id":242382,"avatar_url":"https://avatars3.githubusercontent.com/u/242382?v=4","gravatar_id":"","url":"https://api.github.com/users/spuder","html_url":"https://github.com/spuder","followers_url":"https://api.github.com/users/spuder/followers","following_url":"https://api.github.com/users/spuder/following{/other_user}","gists_url":"https://api.github.com/users/spuder/gists{/gist_id}","starred_url":"https://api.github.com/users/spuder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spuder/subscriptions","organizations_url":"https://api.github.com/users/spuder/orgs","repos_url":"https://api.github.com/users/spuder/repos","events_url":"https://api.github.com/users/spuder/events{/privacy}","received_events_url":"https://api.github.com/users/spuder/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-09-20T23:11:36Z","updated_at":"2017-09-28T22:16:15Z","closed_at":"2017-09-28T22:16:15Z","author_association":"CONTRIBUTOR","body":"I'm a bit confused on how the database is set up. The readme shows that you can use `create_database` property to setup the database, but it assumes a database sever is already installed. \r\n\r\nLooking at appvoyer and travis, I don't see how you are testing the octopus server. The connection string is\r\n\r\n    'Data Source=localhostdba;Initial Catalog=octo;Integrated Security=False;User ID=octo;Password=password'\r\n\r\nYet nowhere is sql installed. Are you using a golden image with sql express already installed? I can't get the server cookbook to converge without an actual database to point to. "},"comment":{"url":"https://api.github.com/repos/cvent/octopus-deploy-cookbook/issues/comments/332979079","html_url":"https://github.com/cvent/octopus-deploy-cookbook/issues/105#issuecomment-332979079","issue_url":"https://api.github.com/repos/cvent/octopus-deploy-cookbook/issues/105","id":332979079,"user":{"login":"spuder","id":242382,"avatar_url":"https://avatars3.githubusercontent.com/u/242382?v=4","gravatar_id":"","url":"https://api.github.com/users/spuder","html_url":"https://github.com/spuder","followers_url":"https://api.github.com/users/spuder/followers","following_url":"https://api.github.com/users/spuder/following{/other_user}","gists_url":"https://api.github.com/users/spuder/gists{/gist_id}","starred_url":"https://api.github.com/users/spuder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spuder/subscriptions","organizations_url":"https://api.github.com/users/spuder/orgs","repos_url":"https://api.github.com/users/spuder/repos","events_url":"https://api.github.com/users/spuder/events{/privacy}","received_events_url":"https://api.github.com/users/spuder/received_events","type":"User","site_admin":false},"created_at":"2017-09-28T22:16:15Z","updated_at":"2017-09-28T22:16:15Z","author_association":"CONTRIBUTOR","body":"AppVoyer now connects to a database\r\n\r\nhttps://github.com/cvent/octopus-deploy-cookbook/commit/32a78cc03824062031bbef147f2397afc856730d\r\n\r\nThe connection string I've had luck with\r\n\r\n```ruby\r\nconnection_string \"Server=(local)\\\\SQLEXPRESS;Database=FOOBAR;Trusted_Connection=True\"\r\n```\r\n\r\n"}}
{"actor":{"display_login":"spuder"}}