Re: .NET and SQL Server on Separate Machines

From: Earl (brikshoe_at_newsgroups.nospam)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 17:53:17 -0500

I'm guessing you did a new install of SQL2k ... if I recall correctly, one
of the default Network Configurations includes NamedPipes as well as TCP/IP
... which in turn will lead to some issues with being able to use TCP/IP.
Try clearing NamedPipes.

This may also be a role/user access issue on the Win3 server.

"Big Mo" <jde***@gonzaga.nospam.edu> wrote in message
news:Pine.LNX.4.44.0406171221360.21793-100000@barney.gonzaga.edu...
> Hi all,
>
> We're working on an ASP.Net Web Application that makes several calls to a
> SQL Server database. Everything was running correctly when the database
> and the web server were on the same computer, but we have sinced moved
> them to separate computers; IIS V6 on Win2000 and SQL Server 8(SP3) on Win
> Serv 2003 Ent.
>
> The connection string in our web.config file originally looked like this:
>
> <add key="ConnectionString"
> value="server=localhost;Trusted_Connection=true;database=Store;" />
>
> After moving the database (and changing the server in the connection
> string), we started to receive this error: "Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection."
> We ended up changing the connection string to look like this:
>
> <add key="ConnectionString" value="Integrated Security=SSPI;Initial
> Catalog=Store;Data Source=192.168.0.12;" />
>
> This string only works if we add the following to the .config file:
>
> <authentication mode="Windows" />
> <identity impersonate="true" />
>
> Unfortunately, the web application was designed to use forms
> authentication, so we're still looking for a valid connection string.
> We've tried setting Trusted_Connection=false and providing a username and
> password, but we get the same error as before - only with the provided
> username listed instead of (null). We've tried setting the database to
> mixed mode, and Win Auth only and got the same results.
>
> Any help would be greatly appreciated.
>
>
> --
> Jason De***
> Elk River Systems, Inc.
> http://www.elkriversystems.com
>
>