We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

The SQL Server could not be contacted

Thread ID:

Created:

Updated:

Platform:

Replies:

121476 Dec 17,2015 10:18 PM Dec 18,2015 10:43 PM Dashboard Platform 3
loading
Tags: Dashboard Designer
Arthurj
Asked On December 17, 2015 10:18 PM

Hi! 
I did the installation of the Syncfusion Dashboard Designer in Windows 2008 Server (Virtual Machine). 
I did the installation of the IIS 7 and SQL Server 2012 Express with Tools in the same VM with default installation. TCP/IP enable. It seems that is working well. 
I did a Dashboard from the Sql Server datasource, but when I tryied to Preview appears an error in the web browser: 'The SQL Server could not be contacted'
I disable the firewal and start the SQL Server Browser services, but it is not solve the problem.
Please let me know if the Preview works without the Dashboard Server or what else I need to setup. 

Attachment: Error1_ff29e38b.zip

Vinod Kumar R [Syncfusion]
Replied On December 18, 2015 07:45 AM

Hi Arthur,
Thanks for using Syncfusion Products.
 The preview in Syncfusion Dashboard Designer don't require Syncfusion Dashboard Server to be installed as a prerequisite. It will work. The reason for the issue that you faced might be due to the local account settings in SQL server w.r.t Windows Service. Please follow the procedure as suggested in the attached document which is a simplified reference from the MSDN blog (http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/01/30/testing-connection-to-sql-server-from-a-service-running-under-local-system-account.aspx) to get this problem resolved at your end.
http://www.syncfusion.com/downloads/support/directtrac/146733/ze/Running_windows_service_with_Local_connection894863326
Also we would like to inform you that this problem will no longer occur in our Syncfusion Dashboard Platform v1.1.0.136 (Service Pack) as we replaced running our Dashboard Service as Windows Service with IIS Express in our installation process. The setup is available for download under the following link 
http://www.syncfusion.com/forums/121454/syncfusion-dashboard-server-v1-1-0-136-service-pack-is-available-for-download.
Please let us know if you require any further assistance.
Regards,
Vinod

Arthurj
Replied On December 18, 2015 03:33 PM

Hi Vinod,

Thank you for you help! 

I tryed to setup the SQL Server account following the link suggested, but I can not setup the NT AUTHORITY\SYSTEM in Sql Server because appears a message error that does not exist this account. 

Then I decided to install the new patch, but this file is missing the folder Utilities without the Syncfusion Dashboard Service and appears a message error attached. 

Then I did a copy of the folder Utilities from the older version, but the error still happened. 

Then I decided to back to the older version that seems more stable and I did the installation of the Dashboard Server. Now I can see the dashboard running in the server, it is wonderfull, but I can not use the Dashboard Preview in the Designer. Please let me know when the patch will be ok.

Attachment: serviceerror_50842946.zip

Vinod Kumar R [Syncfusion]
Replied On December 18, 2015 10:43 PM

Hi Arthur,

Thanks for your update.

As we mentioned in our previous update, we replaced the deployment of dashboard service running in windows service with the one hosted in IIS Express to avoid the overhead of running the service as a background process always even when not in use. Hence, you cannot find the Utilities folder. W.r.t the error message that you got with our service pack, it instructs that IIS Express as a prerequisite on top of which Syncfusion Dashboard Designer need to be installed. This has been illustrated in the System Requirements page below.
http://help.syncfusion.com/dashboard-platform/system-requirements#software-requirements

Can you please install IIS Express and then install our service pack build? It will no longer display the message that you specified while running the preview.

Regarding the "SQL Server could not be contacted" error message after previewing the dashboard, the above mentioned reinstallation process should take care of this issue, as the problem is suspected to be with the NT AUTHORITY/SYSTEM account configuration in SQL Server at your end.  Please let us know if the issue still exists.

Regards,
Vinod

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;