Error: The system cannot find the file specified. (SQLEditors)

Category: sql server tools

Question

E. Stinnes on Thu, 22 Nov 2007 15:57:48


 

 

I am receiving this error in SSMS whenever I try to view the contents of a table (Object Explorer > right-click on table > Open Table)

 

===================================

 

The system cannot find the file specified.

 (SQLEditors)

 

------------------------------

Program Location:

 

   at Microsoft.VisualStudio.Data.DataProtection.EncryptString(String s)

   at Microsoft.VisualStudio.DataTools.DataServices.DataConnection.SetConnectionStrings(DataConnectionProperties connectionProperties)

   at Microsoft.VisualStudio.DataTools.DataServices.DataConnection.SetConnectionStrings(String connectionString)

   at Microsoft.VisualStudio.DataTools.DataServices.DataConnection..ctor(DataProvider provider, String connectionString, Boolean encryptedString)

   at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionFactory.CreateDataConnectionImpl(Guid provider, String connectionString, Boolean encryptedString)

   at Microsoft.VisualStudio.Data.DataConnectionFactory.CreateDataConnection(Guid provider, String connectionString, Boolean encryptedString)

   at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionManager.CreateDataConnection(Guid provider, String connectionString, Boolean encryptedString)

   at Microsoft.VisualStudio.Data.DataConnectionManager.GetDataConnection(Guid provider, String connectionString, Boolean encryptedString, Boolean update)

   at Microsoft.VisualStudio.Data.DataConnectionManager.GetDataConnection(Guid provider, String connectionString, Boolean encryptedString)

   at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionManager.Microsoft.VisualStudio.Data.Interop.IVsDataConnectionManager.GetDataConnection(Guid& guidProvider, String bstrConnectionString, Boolean fEncryptedString)

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

 

 

The same error occurs if I try to create a new table, edit the design of an existing table, or create a new view.

 

This is fresh install of SQL Server (Workstation components only) on my local WinXP Pro machine. Everything is fully patched/updated.

 

I get the same error while connected to either of two servers, each running Win Server 2003 with SQL Server 2005. However, if I Remote Desktop in to either server, SSMS works perfectly.

 

So it seems this a problem with my local installation. I’ve already tried the reinstallation route, to no avail.

 

How can I fix this?

Replies

Madhu K Nair on Thu, 22 Nov 2007 16:21:58


Looks like the workstation components(tools ) corrupted. You may need to re-install

 

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=954166&SiteID=1

 

Madhu

 

E. Stinnes on Thu, 22 Nov 2007 16:23:46



I have already reinstalled once, with no effect. The error still occurs.

E. Stinnes on Thu, 22 Nov 2007 18:46:58


After numerous installs/uninstalls, and many hours trawling through the detritus of this and other websites, I think I have finally solved the problem.

Surprise! The registry was to blame, as it always seems to be in these cases. Typical MS kludge.

Anyway, in the following key:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

...add a new 'Expandable String Value' called 'AppData' and give it the value:

%userprofile%\Application Data

That took care of the issue.

Such a colossal waste of time. I hope this helps somebody.




Tom Hallstrom on Wed, 28 Nov 2007 09:37:14


Thank you very much!

G-New on Fri, 04 Jan 2008 19:37:29


E.Stinnes,

Thanks a bundle for posting your resolution. It resolved the issue for me as well. I couldn't even get the SSMS install/uninstall to work initially. (Crashed with bizarre crypto errors after the initial splash screen.) Not only did your resolution fix the "cannot find the file specified" problem, but now my install/uninstall is working. Imagine that.

Have a great new year.

atobis_ab on Wed, 04 Jun 2008 19:08:04


Thanks for your solution, everything worked fine, although i found a different solution on my notebook. But think this way is the easiest.

 

Why is there another registry entry called 'local appdata' with reference to '%userprofile%\local settings\application data'

Can i delete the entry or not ??

 

the reference-path isn't there at all, so it's an illegal entry, doesn't it ??

 

Thanks for all, saved me time and trouble.

P_SILVA on Wed, 18 Jun 2008 17:56:54


You saved me a lot of time. Thank you.

rob bartley on Wed, 18 Feb 2009 13:37:16


thanks that worked for me and saved a lot of time

Steve in Crystal Lake Illinois on Sat, 21 Feb 2009 08:44:48


THANK YOU - So Much!!!!

To think my problem was so simply solved because of your work is a tribute to the forum and your willingness to share!!!

StuIAm on Wed, 12 Aug 2009 19:19:09


Wow, this solved a problem that had SQL Server Management and Visual Studio 2008 broken for 3 days.  Thank you so much for your post.

mhbn1966 on Thu, 10 Sep 2009 15:56:05





Thanks very much, you saved the day!

amnippon on Mon, 14 Dec 2009 05:26:50


Thanks ...

It works ...

s_t_e_v_e_l on Tue, 22 Dec 2009 02:21:07


This worked like a champ. Thanks!

Strangely, I removed the above Registry workaround and the problem remains resolved – that is, I cannot reproduce the original error.    :-/

Philippe_G on Fri, 18 Feb 2011 08:32:28


yes, me!! thanks

Erica Folmer on Fri, 29 Jul 2011 10:38:01


Thanks for posting. worked for me as well

Golebaone Polelo on Wed, 17 Oct 2012 08:50:50


Thank you a million times. This solved a lot of problems i.e I coudn't open a table, modify a table etc. Polelo

shawnplusplus on Wed, 21 Feb 2018 21:32:36


Worked for me. You're the man. 

Hasan93 on Wed, 24 Oct 2018 13:14:49


In my case, restarting SQL server instance solved the problem. As simple as that.