SQL Search 1.1 - Access is denied

A free Management Studio add-in to search for SQL in your databases

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, Adam, justin.caldicott

SQL Search 1.1 - Access is denied

Postby duhitsd » Wed Dec 14, 2011 2:50 pm

I am using SQL Server Management Studio 2008 with SQL Search 1.1 and every time I open Management Studio, I recieve the following error:

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
duhitsd
 
Posts: 2
Joined: Wed Dec 14, 2011 2:47 pm

Postby Paul Stephenson » Tue Dec 20, 2011 2:44 pm

Hi duhitsd,

We think this is due to a permissions problem when trying to update SSMS to add SQL Search's Ctrl+Alt+D keyboard shortcut.

Could you check if you have write access to the following directory?

%AppData%\\Microsoft\\Microsoft SQL Server\\100\\Tools\\Shell

The particular files concerned are Current.vsk and User.vsk.

Regards,
Paul Stephenson
SQL Search Project Manager, Red Gate
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby duhitsd » Tue Dec 20, 2011 3:51 pm

From what I can tell, the \\Shell directory is marked as Read Only, which makes the contents of the folder read only as well. The folder is also hidden.

What steps do you suggest trying?
duhitsd
 
Posts: 2
Joined: Wed Dec 14, 2011 2:47 pm


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 1 guest