Setting up SQL Server 2012 vs Oracle some version

Setting up a SQL Server 2012 for various reasons. What are the differences vs a set up of a database, that are to be reached from remote. Well...there are some...There is a difference in terminology. And annoying default - but they are surely there for a reason - settings.

 A very good thing is that there is no TNSNAMES.ORA...:-). The Windows authorization mechanism handles all of that. So when everything is in place the remote PC finds everything very smoothly, thru the network.

Every change of the settings are done in various parts of the  SQL Server 2012 Manager-tool.






In SQL Server there is a concept of "USER" and (?) a "LOGIN". So...you couple the USER to a specific LOGIN.

CREATE USER myuser FOR LOGIN myuser;

You have to Enable TCP/IP protocol.

The annoying - imho - is the default setting that disables access from outside. So just find the Enable SQL Server & Windows Authorization.

From zero to an accessible database the time should not be more than 8-12 hours for a regular database knowledgeable person. But bare in mind that that is a straight forward installation.

Ran into trouble immediately...

Trying to install Oracle 12c database on a laptop. Now, the laptop is a laptop that is handled by a service organization. I have no authorization to create a user on that laptop...

So...the creation of the Windows user for the Oracle_Home-processes failed.

Will try again and use the Built-in Windows user.

What is there to do?