Unable to connect to the remote server? You’ll get this error even if you are using vSphere local to your vCenter. KB Articles point to checking network settings, connections, even dealing with services. Here’s the answer:
Odds are, if you just randomly started getting this error and vCenter reboots aren’t helping, your database is too large and it’s refusing your connection attempt. When I first discovered this error I was using SQL Express Server 2005. Let’s take a look at limitations.
- SQL Server Express 2005: 4GB
- SQL Server Express 2008 R21: 10GB
- SQL Server 2005-2012: Over 520k TB. So, no limit.
At this point, you have an option to shrink the database, updated SQL to a version that will give you more space, or move the SQL Database to an upgraded SQL version.