SQL Server Web App

[kpg]

Hi all,

I have MS SQL Server 2000 Dev on a Win2k machine.

On the client machine I run a VB.NET Windows Forms App
and connect to the SQL Server.

I create a VB.NET Web App, copy the routine, and I fails
to connect (Access Denied or Server Not Found).

On the Server I haveTCP, Named Pipes, and Shared Memory.
On the Client I have the same.

Yesterday after first configuring cliconfig on the client the Web Forms
App started working, but the Windows Form App stopped. After
a reboot the problem reverted back to the original. Now no matter
what I do I cannot connect with the Web Forms App.

Any Ideas?

kpg

[Andy M]

Your web application will be connecting as the ASP.NET user (see the
security tab in IIS for the virtual directory for the exact account
name). If you are connecting as a trusted connection then that is
probably why the connection is failing.

kpg wrote:

Hi all,

I have MS SQL Server 2000 Dev on a Win2k machine.

On the client machine I run a VB.NET Windows Forms App
and connect to the SQL Server.

I create a VB.NET Web App, copy the routine, and I fails
to connect (Access Denied or Server Not Found).

On the Server I haveTCP, Named Pipes, and Shared Memory.
On the Client I have the same.

Yesterday after first configuring cliconfig on the client the Web Forms
App started working, but the Windows Form App stopped. After
a reboot the problem reverted back to the original. Now no matter
what I do I cannot connect with the Web Forms App.

Any Ideas?

kpg