Home
|
Weblogs
|
Forums
|
SQL Server Links
Search:
Active Forum Topics
|
Popular Articles
|
All Articles by Tag
|
SQL Server Books
|
About
SQL Server Forums
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
Forum FAQ
Register Now
and get your question answered!
Username:
Password:
Save Password
Forgot your Password?
All Forums
SQL Server 2000 Forums
SQL Server Administration (2000)
NT AUTHORITY\ANONYMOUS LOGON
New Topic
Reply to Topic
Printer Friendly
Author
Topic
Togaspoon
Starting Member
39 Posts
Posted - 04/24/2006 : 11:49:10
This weekend we upgraded are SQL Server from 2000 to 2005. We renamed the 2005 servernameOLD and then named the new server servername.
Most things are working fine but are intranet is giving us the "NT AUTHORITY\ANONYMOUS LOGON" error.
Its settings are:
authentication mode = windows
IIS is set for Integrated Windows Authentication with anonymous access disabled.
IIS and our SQL Server are in the same domain but on different servers.
I'm sure that IIS isn't passing the proper credentials to SQL server but don't really have any clue how to trouble shoot.
Everything was working when we were using our SQL 2000 server.
Thanks
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts
Posted - 04/24/2006 : 12:04:35
not sure but did you check the services and login account in sql?
--------------------
keeping it simple...
Togaspoon
Starting Member
39 Posts
Posted - 04/24/2006 : 12:33:50
I'm sorry, could you be a little more specific? I'm not a real dba, I just play one.
What exactly am I looking for?
Togaspoon
Starting Member
39 Posts
Posted - 04/24/2006 : 14:51:50
OK, found the problem.
The old instace of SQL Server Agent was running under a domain account and the new one was using local system.
Thanks for pointing me in the right direction.
Topic
New Topic
Reply to Topic
Printer Friendly
Jump To:
Select Forum
General SQL Server Forums
New to SQL Server Programming
New to SQL Server Administration
Script Library
Data Corruption Issues
Database Design and Application Architecture
SQL Server 2012 Forums
Transact-SQL (2012)
SQL Server Administration (2012)
SSIS and Import/Export (2012)
Analysis Server and Reporting Services (2012)
Replication (2012)
Availability Groups and DR (2012)
Other SQL Server 2012 Topics
SQL Server 2008 Forums
Transact-SQL (2008)
SQL Server Administration (2008)
SSIS and Import/Export (2008)
High Availability (2008)
Replication (2008)
Analysis Server and Reporting Services (2008)
Other SQL Server 2008 Topics
SQL Server 2005 Forums
Transact-SQL (2005)
SQL Server Administration (2005)
.NET Inside SQL Server (2005)
SSIS and Import/Export (2005)
Service Broker (2005)
Replication (2005)
High Availability (2005)
Analysis Server and Reporting Services (2005)
Express Edition and Compact Edition (2005)
Other SQL Server Topics (2005)
SQL Server 2000 Forums
SQL Server Development (2000)
SQL Server Administration (2000)
Import/Export (DTS) and Replication (2000)
Transact-SQL (2000)
Analysis Services (2000)
MSDE (2000)
Development Tools
ASP.NET
Reporting Services Development
Other Development Tools
Site Related Forums
Site Related Discussions
Article Discussion
Poll Discussion
The Yak Corral
Other Forums
SQL Server 6.5 \ SQL Server 7.0
Other Topics
MS Access
ClearTrace Support Forum
Old Forums
CLOSED - General SQL Server
CLOSED - SQL Server 2005/Yukon
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
SQL Server Forums
© 2000-2009 SQLTeam Publishing, LLC
This page was generated in 0.17 seconds.
NT AUTHORITY\ANONYMOUS LOGON
Posted - 04/24/2006 : 11:49:10
