Connecting to SQL between two XP Clients

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


Date: Wed, 29 Oct 2003 10:53:23 -0800

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: Qry Analyzer Debug broken: XP SP2
    ... The reason for Error 508 and Error code 0x80070005 is ... How to configure Windows XP Service Pack 2 for use with SQL Server ... The error code 0x800706ba translates to "RPC server ... unchecked on the client machine, this is a default setting that is checked. ...
    (microsoft.public.sqlserver.server)
  • Re: Cannot generate SSPI context and Windows 2000 service pack 4
    ... This happens because of a Kerberos authentication protocol issue, ... Enable Kerberos logging on the client machine (documented at ... connect to the remote SQL Server, if you get the same error message then ... having some error messages on the APPLICATION eventlog of the SQL Server ...
    (microsoft.public.sqlserver.connect)
  • Re: Regional settings - decimal separator
    ... SQL Server has no knowledge of the Windows setting that the client machine has which is connected ... through a connection. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cube View Problem
    ... Try to use the SQL Server Profiler in order to get more details about ... Business intelligence development studio from the client machine. ... the cube and deploy the cube from the client machine. ... further error information" ...
    (microsoft.public.sqlserver.olap)
  • RE: 2 entries of the same sql server in EM when try to register
    ... The 2 entries are due to alias but don't know how/when the alias is created. ... > communicate with the client machine. ... > have problem connecting to that SQL Server from any ... > register either of the entries but it always get the ...
    (microsoft.public.sqlserver.server)