Article ID: 116881, created on Aug 23, 2013, last review on Sep 23, 2014

  • Applies to:
  • H-Sphere 3.6.1
  • H-Sphere 3.6.2
  • H-Sphere 3.6.3

Symptoms

Unable to create MSSQL DataBase with the following error in H-sphere log file:

    Psoft.HSphere.Transport.Protocols.ProtocolException: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

Or

MS SQL manager could not connect to the server.

Cause

MSSQL server is not configured properly.

Resolution

Go to C:\Program Files\HSphere\Config\hsphere.config file and make sure the NAME_OF_YOUR_SQL_SERVER is set correctly in:

    prop name="mssqlserver" value="NAME_OF_YOUR_SQL_SERVER" description="MSSQL server name or IP"

Please use full MSSQL server name, for example:

    value="MASTER\SQLEXPRESS"

Make sure that MS SQL server IP set as a logical server IP in the E.Manager menu is set in Start -> Programs -> MSSQL 2005 Server -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP(enabled) -> Properties -> IP Addresses tab. Make sure this IP is there with Active and Enabled set to Yes and TCP Port for corresponding IP address and for IPAll set to 1433.

Search Words

Psoft.HSphere.Transport.Protocols.ProtocolException: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

MS SQL manager could not connect to the server

I just logged into customer account "account" and tried to add the SQL db - account_dbname and I received an internal error.I just logged into customer account "account" and tried to add the SQL db - account_dbname and I received an internal error.

Unable to create MsSQL DataBase

1a2ef5d5f346a43e1324533020837760 6311ae17c1ee52b36e68aaf4ad066387 f213b9fa8759d57bee5d547445806fe7 2e39a5e5b1423cc126cf735bac076008 e5eac925e853cc7ef3f6055683c98fbb 6b908665c0d1eca5bdd0141a32fd712a

Email subscription for changes to this article
Save as PDF