Connect Microsoft SQL Server
1. Create a SQL Server read-only user
It is recommended that you create a read-only user with table-level permissions that Bigeye can use to connect to SQL Server.
Launch SQL Server Management Studio and connect with credentials that have been granted the ‘sa’ role.
Expand Security, right-click on Logins and select New Login.
Enter a descriptive Login name, select SQL Server authentication, and enter a secure password. On the bottom of the page select the database Bigeye will be connecting to as the Default database.
Select the User Mapping tab, check the box next to the desired database, confirm that only ‘public’ is selected, and click OK.
Click the New Query button and select the database you are connecting to Bigeye.
Paste the following query into the query window and execute. Replace “bigeye_read_only” with the actual username of the user you created.
SELECT 'GRANT SELECT ON "' + TABLE_SCHEMA + '"."' + TABLE_NAME + '" TO "bigeye_read_only"' FROM information_schema.tables
Select and copy the query results into the query window.
Remove any tables or views you do not wish the “bigeye_read_only user” to have access to.
Execute the query.
Next you will need to grant view definition on the dbo schema. Copy the below query and execute it in SQL Server. Replace the username with the username you created earlier.
GRANT VIEW DEFINITION ON SCHEMA :: dbo TO bigeye_read_only
You can now use these credentials to connect Bigeye to your database with read-only permissions on only the tables you have specified.
2. Allow Bigeye to connect to SQL Server from a local machine
There are a couple of configurations you’ll need to make to use Bigeye with a local SQL Server:
- Forward traffic from our external IP ( 188.8.131.52 ) on port 1433 to the internal IP address of your desktop computer.
- Allow access to SQL Server via the Windows firewall. For more information, refer to Microsoft’s page about configuring the Windows firewall.
3. Add SQL Server as data source in Bigeye
From the Catalog tab in the sidebar, select Add Source. This will take you to a page where you can configure the connection to your database.
To connect SQL Server, you will need to input the following information:
- Alias -- any name you choose
- Vendor - SQL Server
- IP address/hostname
- Port - default port for SQL Server is
- Database name
- Username - username for database
- Active Directory Domain
- Password - password for database
Once filled out, the form should look something like this
4. Next Steps
Bigeye will now start loading and profiling your tables. It can take up to 24 hours for the profiling to complete and your autometrics/autothresholds to populate. You can now proceed to deploying autometrics in the Getting Started guide.
Updated 9 months ago