I created an alias (32 and 64 bit) for a named instance (Server1\Instance1) and named it Larry on Server 1.
When I open up SSMS on Server1, and connect via name 'Larry'...I connect fine.
I now want to connect from an application server (that does not have SQL Server on it) via an application configuration page that asks me the server name. When I put the name "Larry" in, its not able to find it on the network. Of course I cannot ping 'Larry' from the app server as well. The reason I don't use Server1\Instance1 on the application server for configuration, is because the application does not like named instances for configuration, so I thought I would get around this problem by creating Larry as an alias.
How can I make this work ?
Ive tried a lot of troubleshooting here are some;
SQL browser is running on Server1
TCP/IP is enabled, actually all protocols are enabled
allow remote connections is checked on Server 1
Firewall is off
Why can I NOT connect via the alias name from the application server ?
THANK YOU!
You need to create it on the client - on you laptop, on your app server, etc. You can use CliConfig.exe if the clients don't have Configuration Manager.
This post walks through the process:
Create SQL Server Alias – CliConfg.exe
Sue