Published Web Site Issue

[jrcapp]

On my machine I am developing a .NET site. When I execute it,
everything runs perfectly. When I publish it (to my machine in a
folder so IIS can access it), I get a SQL error:

"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection"

I know what the error means, but I don't understand why I'm getting
this on the published site and not when I run/execute the site from
Visual Studio 2005.

Any ideas?

Thanks!
Jeremy

 

[Siva M]

The Windows user account used by IIS is not added to the SQL Server. Perhaps,
if you do it, the error should disappear. If you are using IIS 6, make sure
the IIS app pool account is added to the SQL Server.

HTH.

 

[jrcapp]

I will give that a try. Though, I don't understand why it matters
because I'm using a specific username/password in my connection string
in the code.

 

[jrcapp]

Oh, I forgot to mention that the SQL database is on a separate
development machine. I don't know if that would matter or not.

 

[jrcapp]

Ok, i ended up changing "Integrated Security=True" to "Integrated
Security="False" and it worked. But now I'm having issues where the
Web site appears, but the AJAX controls aren't showing up on the site.
I do have the AJAX Extensions installed on the server.

 

[Siva M]

Integrated security change has nothing to do with AJAX. I guess the problem
could be with data access/permissioning.