![]() I'm going to create a new database connection by clicking on this link here. ![]() You can see that I'm under DATABASES and Connections. I'm going to scroll down just a little bit. So I'm back here on my Gateway, and I'm in the CONFIGURE section. And let's go ahead and create the database connection. That's all we have to do from here, so I'm going to minimize this Configuration Manager window. But once you've restarted that, you get the TCPIP enabled, you have both of these services running, you don't need SQL Server Agent to run, that can be stopped. This is my SQL Server Instance so I could actually just right-click and Restart here if I need to. If you head back to SQL Server Services, this guy here, when you see that's my instance name here, The SQL Server Item. The easiest way is probably just from this same window. You can restart SQL Server however you like. Now, if you make a change to this, you're going to see a little message appear here saying that you need to restart SQL Server for the change to take effect. By default, it's set to Disabled so all you have to do is you can just double-click or you can right-click and Enable. You want to make sure that when this is selected, this TCPIP Protocol name is Enabled. I didn't change mine so I am using SQLEXPRESS so this is the default instance name for SQLEXPRESS. What ever instance name you chose when you're installing SQL Server, that's what will be listed here. And the next thing you're going to want to do is you want to come down to this SQL Server Network Configuration section here and there should be a "Protocols for" and then some instance name. I'm just going to X out since mine's already set up. So if yours doesn't, what you can do is you can come down on this right-click menu here, select Properties, and on this window here, come over to the Service tab, find the Start Mode and change it to Automatic. So you're going to want to make sure the Start Mode says Automatic. Now in a production environment, you're most likely going to want this SQL Server Browser to start up automatically whenever the computer starts. ![]() So you can actually just right-click and tell it to start. ![]() If not, then we need to actually make sure it's running. So if it says it's running, you're in a good state. This is basically one of the mechanisms that allows Ignition to connect to SQL Server. And when you're here, you're going to want to make sure that the SQL Server Browser is up and running. Once you have this open, the first area you're going to want to take a look at is the SQL Server Services. In Windows, you can just click on the Start menu and start typing SQL Server Configuration Manager and this should appear in the list. So the first thing you're going to want to do is you're going to want to open up the SQL Server Configuration Manager. Now, before I attempt to create a new database connection in Ignition, there are a couple of configuration changes that I need to make in SQL Server. In this lesson, we'll take a look at how to connect Ignition to SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |