When you open DataSight Administrator, you are presented with a connection window requiring specific credentials, including a user name, password and database location.

A DataSight Administrator user must have the correct administrative privileges to connect to the MS SQL Server instance and perform the administrative actions required, such as creating and backing-up databases, creating users and editing user permissions. (see User Requirements).

Connect to SQL Server at launch

1. Launch DataSight Administrator. The following Connect to Server window appears.
2. In the Connect to Server box, enter the following information:

• Server: Enter the qualified name of your server or choose from the drop down list of available SQL servers. (for example, CAROLYNPC\sqlexpress in the figure).
• Authentication: Select your authentication type (For example, Windows Authentication in the figure). For details, see Modes of User Authentication.
• User name: Enter the name of a user with access to the server (This is not required for Windows Authentication).
• Password: Enter the password for the specified user (This is not required for Windows Authentication).
• You can elect to Remember Me by ticking the check box for future logins to this sever.

3. Then click Connect.
4. Once you've entered your details and DataSight Administrator opens, your connection status (Connected to Server: [SQL server name]) will be displayed in the Status Bar of DataSight Administrator, at the bottom left of the window.          

Exit current server and connect to a new server

1. Click Application Tab.
2. Then click Connect to Server.
3. Repeat steps 2 through 4 in Connect to Server at launch.

See also:

• Modes of User Authentication