Re: Options for Accessing SQL Server without a Domain Server?

From: ohaya (ohaya_at_cox.net)
Date: 05/10/03 

Date: Fri, 09 May 2003 21:37:19 -0400

Brian Lawton wrote:
>
> We've handled this same situation in the past by coding our application to
> support both security options. The at run-time, they read a flag from the
> registry or config file to identify the type of authentication to use. This
> enables the same application to be installed into multiple environment
> without having to "recompile".
>
> --Brian

Brian,

In order to get me going, I've gone ahead and installed a PDC (NT4
Server) machine. I have two other machines, both running Win2K Pro.
SQL Server 2000 is running on machine 'A', and my client app will be
running on machine 'B'.

So far, I can log into my new domain from both machines 'A' and 'B'.

I reconfigured the DSN on machine 'B' to use Windows Authentication.

But, when I try to run my application, which uses this DSN, it can't
connect.

In order to allow this app to connect to the database on machine 'B',
what else do I have to do? Do I have to do some additional
configuration on the SQL Server machine 'A'? If so, what?

Thanks,
Jim

Relevant Pages

  • Re: Programmatically create DSN usind SQL Server Authentication
    ... Not when you create the DSN programmatically. ... >Server using SQL Server Authentication. ... >is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • Programmatically create DSN usind SQL Server Authentication
    ... I am trying to programmatically create a DSN on a target system for SQL ... Server using SQL Server Authentication. ... is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Trouble connecting to SQL Server with ASP !?!
    ... Ask your network guys if they set up the DSN to use "windows authentication" ... If it is "SQL Server Authentication" then you will need a SQLServer Logon ID ...
    (microsoft.public.inetserver.asp.db)
  • Re: Trying to connect to SQL Server database on a web server.
    ... I have the IP address for the web server, ... DSN using the IP address for the server and the UID and PWD used. ... Connection Failed and SQLState 08001 and SQL Server Error 17. ... Is SQL Server configured for Windows Authentication only or SQL ...
    (microsoft.public.sqlserver.connect)
  • cannot access website
    ... Nerve.com--this started a few weeks ago; I do not get the error message on ... Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d' ... Not defined as a valid user of a trusted SQL Server connection. ... The DSN used to connect to the Commerce database is misconfigured to use ...
    (microsoft.public.windows.inetexplorer.ie6.browser)