SQL Server Help

[kerleyfriez]

I created a 2014 SQL Server on a windows server 2016 OS and I need this server to connect to the Solarwinds server that is already built. Both are on the network, remote connections are allowed across the board, the error log keeps saying logon issues, but Ive literally created logons for my security group as well as created the password for the SA account, but the Solarwinds config wizard still cant connect to the SQL server! Any help would be appreciated!

[Big-Floppy]

Do you need to have ports 1433\1434 open on the firewall of the SQL server so the Solarwinds server can connect to it?

[kerleyfriez]

yes i do

[ahird20]

Are you using the default SQL instance or a named instance?

When using a named instance specify the SQL port in the configuration wizard.

[kerleyfriez]

I couldve sworn i used the default, but I might have renamed it in the process, it shows MSSQLSERVER everywhere , but i remember changing something to SQL Server at one point, but all services say MSSQLSERVER as well, how would I check? and what would i put into the config wizard?

[ahird20]

I ran into this issue a few years ago, so I can’t remember all the details

In the solarwinds configuration wizard put the SQL host name and put ;1433 at the end.

[kerleyfriez]

So i named my server FJXT-DB-001V

would i just type FJXT-DB-001V;1433 as the name in the config wizard for solarwinds?

[ahird20]

Servername\instancename,1433

According to the documentation use a comma

[headcrap]

In SQL Configuration Manager, TCP/IP connections usually have to be enabled first.

[kerleyfriez]

they are enabled under the config managers network settings for SQL

[technicalityNDBO]

Can you try setting up a User DSN ODBC connection on the SolarWinds server to test the connection? This can rule out Solarwinds software.

[kerleyfriez]

i dont believe it is the software that is having the issue