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.
Kill DB sessions the easy way with SQLcl
2 months ago