ASP.NET/MS SQL2K Connectivity Problem

[GOKU24]

Database: MS SQL 2K on a sub-domain, uses Named Pipes and TCP/IP and
it's in Mixed Mode.

Local PC: Win2K Pro
Dev Server: Win2K Server

From my local PC I can connect to this database with no problem
through EM and QA, but when I try to use the same SQL login to connect
through an ASPX page it fails. I get "SQL Server Does Not Exist or
Access Denied".

However, if I turn on impersonation I can connect to this database
through my ASPX page. From my development server impersonation
doesn't work. I get "Login failed for user 'username'. Reason: Not
associated with a trusted SQL Server connection."

Anyone have a clue as to why I can connect to the SQL DB through EM
and QA with no problem, but through my ASPX page it fails. Also, why
would turning impersonation on make things work.

One moe thing, the original page was written in classic ASP. This
page works fine on my PC , but if I move it to another PC or server it
fails. I dunno if that helps.


Thanks in advance. Any help would be appreciated.

 

[Trent Millar]

It could be that you do not have the correct user in SQL Server. Check
within Enterprise Manager > Security > Logins and check to make sure your
local computer ASPNET account is in there. Not the on from the Database
server but the one on your machine that is running the ASP.NET page.

Trent Millar