Welcome to the Windows community forum and interact with 3 million technical staff to enter the Authentication Mode and enter the user name and password each time you connect to the SQLServer database, after logging on, you have to expand the Object Browser node to access the database. Is there a way to use SQL to directly connect to the database we want to access? The answer is yes. Next we will
Welcome to the Windows community forum and interact with 3 million technical staff> choose Authentication Mode and enter the user name and password each time you connect to the SQL Server database, after logging on, you have to expand the Object Browser node to access the database. Is there a way to use SQL to directly connect to the database we want to access? The answer is yes. Next we will
Welcome to the Windows community forum and interact with 3 million technicians>
Each time you connect to the SQL Server database, select Authentication Mode and enter the user name and password. After you log on, You must expand the Object Browser node to access the database, is there a way to use SQL to directly connect to the database we want to access? The answer is yes. Next we will introduce the following configuration to directly access the specified database.
1. Find the SQL Server management Studio shortcut. By default, you can choose Start> All Programs> Microsoft SQL Server 2005 \ 2008 R2> Management Studio.
2. Right-click SQL Server Management Studio, select Properties, and click the cut tab.
3. In the Target column, add the following connection parameters at the end:
If the SQL Server Authentication method is used, add the following parameters:
-S -D -U LoginName-P Password, for example,-S tecpc-d ReportServer-U sa-P 123456
If the Window Authentication method is used, add the following parameters:
-S -D -E, for example,-S tecpc-d ReportServer-E
4. SQL Server Management Studio supports the following four display types of startup windows. You can set them according to your preferences. For specific settings, see 5, 6, and 7:
Object Exploper (this is the default window display type)
New Query Window
Object Exploper and Query Editor
Empty Environment
5. Open SQL Server Management Studio, click Tools, and select Option.
6. Select General under the Environment option.
7. Click the At Startup drop-down box and select any type in Step 4, for example, Object Exploper and Query Editor.
8. Click OK to restart SQL Server Management Studio.
After completing the preceding steps, each time you open the SQL Server Management Studio shortcut that we set, it will automatically connect to the SQL Server instance and database we set.