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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to update credential details on the connection string for Dashboard Server MS SQL Server database ?

How to update credential details on the connection string for Dashboard Server MS SQL Server database ?

The credentials used to connect to the Dashboard Server database in the Syncfusion Dashboard Server can be changed at any time.

Dashboard Server is deployed in the below location by default.

{Windows_Drive}\Syncfusion\Dashboard Server\DashboardServer.Web\

For example, C:\Syncfusion\Dashboard Server\DashboardServer.Web\

We have shipped a utility with the Syncfusion Dashboard Server application in the below location by default.

{Windows_Drive}\Syncfusion\Dashboard Server\Utilities\ConnectionStringEditor

C:\Users\Sasidharan.karuppiah\Desktop\KB\MySQL\DashbordServer\Location.png

Figure 1: ConnectionStringEditor utility installed location.

 

Follow the below steps to change the Database Credentials,

Step 1: Stop the Dashboard Server from the Desktop shortcut – “Stop Syncfusion Dashboard Server”

http://www.syncfusion.com/uploads/user/kb/ump/ump-2088/ump-2088_img2.png

Figure 2: Stop Syncfusion Dashboard Server.

Step 2: Open the ConnectionStringEditor.exe tool in installed location.

 

C:\Users\Sasidharan.karuppiah\Desktop\KB\SQL\DashbordServer\DashboardServer.png

 

Figure 3: Syncfusion Dashboard Server - Connection String Editor form display.

 

Step 3: The connection details that were supplied while starting up the Dashboard Server application will be populated in the utility. The utility will allow to change the Authentication Type and the Server and Database name will not be able to change.

C:\Users\Sasidharan.karuppiah\Desktop\KB\SQL\DashbordServer\Windows.png

Figure 4: Select Windows Authentication type.

C:\Users\Sasidharan.karuppiah\Desktop\KB\SQL\DashbordServer\Sql.png

Figure 5: Select SQL Server Authentication type.

Note: This utility cannot be used when SQL CE database is chosen as the Dashboard Server database in the Syncfusion Dashboard Server.

Step 4: If “SQL Server Authentication” type selected it requires Login and Password to fill. In case of “Windows Authentication” type it doesn’t need to be filled. After filling the connection details proceed to save.

The utility will test the connection to the database with the given details. If the connection test passes, the new connection details will be updated in the connection string of the Dashboard Server database.

 

C:\Users\Sasidharan.karuppiah\Desktop\KB\SQL\DashbordServer\Save.png

Figure 6: Save the connection details.

 

The tool will change the Database Credentials and will return a “success” message if the process underwent successfully.

If there is an error occurred in the process, the tool will generate an error log in text format in the below location and display the error log file name.

Error log file location: %temp%/Syncfusion Dashboard Server/{file_name}

Please create a support incident attaching this error log file for us to check the issue and give a solution.

Article ID: Published Date: Last Revised Date: Platform: Control:
6975 07/12/2016 09/19/2018 Dashboard Platform Dashboard Server
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon 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.Close Icon