Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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
Medium Priority
?
268 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
[X]
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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 10

Accepted Solution

by:
PadawanDBA earned 2000 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
 

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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

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 …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Screencast - Getting to Know the Pipeline

610 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