Sql server name aliases in Windows Azure

Question

I use Management Studio to connect with SQL Azure database. To connect I entered server name in this format, but this name is not user friendly. (When I have many servers I'm confused)

m24*****i.database.windows.net

Is it possible to change this name to more readable or save connection data in any connection manager in ManagementStudio. Is it possible?

Angus Chung · Accepted Answer · 2015-04-07 14:03:54Z

2

You can use SQL Server Configuration Manager to create aliases for your server's name.

Create aliases in the two node of SQL Server Configuration Manager：

1.SQL Native Client 11.0 Configuration\Aliases node

2.SQL Native Client 11.0 Configuration (32bit)\Aliases node

Example

Alias Name：YourAliasName
Port No：1433
Protocol：TCP/IP
Server：m24*****i.database.windows.net

edited Apr 7, 2015 at 14:03

answered Apr 7, 2015 at 13:57

Angus Chung

1,5771 gold badge11 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Sql server name aliases in Windows Azure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related