CODEWITHSUNDEEP
sql-serverconnection-stringssms
Borkin
Borkin

Reputation: 23

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

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.

Upvotes: 2

Views: 2743

Answers (1)

Alexei - check Codidact
Alexei - check Codidact

Reputation: 23098

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.

Upvotes: 1

Related Questions