Sql on Windows 7

Posted on 2011-04-19
Last Modified: 2013-12-04
We have SQL 2000 running on a Windows 7 Pro 32 Bit workstation. How do we authenticate Windows XP users to the SQL server?
Question by:Old-Dog
    LVL 26

    Accepted Solution

    It depends.  If you are using SQL integrated authentication, they use use the internal account setup within SQL to grant access.  If you have SQL setup for Mixed, you can also use the internal account or a Windows account.  If you have SQL setup for Windows Authentication it will only work with Windows accounts.  

    With the Windows authentication, it also depends if these computers are on a domain or not.  If they are on a Domain, then you can configure the SQL logins to the domain accounts and grant those logons to the databases required and it should be good.  If you are in a workgroup with Windows authentication, it is more difficult as remote machines can't really authenticate with remote accounts.  You have to use a concept called pass-through authentication.  This is essentially creating a local userid with the same username and password on both the XP machine and the Windows 7 machine.

    In this scenario, I would probably suggest using internal authentication with the SQL and it might be the method with the least issues to implement.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

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

    This is a guide to the following problem (not exclusive but here) on Windows: Users need our support and we supporters often use global administrative accounts to do this. Using these accounts safely is a real challenge. Any admin who takes se…
    As a Mac user and former AppleCare AHA & Senior Advisor, I'm constantly bombarded with questions about Macs and if they need Antivirus. This short article is my response to those questions.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now