Re: Connecting to SQL between two XP Clients

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/30/03

  • Next message: cordelia.goh_at_gvrd.bc.ca: "via group membership" 
    Date: Thu, 30 Oct 2003 13:27:39 -0700

    It depends on whether you are using Simple File Sharing or
    Classic security. Under SFS, network connections
    authenticate under the Guest user.

    -Sue

    On Thu, 30 Oct 2003 11:55:19 -0800, "Mal Ball"
    <anonymous@discussions.microsoft.com> wrote:

    >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.
    >>>
    >>>.
    >>>
    >>.
    >>

  • Next message: cordelia.goh_at_gvrd.bc.ca: "via group membership"