Q: Windows Authentication

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

Date: Sun, 18 Jul 2004 03:53:19 GMT

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

  • Creating an ODBC new DSN fails
    ... I am not able to create a new DSN to a SQL MSDE 2000 SQL server, ... SQLState '01000' ... SQL Server error: 6 ...
    (microsoft.public.sqlserver.clients)
  • Connection to project server failed
    ... I have a user who is having problems connecting to project server through ... SQL Server Error 52 ... SQLState 08001 ...
    (microsoft.public.project)
  • Re: SQL 2000 Login Problem
    ... Can you catch native SQL Server error? ... Are you using a SQL login and have ... Windows authentication only enabled? ...
    (microsoft.public.sqlserver.setup)
  • Re: Creating an ODBC new DSN fails
    ... > I am not able to create a new DSN to a SQL MSDE 2000 SQL server, ... > SQLState '01000' ... > SQL Server error: 6 ...
    (microsoft.public.sqlserver.clients)
  • MSDE Error on attempting to create new Access 2000 project
    ... I've just installed MSDE on my Win 2k machine and have attempted to ... SQLState: '01000' ... SQL Server Error: 123 ...
    (microsoft.public.sqlserver.msde)