I can not connect to my server in SQL Server 2014 network

Question

I can not connect to my server in SQL Server 2014 network

Navigation

#1 by (1 votes)

0

Hello everyone I have the following problem: I am connecting to my server sql server (use sql server 2014) and is able to connect using the ip address of the server (eg 192.168.1.x \ SQLEXPRESS). But when I try to connect to using the server name (eg MiServer \ SQLEXPRESS) it does not connect. The error number 26 says that the server was not found or was not accessible. It must be said that I have configured the server to support remote connections and the SQLBrowser is also configured. Port 1433 is also enabled. The windows firewall is also configured to allow connection through the port. As additional data: If I disable the windows firewall there if I can enter. I hope you can help me ... Thank you

sql sql-server

asked by edusito87 01.09.2018 в 07:40

source

1 answer

text centered on img with responsive and within a link Problems with header () in an iteration to check the login

score 1 · Answer 1

Have you enabled named pipes? you can find it in SQL SERVER CONFIGURATION MANAGER - > SQL Server Network Configuration - > SQLEXPRESS protocols

If you want you can also copy the following in a bat file and run it as an administrator on the server. It opens all the ports of the SQL in case you have any left.

@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer"
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection"
@echo Enabling conventional SQL Server Service Broker port 4022
netsh firewall set portopening TCP 4022 "SQL Service Broker"
@echo Enabling Transact-SQL Debugger/RPC port 135
netsh firewall set portopening TCP 135 "SQL Debugger/RPC"
@echo =========  Analysis Services Ports  ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services"
@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser"
@echo =========  Misc Applications  ==============
@echo Enabling HTTP port 80
netsh firewall set portopening TCP 80 "HTTP"
@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL"
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser"
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

I hope you serve