SQL Server Web App

BBill

SQL Server Web App

Web Programming291
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

Registered User

Fri Oct 08 08:54:56 CDT 2004

Re:SQL Server Web App

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:

Quote

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

-