Hi, I have a problem when I try to connect my PC with another PC in my homegroup (Home).
There are two PC's connected correctly in my home and when I looking for the other PC in SQL prompt I see the other PC without problems, but when I select the other PC in the Server Name and try to connect appear this message:
Cannot connect to PCEA.
Additional information:
Error reladonado con la red o espedfico de la instanda mientras se estableda una conexiön con el servidor SQL Server.
No se encontrö el servidor o este no estaba accesible.
Compruebe que el nombre de la instanda es correcto y que SQL Server esta configurado para admitir conexiones remotas.
(provider: Named Pipes Provider, error: 40 - No se pudo abrir una conexiön con SQL Server)
Everithing is OK, I did the two PING and was successful, but what can I do
after this?
The SQL Server when I browse in Network Servers, I can see correcxtly
another PC and I write the Login and Password correct, but the SQL Server
respond to me Access Denied.
I have enabled all security parameters in both PC's, the network work OK
too, but SQL no.
In both PC I have SQL Server Developer 2017 (updated with the last version).
I am crazy with this problem and I think that the solution will be easy,
but I don't know what is the solution.
Thank you for your help Sr., If you have another idea please tell me
The SQL host PC needs a firewall rule that opens the port so that other computers can talk to the SQL service. This is likely the problem. Open TCP port 1433 for basic SQL access.Other services like Reporting Services require additional configuration. More information can be found at: https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspx