Can't Connect to Local SQl Server instance

seanpbrown

Hello,

I recently downloaded deployment manager starter edition to see if it is something that we want to use. I installed it locally, and am trying to add a local sql server instance as a target. I keep getting an error "System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'svc_Deployment'". Sounds like I didn't set up the user correctly in the local db, but I set up the exact same user on one of our actual development servers, and I can connect to that server just fine. It seems like maybe there is something different about pointing deployment manager to a local db that I am not getting. The only thing I noticed in the requirements page is I needed to turn on named pipes on the local db. ALso, I have not installed agents on either of my db instances. Thanks!

chirayu

Which requirements page asked you to turn on named pipes for your local db? There is nothing different that you have to do to try to connect to do a local db.

Steps below show how I created a new user in my SQL Server local instance and connected to it via DM.

In SSMS, at the root level click on Security->Logins-> right-click to create new login and you are shown this pop up:


Then in Deployment Manager Environments page add a SQL Server target like so:


Health check succeeds for me. Could you let me know what you are doing different? If it still fails for you please do a manual health check (Environments -> Check health) and paste the log in this conversation. Thanks!