Solved

SQL

Posted on 2009-04-15
6
412 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 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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…
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.

729 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