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: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • 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)