Re: Fwd: Emerald & ASP

Dale E. Reed Jr. ( (no email) )
Wed, 05 Aug 1998 09:21:32 -0700

Ray Carpenter wrote:
>
> Sorry if this is a dup but I have been having mail problems. I sent this
> yesterday but have not received my post as yet.
>
> I'm trying to access a Emerald SQL db from another server running IIS and
> asp. The asp page works fine with the db on the same system but when I try
> to access the other system I receive an CreateFile() failed. Could this be
> that IIS is running under the system account and needs to be running under
> a username common to both servers? If so how can one change this? Any
> help would be appreciated.

If you are using named pipes as your default protocol, it requires
a pre-authenticated username/password (at user level, before SQL Server
is even involved). You need to either have IIS run as a domain user
or user that both machines know about, then it should work correctly.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com