Hello and welcome to this video.
This is part two of configuring a third party database connection.
In this part, we are going to connect to a third party database with Oracle SQL Developer and the third
party database.
I'll be connecting to a microsoft SQL Server.
First I need to do is connect to the third party database.
So I'm going to click on Microsoft SQL Server here and I'll click on the SQL Server 2014 Management
Studio.
This is the management tool that we use to connect to Microsoft SQL Server.
So make sure you've got the Windows authentication.
That was the authentication method I chose when I installed SQL Server.
So click Connect and next first thing we need to do, we need to activate the account.
The S.A is a system administration account.
So on the security, click security, there click logins and the SCA account.
You may have a Red Cross next to that.
I've already enabled mine, so that's why that cross is not what you need to do is right click on it
go properties by default when you install it, it also adds a password.
So in order for you to set a new password, just highlight this, delete it, highlight that, delete
it into entire new password.
Confirm the new password.
This one here just enforces password policy.
I will leave that checked and then just click.
Okay.
Once you've changed the password, once the password has been changed.
The next thing we need to do right click here and go properties and click within the properties.
You need to click security.
And when I installed this SQL Server, I only had Windows authentication mode because now I want to
connect from Oracle Secure Developer.
I have changed the mode to SQL Server and Windows Authentication, so make sure you have your set to
SQL Server and Windows Authentication mode.
Okay.
You need to do that once you don't click.
Okay, I've already done that, so I don't need to do that.
I can click, okay.
If you don't do that, you will not be able to connect to the SQL Server from Oracle as SQL developer.
The next thing we need to do, we need to make sure that the TCP IP protocol is enabled.
So to do that, you go to our programs and you click on the SQL Server, Microsoft SQL Server and click
on the Configuration Tool.
There is a SQL Server 2014 Configuration Manager.
Click on that and click yes if you're given a prompt.
So this is the SQL Server Configuration Manager.
So once you're in there, make sure you've got your SQL Server selected.
So you have SQL Server configuration manager and make sure where you've called SQL Server Network Configuration.
Click on this to expand and make sure you've got protocols for SQL Express selected.
So this shared memories are enabled by default.
TCP IP is not enabled by default, so you need to enable it.
I've already enabled it.
So to enable it just right click and click enable.
I've already enabled it.
Once you enable it, you will get a prompt to restart the services.
So make sure you click okay to do that and to restart the services you click.
Come here, click on that and look for your service, which is this one here.
All you need to do is right click and restart and that will restart the services so that the settings
that you've changed is maintained.
I've already done this, so I'm not going to do that again.
I just wanted to show you how to do that.
So now we've got everything we need in order to connect to this database.
From Oracle SQL Developer.
One more thing.
We need the IP port address.
So to do that, click on this protocol for Express as will Express right click on TCP IP, Click Properties,
Click IP address.
So we need to look for the port number.
If you scroll down, you can see here it's got TCP IP dynamic ports.
Make sure you take note of that port number.
My one is 52514.
Yours may be different.
So once we've got that, just click to exit that.
And now we can go into Oracle SQL Developer and try and make a connection to that third party database.
So click on the plus sign and then you need to give your connection a name, give it a meaningful name.
I'm going to say a SQL
Server, give it a name.
The username will be as a remember we activated the SCA account in SQL Server.
The password would be the password you would have changed it to.
So enter the password and you can click to save.
Next thing you need to do, click on a SQL Server, make sure you've got a SQL Server selected.
Very important.
The port is going to be the port that I just showed you.
So enter that dynamic port number minus five, 2514.
Once you've got that entered, you need to test the connection.
Click test.
Once you get a success, that means your connection has been made.
Click Save.
Once you've got that save click retrieve database and you can see all your database listed.
So this is a database I want to connect to.
I just click connect this connection name already use confirm override.
Okay, I'll say yes, override that.
And now if I expand that, I can now access.
Isn't that amazing?
I can access my SQL Server from inside my Oracle SQL developer.
So this is my adventure works and these are all these are my schemas and my schema database.
Excellent.
So in this video, I have successfully connected to a third party database, which is Microsoft SQL
Server, and I've done that from Oracle and SQL Developer.
Thanks for watching.
Bye for now.