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
262 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
In this article I will describe the Backup & Restore 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.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

773 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