<div>
Are you also using the port number when using the alias name? &nbsp;Did you create a DNS record for your alilas name? &nbsp;Does that alias resolve to the correct IP address if you do an nslookup?
</div>


Are you also using the port number when using the alias name?  Did you create a DNS record for your alilas name?  Does that alias resolve to the correct IP address if you do an nslookup?

<div>
Yes, i am using port number when i create the alias name. But i did not create the DNS record for the alias name. How can i create that one ????
</div>


Yes, i am using port number when i create the alias name. But i did not create the DNS record for the alias name. How can i create that one ????

<div>
<div class="content wysiwyg-content">
I have created server alias for my sql server. The server is in the public (web). Its configured to connecting &nbsp;by specific port number. When i connect the server ip &nbsp;(xxx.xx.xx.xxx , port) its connecting but using alias name its not connecting .. how can i connect my we sql server by server alias name ??
</div>
</div>


I have created server alias for my sql server. The server is in the public (web). Its configured to connecting  by specific port number. When i connect the server ip  (xxx.xx.xx.xxx , port) its connecting but using alias name its not connecting .. how can i connect my we sql server by server alias name ??

How do i connect my  web sql server using alias  name? the server has configured to connect the sql server by port number

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.