Re: Connect to Desktop SQL Server 2000 from Pocket PC

From: Ilya Tumanov [MS] (ilyatum_at_online.microsoft.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 17:42:53 GMT

SSPI is in fact supported, but you have to provide user ID and password
anyway as CE does not have this information.
This might be useful if SQL authentication is disabled on a server.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
> From: "Alex Feinman [MVP]" <public_news@alexfeinman.com>
> References: <eV#I4s6VEHA.1652@TK2MSFTNGP09.phx.gbl>
> Subject: Re: Connect to Desktop SQL Server 2000 from Pocket PC
> Date: Mon, 21 Jun 2004 10:19:20 -0700
> Lines: 23
> X-Priority: 3
> X-MSMail-Priority: Normal
> X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
> Message-ID: <OogXkP7VEHA.2168@TK2MSFTNGP10.phx.gbl>
> Newsgroups: microsoft.public.dotnet.framework.compactframework
> NNTP-Posting-Host: 204.249.181.133
> Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED
01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> Xref: cpmsftngxa10.phx.gbl
microsoft.public.dotnet.framework.compactframework:55645
> X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
>
> You need to use SqlClient class available in System.Data.SqlClient. It
works
> pretty much the same way as on the desktop except IIRC the Integrated
> Security=SSPI is not supported. You need to use User ID= and Password=
>
> --
> Alex Feinman
> ---
> Visit http://www.opennetcf.org
> "Leonardo Castillo" <castillolj@hotmail.com> wrote in message
> news:eV%23I4s6VEHA.1652@TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I need to connect from a program in the Pocket PC to SQL Server in my
> > desktop. How i can do than in VB.NET ?.
> > (I need an information in one table in SQL Server 2000).
> >
> > Thanks,
> >
> > Leonardo Castillo.
> >
> >
>
>
>

Relevant Pages

  • Re: Unable to Generate SSPI Context w/ .Net 2.0 App and Windows 2000 Professional Client
    ... The best solution, is to not use SSPI, but a work-around is to log into the local machine and let the local system authenticate the user. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I have many Delphi applications running on the ... not .Net apps, just standard Win32 applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to Generate SSPI Context w/ .Net 2.0 App and Windows 2000 Professional Client
    ... local machine and let the local system authenticate the ... Hitchhiker's Guide to Visual Studio and SQL Server ... Sql server 2000 (running on a Windows 2000 Server). ... change it to use NT Security, it fails with Unable to Generate SSPI ...
    (microsoft.public.sqlserver.connect)
  • Re: login failed for sql server
    ... I can't swear to it but I think using SSPI and a User Id are mutually ... I also seem to remember having this issue if my Sql Server instance was ... not setup to support Mixed security. ... ive even hardcoded the user name in the connection string. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Unable to connect if member of many groups
    ... I have a setup where Acitive Domain users are member of many groups. ... the user cannot connect to the SQL Server ... of more than 269 groups I get the "Cannot generate SSPI context" error. ...
    (microsoft.public.sqlserver.connect)
  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... Are you sure SQL Server is set up to use both SQL Authentication and Windows ... "John Beschler" wrote in message ... > I don't think it's a problem with the IUSR account because ASP runs fine. ...
    (microsoft.public.inetserver.asp.db)