A
andrew
I am trying to create a web browser which will interact
with a SQL Server DB to personalise the user experience,
and am using the Desktop Engine that installs with Office
XP to design my application.
I am unable to log onto the SQL server, although I have
chosen NT Integrated Security and the Test Connection
succeeds when I configure the connection after dropping a
SQLDBConnection object ion the form.
At run time I get an error indicating that my logon fails,
and it looks like my web app attempts to connect to the DB
under a different user name to the intial connection setup
(i.e. it uses SERVERNAME\ASPNET rather than
SERVERNAME\LoggedOnUserName).
I am unsure of where or how I can either change the logon
to the server to be consistent with NT Integrated
security, or to set permissions within the SQLServer to
allow username ASPNET read/ write access.
Is there an easy fix or any documantation which will help??
Thanks In Advance
Andrew
with a SQL Server DB to personalise the user experience,
and am using the Desktop Engine that installs with Office
XP to design my application.
I am unable to log onto the SQL server, although I have
chosen NT Integrated Security and the Test Connection
succeeds when I configure the connection after dropping a
SQLDBConnection object ion the form.
At run time I get an error indicating that my logon fails,
and it looks like my web app attempts to connect to the DB
under a different user name to the intial connection setup
(i.e. it uses SERVERNAME\ASPNET rather than
SERVERNAME\LoggedOnUserName).
I am unsure of where or how I can either change the logon
to the server to be consistent with NT Integrated
security, or to set permissions within the SQLServer to
allow username ASPNET read/ write access.
Is there an easy fix or any documantation which will help??
Thanks In Advance
Andrew