Avatar of vbnetcoder
vbnetcoder

asked on 

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

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?
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
vbnetcoder
Avatar of PadawanDBA
PadawanDBA

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.
Avatar of vbnetcoder
vbnetcoder

ASKER

I tried that :(
Avatar of vbnetcoder
vbnetcoder

ASKER

I tried turning off the UAC based on what i read online and that didn't work either
ASKER CERTIFIED SOLUTION
Avatar of PadawanDBA
PadawanDBA

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of vbnetcoder
vbnetcoder

ASKER

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
Avatar of vbnetcoder
vbnetcoder

ASKER

ooops sorry i got the link u sent now.
Avatar of PadawanDBA
PadawanDBA

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!
Avatar of vbnetcoder
vbnetcoder

ASKER

ty
Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.

50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo