New Install -Developer Edition SSMS - cannot create an editor error

Question

Post reply

New Install -Developer Edition SSMS - cannot create an editor error

Bruce Edney

SSC Veteran

Points: 245
More actions
November 26, 2009 at 2:28 pm

#385854

Hi
I have just got a new laptop (DELL Latitude E5400 - XP SP3) and have installed SQL Server 2008 Dev.
I can use SQL fine under the user acct that it was installed under but it will not work for me (even as local administrator) I get the following error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot create an editor.
------------------------------
ADDITIONAL INFORMATION:
Absolute path information is required. (mscorlib)
and the tech trace is:
===================================
Cannot create an editor.
===================================
Absolute path information is required. (mscorlib)
------------------------------
Program Location:
at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String path)
at System.Environment.GetFolderPath(SpecialFolder folder)
at Microsoft.SqlServer.Management.UserSettings.QEResultsSettings.get_ResultsDirectory()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.DoPostInit()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.Initialize(Object sp, String moniker)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.CreateInstance(Object serviceProvider, Boolean withEncoding, String moniker)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.EditorFactorySql.CreateEditorInstance(IServiceProvider serviceProvider, Boolean storeActiveConnIfNeeded, String moniker)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.EditorFactoryBase.Microsoft.VisualStudio.Shell.Interop.IVsEditorFactory.CreateEditorInstance(UInt32 createFlags, String moniker, String physicalView, IVsHierarchy hierarchy, UInt32 itemId, IntPtr existingDocData, IntPtr& docViewIntPtr, IntPtr& docDataIntPtr, String& caption, Guid& cmdUIGuid, Int32& result)
I think it is a permissions issue (maybe with .net) but I have no idea where to start looking
PLEASE HELP!!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

support.sql Default port Points: 1444 More actions · Answer 1

It looks a Microsoft internal bug.

Take as reference this note.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=464549&wa=wsignin1.0

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com[/url]

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

Bruce Edney SSC Veteran Points: 245 More actions · Answer 2

Hi

Thanks for your reply

I have since found the issue relates to our IT Dept creating a local Home drive and moving 'My Documents' to this drive. They have some fancy script to do all this and it breaks some .net or Sql server settings.

We have gone back to the old way of doing things (as it was on my old laptop) and it all works fine.

Regards

Bruce

mmontgomery 42818 SSC Veteran Points: 271 More actions · Answer 3

Hello,

I am getting this same error when I install sp1 for sql server 2008. It is fine when I uninstall sp1. It is on a new install of windows 7. Other users on the same network and os do not have an issue. Any ideas what is going wrong?

Thanks

Michael