Sql-server – Connect to MS SQL Server

connectivitysql-server-2012

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?

Best Answer

Go to Sql Server Configuration Manager, and check on your client protocols if TCP/IP is enabled.

Related Question