all groups > dotnet distributed apps > december 2004 >
You're in the

dotnet distributed apps

group:

Using IIS As an Activation Agent


Using IIS As an Activation Agent JackD
12/21/2004 6:31:01 PM
dotnet distributed apps:
I have programmed a distributed app configured as follows:
-- an MBR Remotable class exposes a method that connects to a SQL Server
database and returns a result set in a dataset.
-- for my first version of the host server I implemented a console
application that uses the SingleCall Activation Mode to Register a
Server-Activated Object
-- my client is a windows based application that simply displays the results.

Everything works fine. However, when I change my host server to use IIS as
the activation agent everything works except the result set is empty. The
IIS server seems to be having trouble accessing the database. I think it is
an authentication issue but I can't figure it out. Any help would be
appreciated.
RE: Using IIS As an Activation Agent JackD
12/22/2004 5:31:03 AM
I got it to work! I reloaded SQL Server and changed the Authentication mode
from Windows Authentication Mode to Mixed Mode (Windows Authentication and
SQL Server Authentication). The application now works.

Thanks
JackD

[quoted text, click to view]
AddThis Social Bookmark Button