CODEWITHSUNDEEP
sql-serverssms
Jason
Jason

Reputation: 85

Microsoft SQL Server Management Studio connection alias

I use Microsoft SMS Studio to connect to more than a few servers and I'm having a hard time keeping them straight based on the server name. Is there a way to name these connections?
For example, in my local Connect Object Explorer I want to name my connection to the server "PRDWXORDV001\PRD,56011" as "West Server" and "DPOWRMNL011\DDR,55543" as "Jimmy's Server".

This is trivial in Oracle SQ Developer and MySQL Workbench ("Connection Name" in both) but seemingly impossible in Microsoft SQL Server Management Studio.

Upvotes: 1

Views: 850

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 176104

You could use Registered servers one per connection.

Create a New Registered Server

Registered server name

The name you want to appear in Registered Servers. This name does not have to match the Server name box.

Upvotes: 2

Related Questions