User Guide Getting Started Help Center Documentation Community Training
  
English
日本語
Microsoft SQL Server (MSSQL)

Encrypting Network Traffic

Looker strongly recommends encrypting network traffic between the Looker application and your database. Consider one of the options described here.

If you’re interested in using SSL encryption, see the Microsoft documentation.

Configuring Server Authentication

Looker requires “SQL Server Authentication” on your MSSQL server, but server’s can also be configured for “Windows Integrated Authentication” only. That will need to be changed to “Windows Integrated Authentication and SQL Server Authentication”.

If this is not set properly Looker will be unable to connect. This will appear in your SQL Server log messages like: “An attempt to log in using SQL authentication failed. Server is configured for windows authentication only.”

If this change is required you can complete the following steps:

  1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
  2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
  3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
  4. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.

You can read about this more in Microsoft’s documentation.

Creating a Looker User

Looker authenticates to your database using SQL Server Authentication. Using a domain account is not supported.

To create an account, run the following commands. Change some_password_here to a unique, secure password:

CREATE LOGIN looker
  WITH PASSWORD = 'some_password_here';
USE MyDatabase;
CREATE USER looker FOR LOGIN looker;
GO

Granting the Looker User Permission to SELECT from Tables

Looker requires the SELECT permission for each table or schema you will want to query. There are multiple ways to assign SELECT permission:

Granting the Looker User Permission to View and Stop Running Queries

Looker requires rights to detect and stop currently running queries, which requires the following permissions:

To grant these permissions, run the following commands:

USE Master;
GRANT ALTER ANY CONNECTION TO looker;
GRANT VIEW SERVER STATE to looker;
GO

Granting the Looker User Permission to Create Tables

To give the Looker user the permission to create PDTs, issue the following commands:

USE MyDatabase;
GRANT CREATE TABLE to looker;
GO

Temp Schema Setup

To create a schema owned by the Looker user and grant the necessary rights to the Looker user, issue this command:

CREATE SCHEMA looker_scratch AUTHORIZATION looker;

Feature Support

Looker’s ability to provide some features depends on whether the database dialect can support them.

In the current Looker release, Microsoft SQL Server supports the following Looker features:

Next Steps

After completing the database configuration, you can connect to the database from Looker using these directions. When you select your dialect, be sure to choose between the 2005 and 2008+ options as appropriate. Microsoft SQL Server versions 2008 and later support additional timeframe features.

Top