0 Пользователей и 1 Гость просматривают эту тему.
ЕМНИП надо протокол Named Pipes включить еще...
TITLE: Database Properties------------------------------An error occurred while starting mirroring.------------------------------ADDITIONAL INFORMATION:Alter failed for Database 'xxxxxxxxx'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------The server network address "TCP://server2:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
Активные подключения Имя Локальный адрес Внешний адрес Состояние PID TCP server2:http server2:0 LISTENING 4 [Система] TCP server2:epmap server2:0 LISTENING 696 RpcSs [svchost.exe] TCP server2:microsoft-ds server2:0 LISTENING 4 [Система] TCP server2:1025 server2:0 LISTENING 440 [lsass.exe] TCP server2:1038 server2:0 LISTENING 812 ShellHWDetection [svchost.exe] TCP server2:ms-sql-s server2:0 LISTENING 4020 [sqlservr.exe] TCP server2:ms-olap4 server2:0 LISTENING 1264 [msmdsrv.exe] TCP server2:5022 server2:0 LISTENING 4020 [sqlservr.exe] TCP server2:ms-sql-m server2:0 LISTENING 4020 [sqlservr.exe] TCP server2:netbios-ssn server2:0 LISTENING 4 [Система] TCP server2:ms-sql-s server1:1102 ESTABLISHED 4020 [sqlservr.exe] TCP server2:ms-sql-s server1:1085 ESTABLISHED 4020 [sqlservr.exe] TCP server2:ms-sql-s server1:1070 ESTABLISHED 4020 [sqlservr.exe] TCP server2:1120 server1:netbios-ssn TIME_WAIT 0 TCP server2:1121 server1:netbios-ssn TIME_WAIT 0 UDP server2:isakmp *:* 440 [lsass.exe] UDP server2:microsoft-ds *:* 4 [Система] UDP server2:ms-sql-m *:* 1676 [sqlbrowser.exe] UDP server2:ipsec-msft *:* 440 [lsass.exe] UDP server2:ntp *:* 796 W32Time [svchost.exe] UDP server2:1026 *:* 796 W32Time [svchost.exe] UDP server2:netbios-ns *:* 4 [Система] UDP server2:ntp *:* 796 W32Time [svchost.exe] UDP server2:netbios-dgm *:* 4 [Система]
TCP server2:5022 server2:0 LISTENING 4020
брандмаузер вырублен.на обоих.