• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • 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
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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