Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-11-17
3
Medium Priority
?
698 Views
Last Modified: 2012-08-13
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 ??
0
Comment
Question by:Varshini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 4

Expert Comment

by:NGPSoft1
ID: 34155189
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?
0
 

Author Comment

by:Varshini
ID: 34158723
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 ????
0
 
LVL 4

Accepted Solution

by:
NGPSoft1 earned 2000 total points
ID: 34158838
Are you using an alias with a domain that you own?  If so, you would need to access the Name Server that controls your domain name and create an A record that points to the IP address.  Say for example your sql server was at IP address 123.123.123.123 and your alias is sqlserver.mydomain.com.  You would need to access the Name Servers that controls mydomain.com and add an A record for sqlserver.mydomain.com with an IP address of 123.123.123.123.  The DNS record might look something like this.

sqlserver A 123.123.123.123

0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question