1

Topic: Problem with connection to a remote server.

There is a computer, is accessible by name and ip on a network, work  folders and .
it is disconnected
On it it is installed MS a SQL Server express 2012
Access protocols to a sequel included.
I try to be connected to it from other computer, I receive an error.
In what there can be a problem?
Thanks.

2

Re: Problem with connection to a remote server.

On a network why that does not see copies
Only a computer name
Though on it two

3

Re: Problem with connection to a remote server.

MSSQLAndDotNet;
At you a named instance.
They it is normal  on non-standard port, look on a broad gull on what port started the server and be connected on the necessary port

4

Re: Problem with connection to a remote server.

felix_ff wrote:

MSSQLAndDotNet;
At you a named instance.
They it is normal  on non-standard port, look on a broad gull on what port started the server and be connected on the necessary port

Understood
Now I will look
And by the way on r win 10 home if it matters

5

Re: Problem with connection to a remote server.

MSSQLAndDotNet;
Has no, if the server version> = 2012 can look in

select * from sys.dm_tcp_listener_states where [is_ipv4] = 1 and [state] = 0

6

Re: Problem with connection to a remote server.

And if want not to potter with port include SQL Browser and in adjustments of a network configuration in Configuration Manager on a copy in properties would check up that the copy has not been hidden

7

Re: Problem with connection to a remote server.

51423

8

Re: Problem with connection to a remote server.

Removed dynamic port
Added 1433
Launched sql server browser
Hurrah, earned!
felix_ff, thanks!

9

Re: Problem with connection to a remote server.

MSSQLAndDotNet wrote:

removed dynamic port
Added 1433

It was superfluous
And the port was not dynamic, and quite to itself fixed: "To use dynamic ports, set to 0", and it at you was not a zero, and 51423).
At you launched SQL Browser solves a connection problem to named .

10

Re: Problem with connection to a remote server.

MSSQLAndDotNet wrote:

removed dynamic port
Added 1433

And on this computer 2 copies, one of which ? And both now on 1433? Wonderfully.
Now only one of  can be launched, the second not  generally because of the occupied port. Also will be connected generally all only to that launched, it is unimportant, whether it is specified in a line of connection  or named

11

Re: Problem with connection to a remote server.

Yes, all understood
Thanks
https://technet.microsoft.com/ru-ru/library/ms181087 (v=sql.105) .aspx?f=255&MSPPError=-2147217396