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

Viewing 1 post (of 1 total)
  • Author
    Posts

  • 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]

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

External Sharing and Guest User Access in Microsoft 365 and Teams

This eBook will dive into policy considerations you need to make when creating and managing guest user access to your Teams network, as well as the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

You will learn:

  • Who should be allowed to be invited as a guest?
  • What type of guests should be able to access files in SharePoint and OneDrive?
  • How should guests be offboarded?
  • How should you determine who has access to sensitive information in your environment?

Sponsored by:

 
Office 365 Coexistence for Mergers & Acquisitions: Don’t Panic! Make it SimpleLive Webinar on Tuesday, November 16, 2021 @ 1 pm ET

In this session, Microsoft MVPs Steve Goodman and Mike Weaver, and tenant migration expert Rich Dean, will cover the four most common steps toward Office 365 coexistence and explain the simplest route to project success.

  • Directory Sync/GAL Sync – How to prepare for access and awareness
  • Calendar Sharing – How to retrieve a user’s shared calendar, or a room’s free time
  • Email Routing – How to guarantee email is routed to the active mailbox before and after migration
  • Domain Sharing – How to accommodate both original and new SMTP domains at every stage

Aimed at IT Admins, Infrastructure Engineers and Project Managers, this session outlines both technical and project management considerations – giving you a great head start when faced with a tenant migration.the different layers of guest access and the common challenges that accompany a more complicated Microsoft 365 infrastructure.

Sponsored by: