My new job has some sql server 2014. I am an Oracle DBA.
I need to help a client.
They are having issues creating the ODBC connection from their laptop to the database server (or whatever MS calls a database)
I have access to MS SQL Server 2014 Management Studio.
Questions: How can I create an ODBC connection to this database on my laptop to test and provide a procedure for the client?
Do I need to create myself a user to test?
(In oracle I would install the client and give them a tnsnames and an alias to use and maybe use tnsping or sqlplus to check the connection)
I use Oracle SQL Develper and it uses jdbc. maybe you can help me setup my first JDBC connection.
EDIT3: Checked if 1433 is enabled and looks like something is connecting to this server;
Proto Local Address Foreign Address State
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
TCP xxx.xx.xx.xxx:3389 xxx.xx.xx.xxx:56010 ESTABLISHED
TCP xxx.xx.xx.xxx:56984 xxx.xx.xx.xxx:2074 ESTABLISHED