Installing a new 2016 server. Client PCs on the network can't see the SQL instance
Installing a new 2016 server. Loaded SQL Express 2017 onto it and created an instance. I am able to see the instance using SQL Management Studio on the server. Client PCs on the network can't see the SQL instance. I created runs int eh server 2016 firewall following the Microsoft KB and clients still can't see the SQL instance on the network.
ASKER
Thanks, I did try disabling the Windows firewall and no dice
whats about the sql browser service ?
Did you ever go to the SQL Server Configuration Manager check the network configuration? Make sure that named pipes and TCP/IP are both enabled.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sql server browser service was stopped and set to disabled. I enabled it then started it. Client PC still not seeing the SQL server.
ASKER
named pipes and TCP/IP were already enabled, screenshot attached
ASKER
Remote Server Connections were already enabled
How are you setting up the ODBC connections?
ASKER
'netstate' is not recognized as an internal or external command,
operable program or batch file.
C:\Users\Administrator>net
'netstate' is not recognized as an internal or external command,
operable program or batch file.
Capture1.JPG
operable program or batch file.
C:\Users\Administrator>net
'netstate' is not recognized as an internal or external command,
operable program or batch file.
Capture1.JPG
>> netstate -ano | find /i "4460"
Oops, that a typo in the link..
It should be netstat instead of netstate, kindly try and let us know
Oops, that a typo in the link..
It should be netstat instead of netstate, kindly try and let us know
ASKER
Thanks for the help!
Welcome, glad to assist!!
check the sql server browser service if its rin and set to automatic ... also try to disable windows firewall if the first solution didnt work