Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SSPI handshake failed with error code 0x8009030c Expand / Collapse
Author
Message
Posted Monday, February 16, 2009 10:12 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 1, 2013 1:02 AM
Points: 529, Visits: 1,688
Hi,

We have A/A/P clustered Sql server 2005 EE x64 on windows 2003 R2 EE. On node1 we have default instance which is having sharepoint databases. On node 3 instances for Biztalk application.
We are getting the below error on On node 1 instance and on one of the 3 instances on node 3.

2009-02-16 15:20:30.12 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.10.10.10]
2009-02-16 15:20:30.12 Logon Error: 18452, Severity: 14, State: 1.
2009-02-16 15:20:30.12 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 10.10.10.10]


Could you please advice me what should I do to get rid of this error?

Thank You
Madhu
Post #658203
Posted Tuesday, February 17, 2009 1:33 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 1, 2013 1:02 AM
Points: 529, Visits: 1,688
Could you please give me some info on this and at the same time we got errors in sharepoint servers also as below:

vent Type: Error
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 10036
Date: 2/16/2009
Time: 15:20:30 PM
User: N/A
Computer: ABC
Description:
A database error occurred.

Source: Microsoft OLE DB Provider for SQL Server
Code: 0 occurred 1 time(s)
Description: Timeout expired

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: General
Event ID: 27745
Date: 2/16/2009
Time: 15:20:30 PM
User: N/A
Computer: DEF
Description:
The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SPProd_Cfg on CMS. Check the database connection information and make sure that the database server is running..


Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server Shared Services
Event ID: 6482
Date: 2/16/2009
Time: 15:20:30 PM
User: N/A
Computer: DEF
Description:
Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (205422a4-9eaa-452d-9a7b-11f76b2969df).

Reason: The request failed with HTTP status 401: Unauthorized.

Techinal Support Details:
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at Microsoft.Office.Server.Search.Administration.SearchApi.RunOnServer[T](CodeToRun`1 remoteCode, CodeToRun`1 localCode, Boolean useCurrentSecurityContext, Int32 versionIn)
at Microsoft.Office.Server.Search.Administration.SearchApi.RunOnServer[T](CodeToRun`1 remoteCode, CodeToRun`1 localCode)
at Microsoft.Search.Administration.Security.HOSTSFile.ConfigureDedicatedGathering(SearchServiceInstance searchServiceInstance, SPServer dedicatedWebFrontEndServer, IList`1 previousWebApplicationHostNames)
at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.SynchronizeDefaultContentSource(IDictionary applications)
at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize()
at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server General
Event ID: 7888
Date: 2/16/2009
Time: 15:20:30 PM
User: N/A
Computer: DEF
Description:
A runtime exception was detected. Details follow.
Message: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Techinal Details:
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Office.Server.Data.SqlSession.OpenConnection()
Post #658821
Posted Tuesday, February 17, 2009 1:51 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, January 30, 2014 7:05 PM
Points: 69, Visits: 43
try to execute setspn -L and find out if you have any invalid spn;s in the active directory. get those deleted and it shoud work fine..
Post #658844
Posted Tuesday, February 17, 2009 2:14 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 1, 2013 1:02 AM
Points: 529, Visits: 1,688
Thank You..

We are not using Kerboros for webservice. We are using NTLM.Eventhough we using NTLM do we need to check for invalid SPNs in active directory?
Is this any serious issue?
Post #658881
Posted Tuesday, February 17, 2009 5:07 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, November 1, 2013 1:02 AM
Points: 529, Visits: 1,688
Could you please clarify me what to do to get rid of this error?
I searched google a lot but i did not find the solution. Is it really with the Sql server issue or Share point issue?
If it is Sql server issue please advice me what are the stpes I need to take
Post #658972
Posted Tuesday, February 17, 2009 6:17 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 17, 2009 5:33 PM
Points: 81, Visits: 299
Try giving security admin privileges to Sharepoint accounts (Admin account as well as farm account), i assume you are using only 2 accounts.

Did you configure search service? whats the status? Is it running?
Post #658985
Posted Wednesday, September 30, 2009 12:27 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 9:59 AM
Points: 62, Visits: 844
I spent two days trying to figure out a solution to this problem. My problem was my computer name. It was 16 characters and server 2008 net bios will only read up to 15. As soon as I renamed my PC to be under 15 characters, rebooted and joined the domain. Service start perfectly.
Post #795945
Posted Monday, March 15, 2010 7:12 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:57 AM
Points: 405, Visits: 1,137
Hi

Just tagging on to this thread, I'm having an issue with reporting services.

I have a data source which I want referencing via a DNS Entry as the database is mirrored, so the DNS entry will point to the live server.

Under the data source Connection String on Report Manager I have
data source=iris_test.forthports.net;initial catalog=IRIS;Integrated Security=SSPI; Trusted_Connection=true;

I have also selected the following:
- Credentials stored securely in the report server
- Use as Windows credentials when connecting to the data source
- Specified a valid domain account in the format DOMAIN\UserAccount

When I try to run the report I get the following error in Report Manager

An error has occurred during report processing.
Cannot create a connection to data source 'dsIrisSys'.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.


On the SQL side the following errors are logged:

Date 15/03/2010 13:01:43
Log SQL Server (Current - 15/03/2010 13:01:00)

Source Logon

Message
Error: 17806, Severity: 20, State: 2.


Date 15/03/2010 13:01:43
Log SQL Server (Current - 15/03/2010 13:01:00)

Source Logon

Message
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.17.151]


Date 15/03/2010 13:01:43
Log SQL Server (Current - 15/03/2010 13:01:00)

Source Logon

Message
Error: 18452, Severity: 14, State: 1.


Date 15/03/2010 13:01:43
Log SQL Server (Current - 15/03/2010 13:01:00)

Source Logon

Message
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.17.151]


Both SSRS and SQL server are running on the same machine (SQLTEST02).

I'm not 100% on what I need for the SPN, but I have
Registered ServicePrincipalNames for CN=SQLTEST01,CN=Computers,DC=forthports,DC=
net:
HOST/sqltest01.forthports.net
HOST/SQLTEST01


Within IIS I have Integrated security set for the Reporting Services Website (which appears to work fine).

Lastly I can connect remotely using SSMS as the required DOMAIN\UserAccount.

I can't see why this is causing a problem - I would appreciate any help.


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #882899
Posted Monday, March 15, 2010 7:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 28, 2014 8:38 AM
Points: 103, Visits: 215
Matthew Clifford (9/30/2009)
I spent two days trying to figure out a solution to this problem. My problem was my computer name. It was 16 characters and server 2008 net bios will only read up to 15. As soon as I renamed my PC to be under 15 characters, rebooted and joined the domain. Service start perfectly.

thanks for mentioning the solution. that those limits still exist is easily overlooked, surprising and unexpected probably.
Post #882939
Posted Monday, March 15, 2010 9:15 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:57 AM
Points: 405, Visits: 1,137
What does the SPN do?

(i'm seeing alot of SPN and Kerberos related articles on the web) I'm not a network guy - so I'm not quite sure why this is needed? It would be helpful to know


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #883032
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse