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
Solved

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

Posted on 2014-03-06
9
263 Views
Last Modified: 2014-03-08
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
Comment
Question by:vbnetcoder
  • 5
  • 4
9 Comments
 
LVL 10

Expert Comment

by:PadawanDBA
ID: 39909923
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
 

Author Comment

by:vbnetcoder
ID: 39909935
I tried that :(
0
 

Author Comment

by:vbnetcoder
ID: 39910026
I tried turning off the UAC based on what i read online and that didn't work either
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 39910070
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
 
LVL 10

Expert Comment

by:PadawanDBA
ID: 39910077
0
 

Author Comment

by:vbnetcoder
ID: 39910096
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
 

Author Comment

by:vbnetcoder
ID: 39910098
ooops sorry i got the link u sent now.
0
 
LVL 10

Expert Comment

by:PadawanDBA
ID: 39910109
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
 

Author Closing Comment

by:vbnetcoder
ID: 39914667
ty
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS  - Dropdown with Null 3 28
SQL Help 27 57
SQL SERVER 2008 R2 Could not obtain information about Windows NT group/user 5 47
query optimization 6 14
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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