Learn how to a build a cloud-first strategyRegister Now


Sql on Windows 7

Posted on 2011-04-19
Medium Priority
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

Pber earned 2000 total points
ID: 35432445
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

ID: 35435095

Featured Post

New Tabletop Appliances Blow Competitors Away!

WatchGuard’s new T15, T35 and T55 tabletop UTMs provide the highest-performing security inspection in their class, allowing users at small offices, home offices and distributed enterprises to experience blazing-fast Internet speeds without sacrificing enterprise-grade security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, a new law in my state forced us to get a top-to-bottom analysis of all of our contract client's networks. While we have documentation, it was spotty at best for some - and in any event it needed to be checked against reality. That was m…
The term "Bad USB" is a buzz word that is usually used when talking about attacks on computer systems that involve USB devices. In this article, I will show what possibilities modern windows systems (win8.x and win10) offer to fight these attacks wi…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

810 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