How can access to another PC in Homegroup (Win10) with SQL Server Developer 2017

SQL Server Administration
1

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)

(Microsoft SQL Server, Error: 5)

Acceso denegado

Please, I need help about this error

Thank you

2

This looks very much like the error you get

3

Yes, is the same message, the problem is how can I resolve that?

Thanks
Best regards

4

Try connection using the IP address or add an entry in your hosts file to resolve the name.

5

Thanks Jotorre, but I am new in this profile and I don't know how can I do
that, if you can more explicit for me, please HELP ME

Best regards
Hector

6

you are asking about some networking issues. this is a SQL Server forum but ..

  1. from computer #1 open command window and find ip address
    ipconfig
  2. from computer #2 open command window and find ip address
    ipconfig
  3. from computer #1 open command ping ip address of computer #2
    for example: ping 10.1.10.666
    Does it report a successful ping?
  4. from computer #2 open command ping ip address of computer #1
    for example: ping 10.1.10.555
    Does it report a successful ping?
7

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

Best regards, and happy new year Yosiasz

8
  1. right click on your server, then select Properties.
  2. Click on Security and what does Server Authentication say?
9

10

Not asking for properties of a login but properties on a server.

  1. right click on your server, then select Properties.
  2. Click on Security and what does Server Authentication say?
11

Server Authentication don't appear, look at that:

imagen.png783×374 16.7 KB

12

You need to Right click on the SERVER

Unrelated but: I hate the Flat Icons in 2016 SSMS ... :frowning:

13

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

1 Like
14

Thank you Stephenbaer, I have resolved the problem, your help was very
important for me.

Best regards
Hector