October 10, 2011 at 3:42 am
Hi All,
Recently our company had a server change, and therefore the computer domain name changed.
Because of this, I can no longer access a database that was under the other domain name.
Any idea how to go about solving this? I've checked for results on google from others with the same problem, but reinstalling/deleting the database isn't really helpful. And the other methods do not work.
Here is the error message:
The database TestDB is not accessible. (ObjectExplorer)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.get_CanGetChildren()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren(IGetChildrenRequest request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)
Many thanks for your help. Let me know if anything is unclear.
Cheers
Rixxe.
October 10, 2011 at 4:21 am
Software or hardware upgrade doesn’t require Server Name (or Domain Name) changes. I am still guessing the justifications for name changes.
Secondly, you should have backups ready for unforeseen issue (like this). What’s the problem in restoring a database than spending hours in finding a way to fix this?
Just curious to know how big the database is? Is it a production database (I guess NOT)?
October 10, 2011 at 4:34 am
Connecting to the parent company, hence the name change.
It would have made sense to create a copy, and i would have done if i was aware when this change would occur.
None the less i'm stuck with this problem, and i'd still like some help in solving it.
Current database size is a little over 1gb.
Thanks
Rixxe
October 10, 2011 at 5:32 am
It would have made sense to create a copy, and i would have done if i was aware when this change would occur.
Wrong. It always makes sense to keep database backup ready for the worst scenarios (data loss).
However I don’t have solution for your problem but I am very sure someone from the forum will step ahead & help you.
October 10, 2011 at 5:37 am
Are you able to connect to SQL Server instance, at least? If yes, try to detach & attach the database (just a guess).
October 10, 2011 at 5:53 am
try change the instance name!! the follow link that contains the procedure: http://msdn.microsoft.com/en-us/library/ms143799.aspx
October 10, 2011 at 6:16 am
Thanks for the idea about changing the server name, but i get this:
Msg 15247, Level 16, State 1, Procedure sp_dropserver, Line 20
User does not have permission to perform this action.
Msg 15247, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 29
User does not have permission to perform this action.
Also attempted to copy, detach and re-attach however i get this error:
===================================
Cannot show requested dialog.
===================================
Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidthInternal(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidthInternalForPublic(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidth(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SetGridColumnWidth(SqlManagerUIDlgGrid grid, Double[] columnWidthRatio, Int32 columnIndex)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SetDatabasesGridColumnWidths()
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.OnScale()
at Microsoft.SqlServer.Management.SqlMgmt.SqlManagementUserControl.ScaleToFont()
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.DynamicallyEmbedUserControl(ViewInfo vi, TreeNode node)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SelectCurrentNode()
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.InitializeUI(ViewSwitcherTreeView treeView, ISqlControlCollection viewsHolder, Panel rightPane)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
Thanks
R
October 10, 2011 at 6:36 am
in sql server, are you logged with account for system administrator?
October 10, 2011 at 6:49 am
Yes, as there is only one account which should be the admin.
October 10, 2011 at 7:07 am
are you logged like 'sa'?
October 10, 2011 at 7:19 am
Yes that is correct.
October 10, 2011 at 7:52 am
Due to the fact i couldn't find a result. I just decided to re-install.
Perhaps this is the only way.
Thank you all for your imput and help.
Cheers
Rixxe
April 30, 2012 at 3:03 am
Change in computer name (server name) may take you to inaccessibility state for your saved SQL database because of some corruption issue. You can repair your SQL database using a third party tool which will resolve your problem easily. You can take reference from: http://tech.groups.yahoo.com/group/performsqlserverdatabaserecovery/[/url]
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply