A
AnalogKid17
<full error>
An error has occurred during report processing.
Exception has been thrown by the target of an invocation.
Login failed for user '[Domain name]\[Server Name]$'.
</full error>
I have a web based winforms app (in VS2005) working fine on my machine
but (shockingly) not working on the prod server...
The page throwing the exception contains a ReportView control with a
connection to a SQL2000. For simplicity I hardcoded the SQL sa account
in the connection string. But it looks like (when on the prod server)
the app uses a different account (above mentioned) which has no
permissions to access SQL.
1) I know that the framework installs an ASPNET account to use the app,
but how is this related to SQL ???
2) Why does the account used changes from local to production ?
3) How do I assign correct permissions ?
TIA
AK
An error has occurred during report processing.
Exception has been thrown by the target of an invocation.
Login failed for user '[Domain name]\[Server Name]$'.
</full error>
I have a web based winforms app (in VS2005) working fine on my machine
but (shockingly) not working on the prod server...
The page throwing the exception contains a ReportView control with a
connection to a SQL2000. For simplicity I hardcoded the SQL sa account
in the connection string. But it looks like (when on the prod server)
the app uses a different account (above mentioned) which has no
permissions to access SQL.
1) I know that the framework installs an ASPNET account to use the app,
but how is this related to SQL ???
2) Why does the account used changes from local to production ?
3) How do I assign correct permissions ?
TIA
AK