MSDN states that there are 4 steps in creating a server alias:
- In SQL Server Configuration Manager, expand SQL Server Native Client Configuration, right-click Aliases, and then click New Alias.
- In the Alias Name box, type the name of the alias. Client applications use this name when they connect.
- In the Server box, type the name or IP address of a server. For a named instance append the instance name.
- In the Protocol box, select the protocol used for this alias. Selecting a protocol, changes the title of the optional properties box to Port No, Pipe Name, or Connection String.
But instead of doing it the "UI way", is there a SQL command to do it?
2条答案
按热度按时间qlzsbp2j1#
The configuration of server aliases for clients is a client configuration rather than a SQL server configuration. As such there's no SQL command to create one, much the same as there is no SQL command to create an ODBC connection.
You can script the configuration using WMI through powershell, the place to start is: http://msdn.microsoft.com/en-us/library/ms179354.aspx and http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.wmi.aspx
Here is a powershell example using wmi to create an alias
g9icjywg2#
To edit an existing alias, I would do a delete\insert.
I use this PS to delete the alias entries (SQL 2016):