Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 702
  • Last Modified:

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

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
Varshini
Asked:
Varshini
  • 2
1 Solution
 
NGPSoft1Commented:
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
 
VarshiniAuthor Commented:
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
 
NGPSoft1Commented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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