Connect to [hosted] sql server with management studio

Home Forums Other Microsoft Servers and SaaS SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 Connect to [hosted] sql server with management studio

This topic contains 1 reply, has 2 voices, and was last updated by Avatar Ossian 4 years, 3 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Avatar
    jhonathan
    Member
    #165442

    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 [deleted] 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 [hosted web site address] 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 [deleted], they give me an external link to my DB like sqldb1234.db.company.com. 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 [deleted], 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 [host address] but I would like to enter the value similar to sqldb1234.db.mydomain.com.

    [MOD EDIT – links to commercial sites removed – I really not sure if this is a quite clever spam or a real post]

    Avatar
    Ossian
    Moderator
    #190745

    I have edited out all the commercial links – live or not – in the post above as we get too many spammers here.

    What does the hosting company have to say?
    Normally I would establish a remote session to the hosting company and run a local instance of SSMS

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.