Solved

SQL

Posted on 2009-04-15
6
409 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

785 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