August 5, 2015 at 7:56 am
Hi All,
I am unable to connect to server using windows and SA logins as well we tried with multiple logins still wont work getting below error.
Login failed for user Reason: Token-based server access validation failed with an infrastructure error.
But we can able to connect to Integartion server here integration server is runnning on Ntauthority service account and SQl server is running on Local system.
Please helpon this
August 5, 2015 at 8:08 am
New persopn (8/5/2015)
Hi All,I am unable to connect to server using windows and SA logins as well we tried with multiple logins still wont work getting below error.
Login failed for user Reason: Token-based server access validation failed with an infrastructure error.
But we can able to connect to Integartion server here integration server is runnning on Ntauthority service account and SQl server is running on Local system.
Please helpon this
What have you tried? Searching google for your exact error message returns over 25,000 results. There are so many things it could be.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 6, 2015 at 12:49 am
We added rules fopr TCP port and tried with multiple logins the same logins we can able to connect another server and Integration server in same server as well.
Also checked services are fine and firewall i disabled tried to connect the SQl from another server as well
August 7, 2015 at 7:12 am
Are you sure the users have both permissions to instance as well as each database?
Do the login properties of user have correct permissions and not some that are disabled?
This is where I would start.
August 7, 2015 at 7:31 am
Yes we have the admin access on that instance and we tried with SA account as well we were not able to connect
August 7, 2015 at 9:08 am
Just to clarify in the server properties and DB properties in permissions they all have "Grant" under Connect to SQL? Not "Deny"?
I had this issue last year and it was something I just missed the first time.
Also, if you have a user who has grant, but part of a "Deny" group that could be a problem as well.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply