Error Dialog When Using SSMS - Invalid name character in Workstation Id

timetrak_aw

I am getting an error dialog on an extremely frequent basis whenever I do any of the following in SSMS:

• Saving Scripts
• Executing Scripts
• Change Tabs
• Scrolling Object Explorer

I have no idea where this issue is coming from, but I'm getting very close to a point where I may have to uninstall SQL Prompt so that I can use SSMS without spending half of my time closing error dialogs.

Error Dialog Screenshot:


From the log file:
03 May 2017 14:33:59,035 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Document saved
03 May 2017 14:33:59,036 [1] ERROR RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog - Report error dialog shown
System.ArgumentException: Invalid name character in 'workstation id'. The ' ' character, hexadecimal value 0x20, cannot be included in a name.
at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname)
at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns)
at Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo.SaveToStream(XmlWriter writer, Boolean saveName)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.WriteConnectionString(UIConnectionInfo connectionInfo, XmlWriter xmlWriter)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.ToConnectionString(UIConnectionGroupInfo connectionGroupInfo)
at RedGate.SQLQueryKeeper.TabWatcher.StoreDocument(Document document, SaveReason saveReason)
at RedGate.SQLQueryKeeper.TabWatcher.<>c__DisplayClass42_0.<DocumentSaved>b__0()
at RedGate.SQLQueryKeeper.ErrorReporting.DoWithErrorReporting(Action action)
03 May 2017 14:34:06,973 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Query executed
03 May 2017 14:34:06,974 [1] ERROR RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog - Report error dialog shown
System.ArgumentException: Invalid name character in 'workstation id'. The ' ' character, hexadecimal value 0x20, cannot be included in a name.
at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname)
at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns)
at Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo.SaveToStream(XmlWriter writer, Boolean saveName)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.WriteConnectionString(UIConnectionInfo connectionInfo, XmlWriter xmlWriter)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.ToConnectionString(UIConnectionGroupInfo connectionGroupInfo)
at RedGate.SQLQueryKeeper.TabWatcher.StoreDocument(Document document, SaveReason saveReason)
at RedGate.SQLQueryKeeper.TabWatcher.<QueryExecuted>b__41_0()
at RedGate.SQLQueryKeeper.ErrorReporting.DoWithErrorReporting(Action action)
03 May 2017 14:34:30,873 [1] ERROR RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog - Report error dialog shown
System.ArgumentException: Invalid name character in 'workstation id'. The ' ' character, hexadecimal value 0x20, cannot be included in a name.
at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname)
at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns)
at Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo.SaveToStream(XmlWriter writer, Boolean saveName)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.WriteConnectionString(UIConnectionInfo connectionInfo, XmlWriter xmlWriter)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.ToConnectionString(UIConnectionGroupInfo connectionGroupInfo)
at RedGate.SQLQueryKeeper.TabWatcher.StoreDocument(Document document, SaveReason saveReason)
at RedGate.SQLQueryKeeper.TabWatcher.<>c__DisplayClass35_0.<WindowActivated>b__0()
at RedGate.SQLQueryKeeper.ErrorReporting.DoWithErrorReporting(Action action)
03 May 2017 14:38:30,894 [1] INFO RedGate.SQLQueryKeeper.TabWatcher - Query executed
03 May 2017 14:38:30,896 [1] ERROR RedGate.SQLPrompt.CommonUI.Utils.ErrorDialog - Report error dialog shown
System.ArgumentException: Invalid name character in 'workstation id'. The ' ' character, hexadecimal value 0x20, cannot be included in a name.
at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname)
at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns)
at Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo.SaveToStream(XmlWriter writer, Boolean saveName)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.WriteConnectionString(UIConnectionInfo connectionInfo, XmlWriter xmlWriter)
at RedGate.SQLQueryKeeper.UIConnectionInfoUtils.ToConnectionString(UIConnectionGroupInfo connectionGroupInfo)
at RedGate.SQLQueryKeeper.TabWatcher.StoreDocument(Document document, SaveReason saveReason)
at RedGate.SQLQueryKeeper.TabWatcher.<QueryExecuted>b__41_0()
at RedGate.SQLQueryKeeper.ErrorReporting.DoWithErrorReporting(Action action)

timetrak_aw

Didn't think to put this in the original post... SSMS is 13.0.16106.4. SQL Prompt version is 7.5.1.1000. Error comes up in a 2016 SQL Server (13.0.4001.0) or 2014 SQL Server (12.0.2000.8). If there's anything else that might be helpful, let me know.

MikeK

I'm having the exact same issue, but my error states the invalid character is in the network library.

Anu D

Hi Mike and timetrak_aw,

Thanks for the post and reporting the issue to us.

We are looking into this issue and logged this as a bug in our internal tracking system whose tracking id is SP-6321.

I will email you as soon as we have further update.

Russell D

This was fixed in 8.0.2.1508 so if you haven't already please update.