Connecting to SQL between two XP Clients

From: Mal Ball (anonymous_at_discussions.microsoft.com)
Date: 10/30/03 

Date: Thu, 30 Oct 2003 11:55:19 -0800

That doesnt seem to be the case with mine, I have both
machines set up with the same user and I am using Windows
Authentication.

>-----Original Message-----
>You could configure your app to use a SQL login or a
ODBC
>data source and then use a SQL login in that. I have
also
>found that if a local username and password are the same
>on two different machines, then the authentication
passes
>through.
>
>-ES
>
>>-----Original Message-----
>>I have SQL Server 2000 running on an XP Pro machine and
>>VS2003 running on an XP Pro client machine. I have
>>developed an app using my client machine and MSDE
locally.
>>
>>I now want to install my database on the SQL Server
2000
>>machine and test it.
>>
>>My question is how do you configure SQL Server from a
>>security aspect. You dont seem to be able to add a
>>Windows XP client user name because it is not in a
domain
>>that the SQL Server is using. Normally you would just
>>find the user in the domain.
>>
>>I have tried using the convention of machine
name\userid
>>but this doesnt work.
>>
>>.
>>
>.
>

Relevant Pages

  • Re: pass through authentication
    ... Do you mean both SQL SERVER and client machine are not in the domain now? ... Windows authenticates: ... Windows has already validated the login account. ...
    (microsoft.public.sqlserver.connect)
  • Re: pass through authentication
    ... Do you mean both SQL SERVER and client machine are not in the domain now? ... Windows authenticates: ... Windows has already validated the login account. ...
    (microsoft.public.sqlserver.connect)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)