Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Tuesday, 14 February 2017

Local admin access users can not access S S M S (SQL Server Management Studio)


Local admin access users can not access S S M S (SQL Server Management Studio)

 when a user is having local admin access he can’t able to log in to S S M S (SQL Server Management Studio). It will give log in error

If user needs to get access to S S M S (SQL Server Management Studio) he should need to get sysadmin access or part of built in administrator group or any sysadmin group of AD

Here you can test user 


He is part of Administrator Group as see below



But when he tried to log into SQL Management Studio he will get error as see below




Keep Blogging !!!!!!!!!!