Solved

SQL

Posted on 2009-04-15
6
410 Views
Last Modified: 2012-05-06
I am new to SQL so bare with me.
I have a VPN user who recieves this error.
"The user is not associated with a trusted SQL Server connection"

The error logs show
"Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 10.1.1.21]"
and
"SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.1.1.21]"

I have a spn problem with an SQL account.
"SQLServer2005ReportingServicesWebServiceUser$TSDSQLSVR$MSSQLSERVER"
shows only the SID
"S-1-5-21-245077365-4195247365-257611332-1126"

I am pretty sure if I resolve the sid to name this issue will be resolved.
How do I do this?
0
Comment
Question by:ultreya
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:N R
ID: 24149438
Is it sql authentication or windows authentication?
0
 
LVL 11

Accepted Solution

by:
N R earned 250 total points
ID: 24149453
I would bet that it's a windows authentication account that needs to be a sql authentication account.  See below to change:

http://support.microsoft.com/default.aspx/kb/555332
0
 
LVL 7

Assisted Solution

by:Hemantgiri S. Goswami
Hemantgiri S. Goswami earned 250 total points
ID: 24154621
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 11

Expert Comment

by:N R
ID: 24215414
Did you get it to work?
0
 

Author Comment

by:ultreya
ID: 24295584
Sorry for delay I need more time ... I have not forgotten ... Just hammered with work ...
0
 

Author Closing Comment

by:ultreya
ID: 31570518
Your system is forcing me to close this question.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question