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

vbnetcoder
vbnetcoder used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
PadawanDBAOperational DBA

Commented:
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.

Author

Commented:
I tried that :(

Author

Commented:
I tried turning off the UAC based on what i read online and that didn't work either
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Operational DBA
Commented:
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.

Author

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

Author

Commented:
ooops sorry i got the link u sent now.
PadawanDBAOperational DBA

Commented:
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!

Author

Commented:
ty

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial