Guide to SQL Server DBAs and Developers
Login failed for user Reason: Token-based server access validation failed with an infrastructure error Login lacks Connect SQL permission. Login failed for user ‘localhost\windows_user’. Reason: Token-based server access validation failed with an infrastructure error. Login lacks Connect SQL permission. [CLIENT: <local machine>] Check you have permission to the user, generally we will have permission. Check you are able to access SSMS local & remote. Most of the case issue will be – Check how many group
Query running fast in production and slow in non-production I have asked to look one of the queries that run fast in production and slow in non-production. Question asked – how long it took to complete the results. It is about 1.50 minutes in non-production, but in production it completed less than 5 seconds. Got the code and run myself in SSMS to compare the plan, since it will finish 1.50 minutes. It quickly showed estimated number of rows are totally different. This could be either out of stats or data