Windows Server 2008 - Exception & file copy question
PDinCA
Posts: 642 Silver 1
When I try to use the "Options" dialog in VSMS2008 on a Windows Server 2008 box (brand new last week), I get:
16 Jan 2009 01:31:52,285 [3] ERROR RedGate.SQLPrompt.CommonUI.Options.Preferences - Could not load file 'C:\Users\me\AppData\Local\Red Gate\SQL Prompt 3\RedGateRefactorOptionSetDefaults'
System.IO.IOException: The process cannot access the file 'C:\Users\me\AppData\Local\Red Gate\SQL Prompt 3\RedGateRefactorOptionSetDefaults' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at System.IO.File.ReadAllBytes(String path)
at RedGate.SQLPrompt.CommonUI.Options.Preferences.d(String )
Also, as this is the main Production Server, I'd like to copy my workstation EngineOptions.xml file to this box, - is that permissible? as I have all my table aliases defined there and really do not want to have to load them again...
16 Jan 2009 01:31:52,285 [3] ERROR RedGate.SQLPrompt.CommonUI.Options.Preferences - Could not load file 'C:\Users\me\AppData\Local\Red Gate\SQL Prompt 3\RedGateRefactorOptionSetDefaults'
System.IO.IOException: The process cannot access the file 'C:\Users\me\AppData\Local\Red Gate\SQL Prompt 3\RedGateRefactorOptionSetDefaults' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at System.IO.File.ReadAllBytes(String path)
at RedGate.SQLPrompt.CommonUI.Options.Preferences.d(String )
Also, as this is the main Production Server, I'd like to copy my workstation EngineOptions.xml file to this box, - is that permissible? as I have all my table aliases defined there and really do not want to have to load them again...
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...
Decide wisely...
Comments
Once installed, run it and go 'Find' > 'Find handle or dll..', type in 'RedGateRefactorOptionSetDefaults' and then 'Search'. Does it show any processes with a handle on the file?
Regarding the EngineOptions.xml file; there's no reason why you can't copy the file over as long as you have the same versions installed on both your workstation and server. As always, I'd save a copy of the server options before you copy over the workstation options.
Thanks for the pointer on the options being transferrable.
Decide wisely...