So for that, I'm going to have to add a password. And this will allow for the SA user name, the super user account. Mixed mode means, in addition to that, you could also use SQL Server authentication, which will allow you to add user names and passwords into SQL Server itself. Windows authentication means it uses the normal Windows sign-in. And here we can set the authentication mode. Almost always you want it on, but your facility may need it to be disabled. Now the SQL Server browser is something that you're going to want to turn on because it's used in a couple of the different authentication sections for Ignition connecting into SQL Server. The default for the full version is SQLSERVER. If you already have SQL installed, it might be something completely different. The default for SQL Express is SQLEXPRESS, but you could change that if you wanted to. And here's where you can change your instance name. All right, so we're going to install the default set here. And it's going to go and check for all the different products that it needs, and then we'll get onto the actual install. All right, so we'll go ahead and say that we want to start installing SQL Server. That way you don't get stuck staring at a computer screen that's doing nothing. Now SQL Server has a little bit lengthier install than some of the other ones, so we're going to be skipping through a couple of the loading screens. And up at the top here you can see that there's a new SQL Server Standalone Installation. So first off, I'm going to go to my Downloads folder where I have my SQL Express and my Management Studio. But it is important to note that we're going to need both the SQL Server Express and the Management Studio. Now, I already have this downloaded, so I'm just going to use mine. And if you scroll down a little bit you can see our links to download SQL Server. And you can see that there's an Express link over on the right-hand side. And then under Products we can go to the SQL Server Editions section. So I'm going to go ahead and open up my browser, and then I'll pop open a new tab here. Now we're going to take a look at installing SQL Server on your computer, specifically the SQL Server Express version.
0 Comments
Leave a Reply. |