dbTalk Databases Forums  

SQL 2008 failover cluster failed due to Native Client login failur

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL 2008 failover cluster failed due to Native Client login failur in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Yuhong
 
Posts: n/a

Default SQL 2008 failover cluster failed due to Native Client login failur - 02-10-2009 , 02:51 PM






Hi,
I have a SQL Server 2008 two node cluster. It's running on Windows 2008
Server. It worked fine until I installed MS SQL 2008 Feature Pack, Microsoft
SQL Server 2008 Management Objects. Now I could not bring the SQL Server
cluster resource group back online. It gives me the following error:
------
[sqsrvres] checkODBCConnectError: sqlstate = 28000; native error = 4818;
message = [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed
for user 'NT AUTHORITY\ANONYMOUS LOGON'.
------
I uninstalled the Feature Pack (SMO) but still get the same error.
Any idea what's going on?
Thanks for your help!

--
Yuhong

Reply With Quote
  #2  
Old   
Chris L.
 
Posts: n/a

Default RE: SQL 2008 failover cluster failed due to Native Client login failur - 02-12-2009 , 06:53 AM






Any luck on this? This happened to me after I rebuilt one node due to
operating system errors.

"Yuhong" wrote:

Quote:
Hi,
I have a SQL Server 2008 two node cluster. It's running on Windows 2008
Server. It worked fine until I installed MS SQL 2008 Feature Pack, Microsoft
SQL Server 2008 Management Objects. Now I could not bring the SQL Server
cluster resource group back online. It gives me the following error:
------
[sqsrvres] checkODBCConnectError: sqlstate = 28000; native error = 4818;
message = [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed
for user 'NT AUTHORITY\ANONYMOUS LOGON'.
------
I uninstalled the Feature Pack (SMO) but still get the same error.
Any idea what's going on?
Thanks for your help!

--
Yuhong

Reply With Quote
  #3  
Old   
Chris L.
 
Posts: n/a

Default RE: SQL 2008 failover cluster failed due to Native Client login failur - 02-12-2009 , 06:55 AM



Any luck on this? This happened to me after I rebuilt a node due to
operating system failures. The new node will not bring up any of my
instances. It tries to log into SQL server as ANONYMOUS, but my services are
configured exactly as they are on the functional node.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.