SQL Server Authentication

Posted on 2005-04-21
Last Modified: 2010-03-19
Hi, I have a Windows XP system running MSDE 2000. Can I cannect to it from a Windows 98 system using Windows Authentication. If yes. How do I go about it.
Question by:hiteshas
    LVL 6

    Expert Comment

    The only situation when that would be possible is when both systems would be members of the same windows 2000/2003 domain. The user on Win98 would have to log on to his domain account and then he could access SQL with windows integrated authentication.

    Author Comment

    Thanks for the response.
    This implies that in a scenario where MSDE is installed on a Windows XP system, or SQL Server 2000 installed on a Win 2000 system which are a part of a WOKGROUP only and no domain exists, then a client system running Win 98 cannot logon using Windows authentication.

    Our client has a workgroup setup in his office with some Win XP systems and some Win 98 systems. We have installed MSDE on one of the Win XP systems. Now we require to connect to this instance of MSDE from all the other systems in the workgroup using windows authentication. Would that be possible?
    LVL 6

    Accepted Solution

    When you have SQL installed on Windows 2000 that is a part of a workgroup, you can still use the Windows authentication using accounts local to that server. The same probably applies to WinXP, although I have not tried this.
    The problem is however that the Win98 system will not be able to use the Windows authentication in that case. The other systems can use it but it is somewhat tricky as you will need to have user logins and passwords synchronised accross those systems.
    Here is a possible scenario:
    -user logs into WinXP local account using his username and password.
    -then he connects to SQL running on Win2000 and the system passes his credentials over the network.
    -he is able to log in because there is a local account on Win2000 that is identical to the account o WinXP system.

    As for your ther question, it is not possible to specify that some sytems must use Windows authentication wile other use SQL authentication. If you are running SQL in mixed authentication mode, it is up to the client which metod he will use.


    Author Comment

    Ok.That sure helped.
    Thanks. I had tried this out. I am able to connect to MSDE on Computer A having Win XP from computer B running Win XP. I needed both the computers to have the same XP user accounts. The scary part was that if the user account present on Computer B was an admnistrator, he got administrator access to MSDE on Computer A.
    Now I just need to manage the authentication such that if my app is running on a 98 system, then I need to change the connection string to connect using a SQL user login, rather than the windows login.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    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