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
264 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Results to Excel File 18 77
Linked Server Issue with SQL2012 3 33
SQL Stored Proc - Performance Enhancement 15 80
T-SQL: problem comparing datetime 4 53
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

696 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