Results 1 to 21 of 21
Thread: MSSQL 2008
Hybrid View
-
27th May 2017 12:49 #1Registered User
Join Date: Jun:2013
Location: >.<
Posts: 6,182
MSSQL 2008
(: , ).
: ( , Windows 7 Pro, , ) MSSQL 2008 . 1 - . :

:
-
- named pipes -
- IPv6 ( hosts laptop10 IP localhost - , ping IPv4):
- :Code:C:\Users\laptop>ping laptop10 Pinging laptop10 [fe80::872:3d6e:f5f5:f5ee%16] with 32 bytes of data: Reply from fe80::872:3d6e:f5f5:f5ee%16: time<1ms Reply from fe80::872:3d6e:f5f5:f5ee%16: time<1ms Reply from fe80::872:3d6e:f5f5:f5ee%16: time<1ms Reply from fe80::872:3d6e:f5f5:f5ee%16: time<1ms Ping statistics for fe80::872:3d6e:f5f5:f5ee%16: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms C:\Users\laptop>
Code:C:\Users\laptop>sc query mssqlserver SERVICE_NAME: mssqlserver TYPE : 10 WIN32_OWN_PROCESS STATE : 4 RUNNING (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN) WIN32_EXIT_CODE : 0 (0x0) SERVICE_EXIT_CODE : 0 (0x0) CHECKPOINT : 0x0 WAIT_HINT : 0x0Code:C:\Users\laptop>sqlcmd -L Servers: LAPTOP10 C:\Users\laptop>- ( )Code:C:\Users\laptop>sc query sqlbrowser SERVICE_NAME: sqlbrowser TYPE : 10 WIN32_OWN_PROCESS STATE : 4 RUNNING (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN) WIN32_EXIT_CODE : 0 (0x0) SERVICE_EXIT_CODE : 0 (0x0) CHECKPOINT : 0x0 WAIT_HINT : 0x0 C:\Users\laptop>
- , , , , - - Managment Studio ( - () ).
- - ,
- , DHCP -
- - - , , ( , , ..)
?
, .
-
27th May 2017 16:49 #2
-
27th May 2017 17:26 #3
TCP/IP- SQL-
MSSQLserver
, localhost,Last edited by janko; 27th May 2017 at 17:26.
-
27th May 2017 17:37 #4Registered User
Join Date: Jun:2013
Location: >.<
Posts: 6,182
( 1 ). - .
(mssqlserver) local - .
:Server name "localhost" ?
localhost
127.0.0.1
local
.
ip- 4
ip- 6
( laptop10,1444 ( , , ) - : ; )
.
: Managment Studio- , 100% Managlent Studio .
MSSQL, , .
, , (, , , ..).
- , MSSQL :
TCP !!! .Code:C:\Users\laptop>netstat -ano | findstr 3532 UDP 0.0.0.0:1434 *:* 3532 UDP [::]:1434 *:* 3532 C:\Users\laptop>
-
27th May 2017 22:01 #5Registered User
Join Date: Jan:2005
Location: BG
Posts: 4,903
. localhost\SQLEXPRESS, localhost?
, , ... ...
-
27th May 2017 22:04 #6Registered User
Join Date: Jun:2013
Location: >.<
Posts: 6,182
-
28th May 2017 10:25 #7Registered User
Join Date: Sep:2003
Location: Where you live
Posts: 976
MSSQL, , :
1. : 10.10.10.17, : 1433, 14333. MSSQL ? ,
2. :
C:\Users\laptop>netstat -ano | findstr 3532
UDP 0.0.0.0:1434 *:* 3532
UDP [::]:1434 *:* 3532
, ipV4 ipV6 1434
. , . :
telnet localhost 1433
telnet localhost 14333
telnet 10.10.10.17 1433
telnet 10.10.10.17 14333
telnet localhost 1434
telnet 10.10.10.17 1434
, ...
-
28th May 2017 10:43 #8Registered User
Join Date: Sep:2003
Location: Where you live
Posts: 976
, , : 1433 14333 , 1434. UDP. 1433 ? SQL .
-
28th May 2017 11:01 #9
-
28th May 2017 11:17 #10
, , , . $. SP SQL-a ( , ).
, . , -, (vmware tools ) ..
SP- , - , .. VM, , , 1:1 .
IP -, .
Win-a. .NET-, VC++ ..
.
Last edited by tedych; 28th May 2017 at 11:18.
-
28th May 2017 12:33 #11Registered User
Join Date: Jun:2013
Location: >.<
Posts: 6,182
Windows-a, MSSQL- - .
.
( SP4 ), :
.Code:C:\Users\laptop>netstat -ano | findstr 1896 TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING 1896 TCP 127.0.0.1:1434 0.0.0.0:0 LISTENING 1896 TCP [::]:1433 [::]:0 LISTENING 1896 TCP [::1]:1434 [::]:0 LISTENING 1896 C:\Users\laptop>
, 2 30GB, 600-800GB .
-
28th May 2017 13:44 #12
10.10.10.... 192.168...., ..?
.
TCP/IP .
, .




Reply With Quote

R9 280,
07.05.23 ., 21:28 in