Allow SQLServerManagementStudio to directly connect to the database

Source: Internet
Author: User
Tags microsoft sql server 2005 management studio sql server management sql server management studio
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.