Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • 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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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