Something must be wrong with me today... can't seem to formulate anything
right.
A authentication is not valid on one server only, i.e. it cannot traverse
accross servers.
must become
An authentication is valid on one server only, i.e. it cannot traverse
accross servers.
--
Kind regards
Sven Aelterman
IT
Global Communication N.V.
Remember: Bugs come in through Windows.
http://www.aelterman.com
http://www.my-it.org
> This is a very common problem. A authentication is not valid on one server
> only, i.e. it cannot traverse accross servers.
> The easiest solution to this is to create a user IUSR_<machinename> on the
> db server that has the exact same password as the IUSR_<machinename> on
your
> web server.
> I do believe there is more info on this in the FAQ.
> (You are using Anonymous access right?)
> --
> Kind regards
> Sven Aelterman
> IT
> Global Communication N.V.
> Remember: Bugs come in through Windows.
> http://www.aelterman.com
> http://www.my-it.org
> > Hi! I'm developing a web application that uses ASPs and the MSDE
database.
> > I've tow computers, one with IIS4.0 and the other with MSDE. Both have
> > NTServer 4.0. My problem is when I'm trying to connect to the MSDE using
> an
> > authenticated nt user the result is the following error:
> > --
> > Microsoft OLE DB Provider for SQL Server error '80040e4d'
> > Login failed for user '\'.
> > /Default.asp, line 37
> > --
> > I'm using this connection string:
> > "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
> > Info=False;Initial Catalog=DATABASE;Data Source=COMPUTER;Locale
> > Identifier=2070;Connect Timeout=15;General Timeout=0;Use Procedure for
> > Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PC;"
> > Can anyone give me a tip for this problem?
> > Many Thanks in Advance,
> > Mario
by