September 18, 2007 at 2:33 am
Hi,
I'm using the SQL Management Studio Express from a machine to connect to the sql server(2005 enterprise edition sp2) and modify a table on a database but get the following error.
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
The system cannot find the file specified.
(Microsoft.SqlServer.Express.SQLEditors)
I have DBO rights on the database.
One more thing when I open SQL Server Management Studio Express
I get the following message
Access to the registry key HKEY_CURRENT_USER\Software\Microsot\Microsoft Sql server\90\Tools\ShellSEM denied
After this when I click on continue it opens up.
September 24, 2007 at 8:53 pm
This sounds like a permissions issue with your SSMS installation rather than a database error. You mention that you have dbo rights on the database, but do you have administrative permissions on the computer from which you are attempting to connect?
Can you run the same query using the sqlcmd utility and see if you get the same error.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
September 26, 2008 at 3:31 am
Maverick (9/18/2007)
Hi,
I'm using the SQL Management Studio Express from a machine to connect to the sql server(2005 enterprise edition sp2)and modify a table on a database but get the following error.
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
The system cannot find the file specified.
(Microsoft.SqlServer.Express.SQLEditors)
I have DBO rights on the database.
One more thing when I open SQL Server Management Studio Express
I get the following message
Access to the registry key HKEY_CURRENT_USER\Software\Microsot\Microsoft Sql server\90\Tools\ShellSEM denied
After this when I click on continue it opens up.
I'm having exactly the same issue. However, folder ShellSEM doesn't exist in registry. Can someone please tell me where to start the troubleshooting? Thanks..
Slava
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply