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)
MS SQL manager could not connect to the server.
MSSQL server is not configured properly.
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:
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.