• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

SQL Server Authentication

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.
-Hitesh.
0
hiteshas
Asked:
hiteshas
  • 2
  • 2
1 Solution
 
graf0Commented:
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.
0
 
hiteshasAuthor Commented:
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?
0
 
graf0Commented:
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.

HTH
0
 
hiteshasAuthor Commented:
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.
Thanks.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now