Connecting to SQL between two XP Clients

From: ESystems (anonymous_at_discussions.microsoft.com)
Date: 10/29/03 

Date: Wed, 29 Oct 2003 11:23:42 -0800

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: ODBC Timeout problems but very hard to pin down
    ... APP 1: Access 2000 database ... I ran SQL Profiler to capture the ... validated by SQL Server. ... As it happens, the default display contains ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Openrowset Jet OLEDB
    ... Front end app means the app we wrote and wich the users use to modify the ... This works fine in our development enviroment where the sql service is ... And what do you mean by "speedily import an mdb into the ... > Microsoft Access Developer's Guide to SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2000 NT AUTHORITYSYSTEM Permission Problem
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > Forms app and a VB6 app. ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)