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
665 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
  • 2
3 Comments
 
LVL 4

Expert Comment

by:NGPSoft1
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now