Telecomm
asked on
Error When Attempting to Re-Attach SharePoint Database
I was in the process of moving databases from a SharePoint 2010 environment to a new disk array when Management Studio started giving me this error when trying to re-attach them:
========================== =========
Cannot show requested dialog.
========================== =========
Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridC ontrol)
-------------------------- ----
Program Location:
at Microsoft.SqlServer.Manage ment.UI.Gr id.GridCon trol.SetCo lumnWidthI nternal(In t32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
at Microsoft.SqlServer.Manage ment.UI.Gr id.GridCon trol.SetCo lumnWidthI nternalFor Public(Int 32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
at Microsoft.SqlServer.Manage ment.UI.Gr id.GridCon trol.SetCo lumnWidth( Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
at Microsoft.SqlServer.Manage ment.SqlMa nagerUI.At tachDataba se.SetGrid ColumnWidt h(SqlManag erUIDlgGri d grid, Double[] columnWidthRatio, Int32 columnIndex)
at Microsoft.SqlServer.Manage ment.SqlMa nagerUI.At tachDataba se.SetData basesGridC olumnWidth s()
at Microsoft.SqlServer.Manage ment.SqlMa nagerUI.At tachDataba se.OnScale ()
at Microsoft.SqlServer.Manage ment.SqlMg mt.SqlMana gementUser Control.Sc aleToFont( )
at Microsoft.SqlServer.Manage ment.SqlMg mt.ViewSwi tcherContr olsManager .Dynamical lyEmbedUse rControl(V iewInfo vi, TreeNode node)
at Microsoft.SqlServer.Manage ment.SqlMg mt.ViewSwi tcherContr olsManager .SetView(I nt32 index, TreeNode node)
at Microsoft.SqlServer.Manage ment.SqlMg mt.ViewSwi tcherContr olsManager .SelectCur rentNode()
at Microsoft.SqlServer.Manage ment.SqlMg mt.ViewSwi tcherContr olsManager .Initializ eUI(ViewSw itcherTree View treeView, ISqlControlCollection viewsHolder, Panel rightPane)
at Microsoft.SqlServer.Manage ment.SqlMg mt.LaunchF orm.Initia lizeForm(X mlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Manage ment.SqlMg mt.LaunchF orm..ctor( XmlDocumen t doc, IServiceProvider provider)
at Microsoft.SqlServer.Manage ment.UI.VS Integratio n.ObjectEx plorer.Too lMenuItemH elper.OnCr eateAndSho wForm(ISer viceProvid er sp, XmlDocument doc)
at Microsoft.SqlServer.Manage ment.SqlMg mt.Running FormsTable .RunningFo rmsTableIm pl.ThreadS tarter.Sta rtThread()
Managament-Studio-Error.JPG
==========================
Cannot show requested dialog.
==========================
Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridC
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
Managament-Studio-Error.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I went ahead and restarted the server, then ran SSMS as an administrator (right click Run As) and it worked from that point on.