• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 458
  • Last Modified:

How to use SQL Server alias?

I set up a SQL Server Alias 'Appdev' in SQL Server Configuration Manager. And could connect the alias through "sqlcmd -Sappdev -Uusername -Ppassword" from the window server. But I couldn't connect from my PC (XP Windows). How to use SQL Server alias from client?
Thanks!
0
luyan
Asked:
luyan
  • 3
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
On client machine:
click on Start->run (type) cliconfg.exe
clieck on tab alias and define your alias

http://www.mssqltips.com/tip.asp?tip=1620
0
 
Daniel_PLDB Expert/ArchitectCommented:
You can also set up alias in SQL Server configuration manager.
Here's great article about it:
http://www.mssqltips.com/tip.asp?tip=1620

After defining alias you are able to use it instead of server name or address while connecting in ssms.
0
 
luyanAuthor Commented:
Thanks!
0
 
Daniel_PLDB Expert/ArchitectCommented:
You're welcome ;)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now