Mobile app version of vmapp.org
Login or Join
Merenda212

: How to create subdomain link to SQL Server 2008 I would like to know how to create a subdomain that is a link to an SQL Server database. I have Windows Server 2008 R2 and SQL Server 2008.

@Merenda212

Posted in: #Godaddy #Iis7 #SqlServer #Subdomain

I would like to know how to create a subdomain that is a link to an SQL Server database. I have Windows Server 2008 R2 and SQL Server 2008. I have a static IP on the Windows server, and I have a domain at GoDaddy with the A host record pointing to the static IP.

I can successfully establish a remote connection to the SQL Server instance through SQL Server Management Studio. But I have to use the mydomain.com instead of something like sqldbmain.mydomain.com, which is what I would prefer to use.

For another example, if I create a SQL database at some web host like GoDaddy, they give me an external link to my DB like sqldb1234.db.hostedresource.net. That is what I'm trying to replicate.

I'm not sure whether this is something that has to be managed through IIS on the Windows server, through the domain management at GoDaddy, or through SQL Server management, or even a little bit of all of them.

EDIT

For clarification, I'm accessing the database through SQL Server Management studio. In the field where it asks for the "Server Name" is where I enter mydomain.com, but I would like to enter the value similar to sqldb1234.db.mydomain.com.

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Merenda212

1 Comments

Sorted by latest first Latest Oldest Best

 

@Bethany197

You need to create an A record for sqldb1234.db in your DNS area for GoDaddy.
support.godaddy.com/help/article/2290/how-do-i-create-a-subdomain-in-simple-control-panel
Once the A record has propagated you should be able to use the subdomain sqldb1234.db.mydomain.com in your connection string.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme