Datbase Results Error

S

Stacie Espinosa

I have posted quite o few question on one database results error using access
as the database, but to know avail could not get it to work so now I am
trying SQL only I get this error now I figure its a permissions error but I
tried resetting permissions but still get the same error is someone could
help that would be great

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'NT AUTHORITY\ANONYMOUS LOGON'.

Thanks Stacie
 
M

Mark Fitzpatrick

Stacie,
What is happening is you have the connection set to use a trusted
user. What this means is it uses the information from the windows user that
is accessing the server. In the case of a normal IIS user, that's the
anonymous IUSR account. So, those credentials are being passed to SQL
Server. Unless the IUSR account for that computer has been mapped to a valid
SQL Server account, SQL Server will reject it because it knows nothing about
the IUSR account. Instead, try passing the username and password to the SQL
Server of a valid SQL Server account and disable the Trusted connection
option. This way the credentials of the windows account won't be passed and
it will instead use the username and password included in the connection
string.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
 
Top