Displaying Data Sources in Server Explorer
Server Explorer displays database connections beneath the Data Connections node, and links to servers beneath the Servers node.
Server nodes can be expanded to display Event Logs, Message Queues, Performance Counters, Services, and SQL Servers. The access a user has to a server and its databases determines which data resources can be displayed.
Note The Servers node of the Server Explorer is not available in the Standard Edition of Visual Basic and Visual C# .NET.
When a data connection is established, you can design programs to retrieve and manipulate the data provided.
In This Section
- User Credentials and Access to Data Sources in Server Explorer.
- Explains how the level of access a user has to a server and its databases determines what kinds of information the user can retrieve and manipulate.
- Adding New Data Connections in Server Explorer
- Gives procedures for creating data connections in Server Explorer.
- Adding New Servers in Server Explorer
- Gives procedures for displaying links to servers and their databases in Server Explorer.
- Creating a New SQL Server Database in Server Explorer
- Explains how to create a SQL Server databases in Server Explorer.
- Refreshing a Database Connection in Server Explorer
- Explains how to repaint Server Explorer with current data connections and database links.
- Viewing Connection and Server Properties
- Explains how to display the properties of a Server Explorer node or item.
- Data Link Properties Dialog Box
- Use this dialog box to display new database connections in Server Explorer.
- Server Explorer Window
- Use this dialog box to display a server link in Server Explorer.
- Connecting to Remote Resources with Server Explorer
- Introduces Server Explorer, and directs you to topics on how to configure and use this tool window.
- Databases in Server Explorer
- Provides guidance on understanding and using database connections.
- Adding Items from Server Explorer
- Gives procedures for dragging items from Server Explorer to your projects, thus creating data components preconfigured to reference those data sources.
- Managing Data with Database Projects
- Provides links to topics on creating and managing database projects in Solution Explorer.
- Visual Database Tools
- Provides links to topics explaining how Visual Database Tools can help you create and manage databases and design data interface components for your applications.