AnsweredAssumed Answered

Can't Connect to new SQL Server Instance with SQL Manager

Question asked by jborgion Champion on Apr 13, 2016
Latest reply on May 19, 2016 by nerdtude

This really isn't a GIS question per se, but I'm hoping someone can get me moving in the right direction.

 

Today IT created a new instance of SQL Server on which I have created a new Enterprise Geodatabase.  If I log into the actual machine where SQL Server resides, I can use SQL Server2014 Management Studio just fine to administer the new database.  While in the same session of Management Studio, I can connect to another instance of SQl Server on a different server machine.

 

My problem is I can't connect to the new SQL Server Instance from my desktop machine which is on the same network/domain using SQL Server2014 Management Studio.  It tosses a fairly generic error about pipes etc; sometimes it's error 2, sometimes 54  I checked the the new instance properties and 'Allow Remote Connections To This Service' is checked.  I guess remotely logging into the server isn't the end of the world, but I'd rather just hit from my desk top.

 

Vince Angelo...

Outcomes