Connecting to an existing repository

Piotr Tokarski - Dataedo Team Piotr Tokarski 21st September, 2020

Now that you've installed Dataedo Web and have a repository ready you need to configure the connection to our repository. If you don't have a repository prepared, check Step 2 in the main guide.

Open Dataedo Web in a browser and choose the Use existing repository option.

Image title

On the next page, specify connection details Dataedo Web will use to access your repository. This page may be split into three main sections explained below.

Image title

First, specify the host and port for your SQL Server or Azure SQL Database instance.

Image title

Next, specify the login used for the first connection. Since this may require upgrading your repository, this login should have the db_owner role in the repository database. While you can use Windows authentication for this connection, the account verified will be the one linked to Dataedo Web's application pool in IIS. In this case, you will need to grant it the required permissions in the database separately.

Image title

Then choose whether a new login should be created for future connections to the repository, or the login provided should be used instead.

If you want to create a new login to be created for these connections, leave the Create dedicated user box checked. Otherwise, if you want to use the same login as specified above, make sure the Create dedicated user box is unchecked.

Then click Connect to repository button.

Image title

Note that creating a new login requires higher privileges on the SQL Server instance and will not work on Azure SQL databases - in these cases make sure the box is unchecked.

The configuration is now complete and you can log in to the application. Use the same credentials as you would in Dataedo Desktop. Note that even in Active Directory or Local Windows authentication mode you will need to include your password to log in.

login_sqlauth

In some cases, you might be asked to enter your license key. If so, paste the entire 8 lines of the key, and click the Use key button.

Image title

You can now access Dataedo Web.

Image title

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.