• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

Setting up sql server on latop -- getting error Token-based server access validation failed with an infrastructure error

I installed SQL Server on my laptop (windows 8).  When I try to connect to the database engine i get the following error

"Token-based server access validation failed with an infrastructure error"

Why?
0
vbnetcoder
Asked:
vbnetcoder
  • 5
  • 4
1 Solution
 
PadawanDBAOperational DBACommented:
Try running SSMS as an administrator to see if the message goes away.

Edit:  My thought is an issue with it not passing an admin token.
0
 
vbnetcoderAuthor Commented:
I tried that :(
0
 
vbnetcoderAuthor Commented:
I tried turning off the UAC based on what i read online and that didn't work either
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
PadawanDBAOperational DBACommented:
Are you sure you added your user to the sysadmin group when you first installed sql server?  Also, did you, by chance, install sql server in mixed mode authentication and have the sa password to get in and interrogate the permissions?  The only other option is to backdoor your way into SQL server in order to interrogate the permissions and/or add another user (perhaps a local user to eliminate ad authentication issues from the floor, especially if the services are running under a local user service account and trying to authenticate domain accounts).  I'll post a link to a thread I helped on for how to backdoor the sql installation.
0
 
vbnetcoderAuthor Commented:
I'm not sure i added the user to the sysadmin group.

How would I do this .  I am completely new at all of this
0
 
vbnetcoderAuthor Commented:
ooops sorry i got the link u sent now.
0
 
PadawanDBAOperational DBACommented:
It's a good exercise to go through - the very last point in time you ever want to have to learn to do this is on a downed production system!
0
 
vbnetcoderAuthor Commented:
ty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now