How to connect from SSMS to SQL Server database with connectionString="Data Source=ABC..." (instead of localhost)

Question

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.

Community · Accepted Answer · 2017-05-23 12:15:19Z

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.

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Jan 23, 2016 at 9:57

Alexei - check Codidact

23.2k22 gold badges159 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Borkin Over a year ago

Ty Alexei, your answer (with links provided) is completely that I need to know.

Collectives™ on Stack Overflow

How to connect from SSMS to SQL Server database with connectionString="Data Source=ABC..." (instead of localhost)

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related