Hi SSCommitted. thanks for the reply.

I've tested the alias. it'll only work if I setup the alias on server, it doesn't work. only when

i set the alias on the client (my pc) and I can use the alias to connect.

currently the app doesn't have sql configuration manager installed. in order for me to use this alias,

is it a compulsory to install sql configuration manager on the apps server?