Connecting SQL 2014 Management Studio to SQL Server 2014 Express
Posted on 2014-12-11
I'm very much an SQL noob, so I may not have all the details in my question (though I'll try).
I've been asked to assist a SQL consultant in getting a database uploaded to central location where he can show the database to others.
So far, I've created a virtual machine running Windows 2008 R2, and I've installed SQL Server Express 2014 on this virtual machine. No other software is on the virtual server. I've disabled the firewall on the virtual server. I've enabled dynamic TCP/IP port connections. I can telnet to the server (10.10.10.46) on port 49205 and get a connection. I just really don't know what I'm looking for to enable this and it seems neither does the consultant.
I think I'd just like some assistance with best practices. Per my consultant, all he needs to be able to do is connect to the SQL server using SQL management studio and he'll do some query analyzer thing.
So let's say you install SQL Server Express 2014 on a brand new VM running Win 2008 R2. What changes do you make to make sure that users on the LAN can connect to the SQL Server 2014 Express using Windows authentication (I configured the server to use Windows authentication when I installed SQL Server).