associate-a-query-with-a-connection-in-a-project.md

title	Associate a Query with a Connection in a Project
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.reviewer
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	connections [SQL Server Management Studio], query associations projects [SQL Server Management Studio], connections projects [SQL Server Management Studio], query connections query associations [SQL Server Management Studio]
ms.assetid	c9625ae0-29c1-4179-a709-51b7e2f9e23d
author	markingmyname
ms.author	maghan

Associate a Query with a Connection in a Project

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] If a query was created without a connection, or if a query is moved from one project to another it will not be associated with a connection in the current project.

To associate a query with a connection in a project

1. If the query is open in query editor, right-click a blank area of query editor, point to Connection, and then click Connect. If the query is not open, double-click the query in Solution Explorer to connect the query.

2. In the Connect to Database Engine dialog box, provide the connection information. If the connection information matches an existing connection, the query will be associated with that connection.

See Also

Solution Explorer
Change the Connection Associated with a Query
View or Change the Properties of a Connection in a Project