Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Forum Statistics

Users
Members:
1875
Members Online:
2
Guests Online:
94

Total Post History
Posts:
81447
Topics:
18714

7-Day Post History
New Posts:
0
New Topics:
0
Active Topics:
0

Our newest member
konam534As

Other

FAQ
All times are UTC [ DST ]

Google Ads

Error popup (permission issue)

Please wait...

Error popup (permission issue)

Postby lareau on Thu May 30, 2013 9:06 am

Hey,

I'm running the tool on a Sql 2008R2 database and get the error attached.
I'm assuming that it's because I only have access to the database & not the server.

SqlCopError.png
You do not have the required permissions to view the files attached to this post.
lareau
Apprentice
Apprentice
LTD Bronze - Rating: 1
 
Posts: 20
Joined: Fri Oct 15, 2010 7:11 pm
Unrated

Re: Error popup (permission issue)

Postby gmmastros on Thu May 30, 2013 9:20 am

That's correct. Specifically, you need:

"Requires VIEW SERVER STATE permission on the server."

http://technet.microsoft.com/en-us/libr ... 87743.aspx


This SQLCop check should be looking for the appropriate permissions prior to running the check. Ideally, SQLCop would return something like, "You do not have the appropriate server privileges for this check."

Thank you for bringing this to my attention.
-George
User avatar
gmmastros
LTD Admin
LTD Admin
LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630
LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630LTD Gold - Rating: 1630
LTD Gold - Rating: 1630LTD Gold - Rating: 1630
 
Posts: 2367
Joined: Tue Oct 09, 2007 5:19 pm