Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-27 : 07:56:39
|
| Carol writes "Hi - Thanks for Listening!We are developing an intranet application using the following:- IIS5.0 and classic ASP (running on a Windows 2000 Server) and using Integrated Windows Authentication, disabling Anonymous User- SQL Server 2000 (running on a different Windows 2000 Server)- using Active Directory ServicesI have setup identical groups on the IIS server and the SQL Server and given the correct login and database access in SQL. However I am still receiving:Connection failed:SQLState: '28000'SQL Server Error: 18456{Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.Our goal is to capture who is coming to the web page, using their Windows/Active Directory account (not having to login again) so the proper SQL access can be given.Any help would be greatly appreciated." |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-28 : 06:51:14
|
Hi,BOL SAYS for Error 18456quote:
Severity Level 14Message TextLogin failed for user '%ls'.Login failed for user distributor_admin.ExplanationIf the error message includes the account with which you are trying to access the server, you do not have permission to log in to the server.If the error message includes the account distributor_admin, the issue is with an account used by replication. Replication creates a remote server, repl_distributor, which allows communication between the Distributor and Publisher. The login distributor_admin is associated with this remote server. The distributor_admin account can be designated as trusted or non-trusted when you configure replication. If it is designated as non-trusted, a password is required, and login will fail without one. ActionIf the error message contains the login with which you are trying to access the server, contact a member of the sysadmin fixed server role to request login permission.If the error message includes the user distributor_admin, ensure that there is a password associated with the account. For more information, see the topic Connecting to the Distributor. Note It is recommended to use a non-trusted connection for the distributor_admin account
-----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
 |
|
|
|
|
|
|
|
SQL Authentication & IIS