?
Solved

SQL

Posted on 2009-04-15
6
Medium Priority
?
417 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 12

Expert Comment

by:Nathan Riley
ID: 24149438
Is it sql authentication or windows authentication?
0
 
LVL 12

Accepted Solution

by:
Nathan Riley earned 1000 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 1000 total points
ID: 24154621
0
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 
LVL 12

Expert Comment

by:Nathan Riley
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

741 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