Jesse
October 4, 2017, 10:28am
21
Is SQL server agent running? It would be a service.
Yes cos the terminal is running on it and it shows as running in services
QMcKay
October 4, 2017, 11:21am
23
SQL Server Agent does not need to be running; it is not required.
SQL Server (<instancename>) and SQL Server Browser needs to be running.
You need 2 ports open for SQL DB Engine: 1433 TCP, and 1434 UDP.
On the Server, have you enabled Allow Remote Connections to the DB Engine?
Jesse
October 4, 2017, 11:21am
24
Show a screenshot of your SQL Services running. SQL Server Browser needs to be enabled and running as well. Agent is not required sorry I got them mixed up.
And here it is working on the terminal, but I cannot connect remotely
Here it is remotely
QMcKay
October 4, 2017, 12:02pm
27
The SQL Server Browser service is not running.
This don’t jive either …
I was editing it, that’s why its different.
and fuck my life, it was browser. 2 days wasted knew I’m an idiot
goddammit
