I'm busy setting up a MS SQL Server instance on a Windows Server
The server is Windows Server 2012 R2 and the version of MS SQL Server is 2014 Essentials.
I've installed MS SQL and created my database, I've also installed HeidiSQL to test making connections to the server.
All this software is running off of the same machine.
When I run the MS SQL Management studio it connects to
Server name : SPKWINVMSERVER\SQLSERV Authentication : Windows Authentication
So I've tried to create a login using the management studio
right click Security > New > Login
and I've created the login as
Login name : mssqladmin password : #FongKong123
I gave this user all the server roles for testing and it seemed to create ok.
However when I try to connect to it using this Login I've just created using HeidiSQL it fails
The connection details I'm using in HeidiSQL to connect are
Network type : Microsoft SQL Server (TCP/IP) Hostname : SPKWINVMSERVER\SQLSERV User : mssqladmin Password : #FongKong123 Port : 1433
The above connection seems to work when connecting to the SQL Server on the server itself.
If trying to connect with another computer on the network (also using HeidiSQL) I imagine I won't be able to use SPKWINVMSERVER\SQLSERV as the hostname but it doesn't work on IP address which is in this case 192.168.20.67
Network type : Microsoft SQL Server (TCP/IP) Hostname : 192.168.20.67\SQLSERV User : mssqladmin Password : #FongKong123 Port : 1433
What did I miss?