On the tab Connections you can create, edit and delete connections to databases.
The button next to the field Database Server wil scan your network for SQL Servers and list the ones that can be found. For this to work the SQL Server Browser on the SQL Server must be running and the SQL port should be 1433. If the SQL Browser is not running or the port is anything other than 1433 or there is a firewall between the servers, the search may come up empty.
The button next to the field Database Name will list all databases found on the server in the field Database Server. For this to work the login information in the other fields needs to be correct for the server listed.
- Connection Name: The name of this connection. This is a required field. The name must be unique.
- Database Server: The SQL server you wish to connect to. Use the button to search for SQL Servers. This uses the SQL Browser and port 1433.
- Database Name: The exact name of the database you wish to connect to. A separate connection is required for every database. Use the button to show all databases that are on the selected server.
- Login Name: The SQL Server login you want to use. If you use Windows Authentication, you can leave this field blank.
- Password: The password for the SQL Server login, if used.
- Data Provider is always SQL, for MS SQL Server. We do not support any other kind of connection (yet).
Any correctly configured connection offers the possibility to backup the selected database, assuming you have the correct permissions to perform a backup. The path entered in the field “Backup Location” should be a valid path on the SQL Server itself. Sequenchel is not (yet) capable to perform backups to the local machine if the local machine is not the SQL Server itself. A valid path can be a networkpath as long as it’s a valid networkpath as seen from the SQL Server.
Choose one connection to be the default connection. This connection will be loaded automatically when Sequenchel starts.