.NET and SQL Server on Separate Machines

  • Thread starter Thread starter Big Mo
  • Start date Start date
B

Big Mo

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.
 
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.
 
One way out would be
- configure your iis asp.net worker process to run under a domain account
(need to modify your machine.config file)
- add this domain account as a valid login to your sql server.
hth
vikram
 
Back
Top