0
1
00:00:05,150 --> 00:00:11,450
So the next step in preparing our development environment for this course is to download SQL Server
1

2
00:00:11,450 --> 00:00:12,710
Management Studio.
2

3
00:00:12,740 --> 00:00:18,470
The SQL server database engine was installed with Winrk, so you already have that.
3

4
00:00:18,470 --> 00:00:25,100
But the management studio basically allows you to manage a set of SQL server instances, and it allows
4

5
00:00:25,100 --> 00:00:28,580
you to create databases, execute SQL commands and things like that.
5

6
00:00:28,580 --> 00:00:30,320
And so we need to download this.
6

7
00:00:30,320 --> 00:00:33,710
And all you're going to do is download this file.
7

8
00:00:33,710 --> 00:00:39,110
And we can just go directly to the downloads folder here and execute the setup.
8

9
00:00:39,110 --> 00:00:40,940
And you just click install.
9

10
00:00:40,940 --> 00:00:46,430
And this is going to work with the last several versions of the SQL server database engine.
10

11
00:00:46,730 --> 00:00:50,690
And once the installation is done we can just click the close button.
11

12
00:00:50,690 --> 00:00:57,680
And so once you've installed SQL Server Management Studio 19, we can just go launch it from the Windows
12

13
00:00:57,680 --> 00:00:58,280
Bar.
13

14
00:01:00,430 --> 00:01:02,020
And it should open it.
14

15
00:01:02,020 --> 00:01:05,980
And then it'll ask you to connect to the local SQL server instance.
15

16
00:01:05,980 --> 00:01:11,980
Now when wink installs SQL server, it creates what we call a named instance, which is always the name
16

17
00:01:11,980 --> 00:01:12,670
of the computer.
17

18
00:01:12,670 --> 00:01:14,050
Forward slash WinCC.
18

19
00:01:14,080 --> 00:01:19,300
Once wink is installed, you do not want to change your computer name or it will break the links to
19

20
00:01:19,300 --> 00:01:20,200
SQL server.
20

21
00:01:20,200 --> 00:01:22,390
And it's kind of painful to get it back.
21

22
00:01:22,390 --> 00:01:26,680
So we'll just hit connect and we can see some databases.
22

23
00:01:26,680 --> 00:01:33,250
These are the WinCC databases of the current project that I have open in WinCC Version 8.
23

24
00:01:34,410 --> 00:01:38,760
So go ahead and download Microsoft SQL Server Management Studio.
24

25
00:01:38,760 --> 00:01:45,300
You can use the link in the course resources, or you can just use your favorite search engine and search
25

26
00:01:45,300 --> 00:01:48,420
for download Microsoft SQL Server Management Studio.
26

27
00:01:48,420 --> 00:01:52,140
Once you get the installation done, I'll see you in the next section.