Add new MSSQL Serve...
 
Notifications
Clear all

Add new MSSQL Server as service?

4 Posts
2 Users
0 Likes
1,273 Views
Posts: 2
Topic starter
(@anuyo)
New Member
Joined: 7 years ago

Hello,

 

I am playing around with SolidCP and thinking to try this for a small business.

I installed SolidCP on server A while access the DB from server B that is running MSSQL 2012 Express. Portal and basic web service are working so far.

However, when I trying to add the MSSQL 2012(server B) as service on the SolidCP server A, I am keep getting error trying to access the MSSQL 2012 on server B.

 

Could someone please provide a example how does it usually setup when adding MSSQL service? After google for about a hour, I could not find any information about this at all.

 

Thanks!

3 Replies
Posts: 1963
Admin
(@m-tiggelaar)
Noble Member
Joined: 8 years ago

Hello,

Usually this is because you have not started the mssql browser service

without it set to automatic and started the mssql server will only listen to it's local instance name and not any ip or network dns name (i generally always recommend a network dns name as on any migration you can easily move mssql servers including ip's without having to re-set it on any websites).

Regards,

Marco

Reply
Posts: 2
Topic starter
(@anuyo)
New Member
Joined: 7 years ago

Hi Macro,

I already have MSSQL browser service set to auto running/auto start during the initial install for SolidCP on server B.

 

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.94.199.151:80
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.Providers.ServiceProvider.Install()
at SolidCP.EnterpriseServer.esServers.InstallService(Int32 serviceId)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.esServers.InstallService(Int32 serviceId)
at SolidCP.Portal.ServersEditService.btnUpdate_Click(Object sender, EventArgs e)

 

I notice when I setting the server B as MSSQL as service, it will keep popping error unable to access port 80. Which I check the listening port on server B, there is none because its only running MSSQL 2012 express on server B. Do I have to install IIS on the server B in order for SolidCP to add server B as MSSQL service?

 

Thank you

Reply
Posts: 1963
Admin
(@m-tiggelaar)
Noble Member
Joined: 8 years ago

Well what are your connection settings? as it shouldn't be checking on port 80.

that being said SolidCP Server needs to be installed on server B (it's to control the roles on the actual server such as mssql).

Reply
Share: