MS SQL Connection

Posted on 2012-09-01
Last Modified: 2012-09-11

I am trying to connect to a SQL database, my setup is

Microsoft SQL Server express on a vm (on domain)

Client Machine (off domain)

I have created a login in SQL server management studio (windows authentication)

Can I create a connection if they are not on the same domain?
Question by:AlexAmbler
    LVL 82

    Accepted Solution

    You can't use Windows Authentication without either being on the same machine or being in an AD domain.  You have to enable TCP/IP connections and create a user on that database that is allowed to connect that way using SQL Authentication.  You also have to allow external access thru your firewalls and all that too.
    LVL 21

    Expert Comment

    I'm not sure if a specific version of sql server is required but if you create a local windows user of the same name on client and server and with the same password, windows will authenticate the login as trusted.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    729 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

    19 Experts available now in Live!

    Get 1:1 Help Now