<div>
On client machine:<br />
click on Start-&gt;run (type) cliconfg.exe<br />
clieck on tab alias and define your alias<br />
<br />
<a href="http://www.mssqltips.com/tip.asp?tip=1620" rel="ugc">http://www.mssqltips.com/tip.asp?tip=1620</a>
</div>


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 [http://www.mssqltips.com/tip.asp?tip=1620]

<div>
<div class="content wysiwyg-content">
I set up a SQL Server Alias 'Appdev' in SQL Server Configuration Manager. And could connect the alias through &quot;sqlcmd -Sappdev -Uusername -Ppassword&quot; from the window server. But I couldn't connect from my PC (XP Windows). How to use SQL Server alias from client?<br />
Thanks!
</div>
</div>


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!

How to use SQL Server alias?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.