Re: Q: Windows Authentication

From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 04:00:45 GMT

PS...This is a peer-to peer network...no domain controller.

On Sun, 18 Jul 2004 03:53:19 GMT, Lou_Arnold@nospam.com (Lou Arnold)
wrote:

>Is Windows Authentication possible without a domain controller?
>
>I am running a testbed with two Win2K machines without firewalls. One
>computer contains the MSDE 2000A, set for Windows Authentication
>only. Running MS Access on the other computer under the Administrator
>account causes a connection failure error message:
>
>Microsoft SQL Server Login
>---------------------------
>Connection failed:
>SQLState: '01000'
>SQL Server Error: 87
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
>(Connect()).
>Connection failed:
>SQLState: '08001'
>SQL Server Error: 6
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]Specified SQL server not
>found.
>
>Lou Arnold,
>Ottawa, Canada

Relevant Pages

  • MSDE and Access Project Issue
    ... I installed MSDE SP3a on my XP Pro laptop using the following options: ... The SQL Server Database Wizard popped up and I entered MSDE01 for the SQL server and clicked the Use Trusted Connection. ... SQL Server Error: 53 ... I can connect to this instance of MSDE using ASP.NET and the Server Explorer. ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE Error on attempting to create new Access 2000 project
    ... old version of MSDE) ... "Configuring SQL Server 2000 Desktop Engine" White Paper Available ... > SQLState: '01000' ... > SQL Server Error: 123 ...
    (microsoft.public.sqlserver.msde)
  • Re: SQLEVN70.RLL
    ... SQL server error, ... "$Bill" wrote in message ... > required to fix this for MSDE. ...
    (microsoft.public.sqlserver.server)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)