You are trying to log in to the database using Windows authentication, which
is passing the credentials of the current process. The ASP.NET process uses
the ASPNET user, which is a machine-level user. Either change your
connection string to use SQL authentication (remove the sspi clause) or else
set impersonate=true in your web.config to impersonate another Windows
account. Once you select how you want to authenticate (Windows or SQL) if
you have any problems getting that specific method set up, post back again.
--
Chris Jackson
Software Engineer
Microsoft MVP - Windows Shell/UI
Windows XP Associate Expert
--
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
--
"david" <li*@dodo.com.au> wrote in message
news:05****************************@phx.gbl...
When my asp app tries to log on to the sql database i get
an exception which is as follows:
Exception Details: System.Data.SqlClient.SqlException:
Login failed for user 'ACER\ASPNET'.
i am new to the creation of squ connections and the
permissions that come with it, so i would appreiaiate any
advice on this matter.
thanks for the help.