Installed Sql server on a remote machine. I want to add an entity model to the project, select from database, click to create a new connection, select a provider and open a window in which you need to enter the server name.

enter image description here

All the tutorials that I found, connected to the local sql, what to write there to connect the server to a remote machine?

  • Try entering the server name in the Server Name field :) - PashaPash
  • @PashaPash, how was this supposed to help? It gives an error that it does not find such a server, because it is not on the local machine. - anweledig
  • You, probably, somehow not so an error message interpret. Bring him in question, along with the server name you entered. - PashaPash
  • @PashaPash, here is a screenshot of the error with the name of the server that, I repeat, on the remote machine! i.imgur.com/XTRnpcT.png - anweledig
  • Specify the адрес\название instance, not just the name. - Monk

1 answer 1

The problem was more prosaic than I thought. When creating the sql instance, it was necessary to specify a password, while the standard login was sa , which I did not have time to see confirming the settings. Then I created other users, but for some reason I could only log in with the sa login and the password I specified at the very beginning.