MBR IT/.NET 247 : ASPNET cannot connect to SQL server accross the network on ASPFriends.com 'ngfx-sqlclient' list

ASPNET cannot connect to SQL server accross the network

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.

Oliver

-- Moved from [aspngfreeforall] to [ngfx-sqlclient] by Marcie Jones <Click here to reveal e-mail address> --

Here is the situation:

Machine A has SQL Server 2000 and ASP.NET Framework. Everything works like a
charm.
Machine B is connected to machine A via workgroup and has ASP.NET Framework.
ASP.NET web applications on machine B cannot connect to SQL Server on
machine A.

When tracing the SQL on the server, I can see that .net is trying to connect
using the ASPNET Windows account. Of course, the ASPNET account on machine B
has a different password than the ASPNET account on machine A, so the login
attempt fails.

What am I supposed to do? Make the password for ASPNET user be the same on
both machines? Windows threatens me with all kinds of data losses if I do
this. Unfortunately, SQL Server does not have a "SQL only" security option.

All help would be very much appreciated! Thank you in advance,

Oliver.

Reply to this message...

Tim Curtin

are you using a correct SQL login connection string?

[Original message clipped]

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

Reply to this message...

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com