Microsoft ssms9/11/2023 ![]() ![]() Completing the quickstart in the Prerequisites section creates an AdventureWorksLT database named mySampleDatabase. In the Connect to database drop-down menu, select mySampleDatabase. Select Options in the Connect to Server dialog box. This tutorial utilizes SQL Server Authentication. To copy the server name or host name, hover over it and select the Copy icon. On the Overview page, review the fully qualified server name next to Server name for your database in SQL Database or the fully qualified server name (or IP address) next to Host for your managed instance in SQL Managed Instance or your SQL Server instance on your VM. Navigate to the database or managed instance you want to query. You'll need the fully qualified server name or host name, database name, and login information to complete this quickstart. ![]() Get the connection information you need to connect to your database. If you simply want to run some ad-hoc queries without installing SSMS, see Quickstart: Use the Azure portal's query editor to query a database in Azure SQL Database. With a managed instance, you must either import the Adventure Works database into an instance database or modify the scripts in this article to use the Wide World Importers database. The scripts in this article are written to use the Adventure Works database. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |