After getting SQL server management studio installed on desktop, getting error while trying to connect to geodatabases on SQL server 2012. ArcGIS 10.4.1 Appreciate any help!
Getting the error above after installing SQL server management studio 2016
Did you rename the database or restore the geodatabase with a different name?
Getting the error above after installing SQL server management studio 2016
The connection was working before you installed the SQL Server 2016 Management Studio?
What version is your Enterprise geodatabase?
As far as I know nothing has changed with those geodatabases.
Enterprise Geodatabase version 10.3
Yes, the connections were working before the SQL server mgmt studio 2016 was installed
Microsoft SQL Server database requirements for ArcGIS 10.3.x—Help | ArcGIS Desktop
MS SQL Server 2016 is not supported with ArcGIS 10.3.x. So maybe the installation of the SQL Server 2016 Management Studio installed some DLLs\files which is not supported with the 10.3.x gdb.
1. Uninstall Management Studio 2016 and install the 2012\2014 version if you can and then check
2. Can you upgrade the enterprise geodatabase to 10.4.1?
Will try your suggestions. Very helpful. Thank you!
The error occured when I renamed the database or restored it with a different name. How I can fix it if I need a different name of the database?
Thank you.
If you are using SQL Server you cannot change the name of the restored DB from the backup. You would need to restore with the original name on a new SQL Instance and then copy the data into a new SQL Server Enterprise Geodatabase with the "new" name.
Did anyone find a fix?