Connect to your SQL Server instance, then in the object explorer pane drill down and highlight a container, such as Tables. Then click View => Object Explorer Details from the top menu bar.

If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist below to quickly find, and fix ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.