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 22:51:29 -0400

ohaya wrote:
>
> 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?
>

Hi All,

Please ignore my last post. I've just figured out the problem...I was
missing some DLLs that the application needed :(.

Thanks,
Jim

Quantcast