Failed to Connect to the Specified server.Arcgis server database connection failure

Question

Hello guys,

I am currently working in Ms sql server 2008 and ArcGIS server 10.1. I made a copy of my database in Ms SQl (just not to work on my original database) and I wanted to work on this copy connecting in ArcGIS server. While trying to connect in the ArcGIS server, I am getting an error : FAILED TO CONNECT TO THE SPECIFIED SERVER. DO YOU WANT TO CONTINUE? OPERATION FAILED. The new copy have the same permission as the original and its on the same server as the original one. I will be thankful if anyone can tell me how to fix this error or any suggestion 🙂

cheers, 
Bezaye

RebeccaStrauch__GISP · Answer

Joe, can you find or install another (temp) SQL instance and restore it there.  Then copy the data to where you need it?  I am not an expert, but from everything I have every seen re the SDE restores, it must be to the same name to work.

Lake_Worth_BeachAdmin · Answer

I have an old backup of a database, I wanted to restore but I cant use the same name because there is already a database in the instance with that name... I renamed it but not being able to connect to it.

TinaMorgan1 · Answer

This thread is a bit older, but wanted to add a tid bit from a case I just got.

If you happen to rename the database in SQL Server, and do not remember the original geodatabase name, you can check that in the database_name column of your sde_table_registry table.  That table hard codes the name of the database as it was when the geodatabase was created.

Methods to move a geodatabase in SQL Server—Help | ArcGIS Desktop