Shulou(Shulou.com)05/31 Report--

How to make SQL Server Management Studio connect directly to the database? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Every time you connect to the SQLServer database, choose the authentication mode, enter the user name and password, and after logging in, you have to expand the object browser node to access the database. Is there any way to connect directly to the database you want to visit with SQL? The answer is yes. The following editor to explain what are the methods of allowing SQLServerManagementStudio to connect directly to the database?

What are the ways to let SQLServerManagementStudio connect directly to the database?

1. Find the SQLServermanagementStudio shortcut. By default, go to Start-- > AllPrograms-- > MicrosoftSQLServer2005\ 2008R2Mel-> ManagementStudio.

2. Right-click SQLServerManagementStudio, select Properties, and click the Shortcut tab.

3. In the Target column, add the following connection parameters at the end:

For SQLServerAuthentication authentication, add the following parameters:

-S-d-ULoginName-PPassword, for example:-Stecpc-dReportServer-Usa-P123456

For WindowAuthentication authentication, add the following parameters:

-S-d-E, for example:-Stecpc-dReportServer-E

4. SQLServerManagementStudio supports the following four different startup window display types, which we can set according to our own preferences.

ObjectExploper (this is the default window display type) NewQueryWindowObjectExploperandQueryEditorEmptyEnvironment

What are the ways to let SQLServerManagementStudio connect directly to the database?

5. Open SQLServerManagementStudio, click Tools, and select Option.

6. Select General under the Environment option.

7. Click the AtStartup drop-down box and select any one of step 4, for example: ObjectExploperandQueryEditor.

8. Click OK to restart SQLServerManagementStudio.

After completing the above steps, every time you open it through the SQLServerManagementStudio shortcut we have set, it will automatically connect to the SQLServer instance and database we have set.

This is the answer to the question about how to make SQL Server Management Studio connect directly to the database. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.