2

Help me please to understand, what does it mean "ABC" in:

connectionString="Data Source=ABC;Initial Catalog=xyz; User ID=***; Password=***;"

How to connect to this SQL Server database using SSMS from another Windows computer? It's no trouble for me to connect to other databases with "Data Source=localhost", but "Data Source=ABC" puzzles me.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Borkin
  • 23
  • 3

1 Answers1

1

Data Source represents the instance name. If SQL Server is installed as default instance, the hostname alone is enough. If it is installed as a named instance, hostname\instancename should be provided.

If instance is running using a different port that the default one (1433), the port number should be provided.

More details can be found here and here.

Community
  • 1
  • 1
Alexei - check Codidact
  • 22,016
  • 16
  • 145
  • 164