Microsoft Cloud Authors: Andreas Grabner, Nick Basinger, Kevin Benedict, Pat Romanski, Liz McMillan

Blog Feed Post

How do you add a database connection to Server Explorer in VS 2012?

Report authoring is perhaps one of the most frequently required activities in an enterprise. Knowledge of report authoring is an invaluable asset when one is looking for a job in an enterprise. Before you can write a report you will have to know where your data is and how to get connected to it from your authoring software. Report authors who are not very comfortable with using data on a back end server could use the more powerful and highly interactive Power View reports, but this requires a developer in your organization to create a model for you to work with. Once the model in place it is super easy to create stunning reports. This is only possible on SQL Server 2012 with the reporting services installed in SharePoint integrated mode.

The following is specific to SQL Server Reporting Services, but this is important for any authoring tool. In the following Visual Studio 2012 is presumed and a web project is to be created to demonstrate the use of Report Viewer Control.

Presently the Server Explorer has the following items:


If you do not see Server Explorer you click View in the main menu and click Server Explorer as shown:

Presently there is a connection established with the Adventure Works 2012 database on the SQL Server 2012 named Kailua.

Click Connect to Server item on Server Explorer tool bar shown.

The Add Server window is displayed as shown.

The name of the computer is provided (you provide the name of your computer). Click OK.

Adding a Data Connection

Click Connect to Database toolbar item as shown.

Or you can right click Data Connection and start as well.

Assume that we clicked Connect to Database.

The Add Connection window is displayed as shown.

This is because before getting to the database you must first get connected to the server. Notice that the Microsoft SQL Server (SqlClient) is the default. It can be changed to others by hitting the Change... ellipsis button and following the wizard.

For now accept the default. Click on the handle for Server Name after hitting the Refresh button. You see three servers, a SQL Server 2012 (Kailua); a SQL Server 2008 R2 (Maui) and a SharePoint Server.

Click HODENTEKWIN7\KAILUA to choose the server. The Add Connection window is updated as shown. We accept the default authentication, Windows Authentication.

Click on the handle for the Select or enter a name for the database field to display the drop-down list as shown.

Click Northwind. It could be another database in your case. Click the Test Connection button and verify that the connection was successful as shown.

Click OK on the above message window and click OK on the Add Connection window. The new database connection will be added to the Visual Studio 2012’s Server Explorer as shown.

That is all for now.


My new book uses images / screenshots such as the above to guide you through the learning process. The instructions are very simple and most of the steps are described.

Read the original blog entry...

More Stories By Jayaram Krishnaswamy

Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.

IoT & Smart Cities Stories
When Enterprises started adopting Hadoop-based Big Data environments over the last ten years, they were mainly on-premise deployments. Organizations would spin up and manage large Hadoop clusters, where they would funnel exabytes or petabytes of unstructured data.However, over the last few years the economics of maintaining this enormous infrastructure compared with the elastic scalability of viable cloud options has changed this equation. The growth of cloud storage, cloud-managed big data e...
The platform combines the strengths of Singtel's extensive, intelligent network capabilities with Microsoft's cloud expertise to create a unique solution that sets new standards for IoT applications," said Mr Diomedes Kastanis, Head of IoT at Singtel. "Our solution provides speed, transparency and flexibility, paving the way for a more pervasive use of IoT to accelerate enterprises' digitalisation efforts. AI-powered intelligent connectivity over Microsoft Azure will be the fastest connected pat...
After years of investments and acquisitions, CloudBlue was created with the goal of building the world's only hyperscale digital platform with an increasingly infinite ecosystem and proven go-to-market services. The result? An unmatched platform that helps customers streamline cloud operations, save time and money, and revolutionize their businesses overnight. Today, the platform operates in more than 45 countries and powers more than 200 of the world's largest cloud marketplaces, managing mo...
Your applications have evolved, your computing needs are changing, and your servers have become more and more dense. But your data center hasn't changed so you can't get the benefits of cheaper, better, smaller, faster... until now. Colovore is Silicon Valley's premier provider of high-density colocation solutions that are a perfect fit for companies operating modern, high-performance hardware. No other Bay Area colo provider can match our density, operating efficiency, and ease of scalability.
CloudEXPO has been the M&A capital for Cloud companies for more than a decade with memorable acquisition news stories which came out of CloudEXPO expo floor. DevOpsSUMMIT New York faculty member Greg Bledsoe shared his views on IBM's Red Hat acquisition live from NASDAQ floor. Acquisition news was announced during CloudEXPO New York which took place November 12-13, 2019 in New York City.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha...
The graph represents a network of 1,329 Twitter users whose recent tweets contained "#DevOps", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Thursday, 10 January 2019 at 23:50 UTC. The tweets in the network were tweeted over the 7-hour, 6-minute period from Thursday, 10 January 2019 at 16:29 UTC to Thursday, 10 January 2019 at 23:36 UTC. Additional tweets that were mentioned in this...
Today's workforce is trading their cubicles and corporate desktops in favor of an any-location, any-device work style. And as digital natives make up more and more of the modern workforce, the appetite for user-friendly, cloud-based services grows. The center of work is shifting to the user and to the cloud. But managing a proliferation of SaaS, web, and mobile apps running on any number of clouds and devices is unwieldy and increases security risks. Steve Wilson, Citrix Vice President of Cloud,...
Artificial intelligence, machine learning, neural networks. We're in the midst of a wave of excitement around AI such as hasn't been seen for a few decades. But those previous periods of inflated expectations led to troughs of disappointment. This time is (mostly) different. Applications of AI such as predictive analytics are already decreasing costs and improving reliability of industrial machinery. Pattern recognition can equal or exceed the ability of human experts in some domains. It's devel...